I have a report that works just fine. The problem is it is hard to read so my user wants be to alternate background color on the table rows.

I open the report in dev studio.
Click options.
Click Style.
Choose Pro Pastel Blue.
Click Apply.

But now when I run the report some of the data is in the wrong columns. It is not even like it is shifted or something. It is just kinda random.

Is this a bug or I am doing something wrong?

Can you post your code?

Did you apply a stylesheet?

There is a simpler way to alternate row colors. From Style, pick Data. On the right side of the wizard, see the section on background color. Select alternating colors and pick the two you want.

You might have to pull out the stuff you added to the stylesheet before till you get it back the way it was before you try my suggestion.

Don't recall ever having that issue, does it jumble with other style options?

quote:

Originally posted by GinnyJakes:

There is a simpler way to alternate row colors. From Style, pick Data. On the right side of the wizard, see the section on background color. Select alternating colors and pick the two you want.

I tried this way. It also destroyed my report.

Then there is something seriously wrong. I would open a case if I were you.

I do this all the time and never have problems. But then I don't have 7.6.6. And is that correct? Didn't know that release was out.

I have open a case. I cannot see anything in the code that could be causing it.

just stick in
TYPE=DATA,COLUMN=SALES,BACKCOLOR=( SILVER WHITE),$
and that should do it, quick and simple.

Susannah,

I have tried with out any success:

TYPE=DATA,COLUMN=SALES,BACKCOLOR=( SILVER WHITE),$

So I resorted to adding a computed field called greyline:

COMPUTE GREYLINE/A1 = IF LAST GREYLINE EQ 'Y' THEN 'N' ELSE 'Y'; NOPRINT

and then add the following to the stylesheet:


TYPE=DATA,BACKCOLOR=RGB(192 192 192), WHEN=GREYLINE EQ 'Y',$

Does this have anything to do with the release I'm on?

Glenda,

I did this on 5.3.3.

Greg, I hate to suggest this but have you tried taking out all the styling and putting it all back in the Report Painter?

Glenda,

Rather than use the "IF ... THEN ... ELSE ..." logic to provide a basic "flip-flop" switch, I use something like this - COMPUTE ALT_LINE/I1 = ABS(ALT_LINE - 1); which produces 1s and 0s alternately.

However, the method Susannah gives above for the alternate row shading is the recommended method and should work in all current releases? so I'm not sure what is going on with your sample.

Can you try this code exactly asis (providing you have the car file )? If you get the same problem then I would call it in as you may have a deeper problem

TABLE FILE CAR
SUM RCOST
    DCOST
 BY COUNTRY
 BY CAR
 BY MODEL
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
  TYPE=DATA, BACKCOLOR=(SILVER WHITE), $
ENDSTYLE
END
-RUN

T

Greg,

I took the sample that I posted above and put it through the same process as you described above, and the output was OK. Not "jumbled".

Please take the sample above, run it without change and then apply your styling to it as you have described above and rerun. If the data is affected as you describe then you, also, have a deep seated problem. If the data is OK then there is something wrong with your code and it would be advisable to post it for us to help you.

If you are not permitted to post your code then you should raise a case with Tech Support for them to assist you. Don't forget to have the normal details (site code, configuration etc.) to hand when you call them, and No, I am not an IB employee .

T

quote:

Originally posted by susannah:
just stick in
TYPE=DATA,COLUMN=SALES,BACKCOLOR=( SILVER WHITE),$
and that should do it, quick and simple.

This does not work for me either. It is not breaking the report, but it is also not alternating the row colors.

Here is the code of my original report:

-* HTML Tool
-* Created by Report Assistant
-* FF Line do not change this line! Field Name
-* FF Line do not change this line! Alias
-* FF Line do not change this line! Format
-* FF Line do not change this line! Segment
-* FF Line do not change this line! ShowFieldTree
-* FF Line do not change this line! displayTree=0
-* J001 J001
-* J002 J002
-* J003 J003
-* J004 J004
JOIN
HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_TYPE AND HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.L_FOLDER
IN HCP_HC_OUTLINETREE
TO MULTIPLE HCP_HC_OUTLINEFILES.HCP_HC_OUTLINEFILES.S_TYPE AND HCP_HC_OUTLINEFILES.HCP_HC_OUTLINEFILES.L_FOLDER
IN HCP_HC_OUTLINEFILES TAG J001
AS J001
END
JOIN
J001.HCP_HC_OUTLINEFILES.S_CODE
IN HCP_HC_OUTLINETREE
TO MULTIPLE HCP_HC_ASSETS.HCP_HC_ASSETS.S_COSTCENTRE
IN HCP_HC_ASSETS TAG J002
AS J002
END
JOIN
J002.HCP_HC_ASSETS.S_CODE
IN HCP_HC_OUTLINETREE
TO MULTIPLE HCP_HC_LOG.HCP_HC_LOG.S_ENTITYCODE
IN HCP_HC_LOG TAG J003
AS J003
END
JOIN
J002.HCP_HC_ASSETS.S_SUPPLIER
IN HCP_HC_OUTLINETREE
TO UNIQUE HCP_HARDCATSUPPLIERS1.HCP_HARDCATSUPPLIERS1.CODE
IN HCP_HARDCATSUPPLIERS1 TAG J004
AS J004
END
DEFINE FILE HCP_HC_OUTLINETREE
-* DEFINE BEGIN NEW_LOC_CD
NEW_LOC_CD/A20 = IF J003.HCP_HC_LOG.S_ITEMTYPE  EQ 'CC'  THEN J003.HCP_HC_LOG.S_TO  ELSE ' ';
-* DEFINE END NEW_LOC_CD
-* DEFINE BEGIN FA_TYP
FA_TYP/A1 = 'E';
-* DEFINE END FA_TYP
-* DEFINE BEGIN NEW_SLOC_CD
NEW_SLOC_CD/I5 = 0;
-* DEFINE END NEW_SLOC_CD
-* DEFINE BEGIN NEW_CMPX_BLDG
NEW_CMPX_BLDG/A8 = IF J003.HCP_HC_LOG.S_ITEMTYPE  EQ 'LN' THEN J003.HCP_HC_LOG.S_TO  ELSE '';
-* DEFINE END NEW_CMPX_BLDG
-* DEFINE BEGIN DOC_ID
DOC_ID/A20 = IF J003.HCP_HC_LOG.S_TYPE  EQ 'AU'  THEN 'AU' || J003.HCP_HC_LOG.S_ENTITYCODE  ELSE J003.HCP_HC_LOG.S_ITEMTYPE  || J003.HCP_HC_LOG.S_ENTITYCODE;
-* DEFINE END DOC_ID
-* DEFINE BEGIN NEW_L_INV_DT
NEW_L_INV_DT/A20 = IF J003.HCP_HC_LOG.S_TYPE  EQ 'AU'  THEN J003.HCP_HC_LOG.D_ACTUALDATE  ELSE '';
-* DEFINE END NEW_L_INV_DT
-* DEFINE BEGIN NEW_MANFR_NM
NEW_MANFR_NM/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED  EQ '000'  THEN UPCASE ( 20, J003.HCP_HC_LOG.S_TO , NEW_MANFR_NM )   ELSE ' ';
-* DEFINE END NEW_MANFR_NM
-* DEFINE BEGIN NEW_MDL_NO
NEW_MDL_NO/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED  EQ 'S_User1' THEN UPCASE ( 20 , J003.HCP_HC_LOG.S_TO  , NEW_MDL_NO )   ELSE ' ';
-* DEFINE END NEW_MDL_NO
-* DEFINE BEGIN NEW_SR_NO
NEW_SR_NO/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED  EQ 'S_SerialNumber'  THEN J003.HCP_HC_LOG.S_TO  ELSE ' ';
-* DEFINE END NEW_SR_NO
-* DEFINE BEGIN NEW_FA_DSCR
NEW_FA_DSCR/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED  EQ 'S_Description'  THEN UPCASE ( 20 , J003.HCP_HC_LOG.S_TO  , NEW_FA_DSCR )  ELSE ' ';
-* DEFINE END NEW_FA_DSCR
-* DEFINE BEGIN NEW_EXTD_DOC_DSCR
NEW_EXTD_DOC_DSCR/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED  EQ '002'  THEN UPCASE ( 20 ,  J003.HCP_HC_LOG.S_TO,NEW_EXTD_DOC_DSCR)  ELSE ' ';
-* DEFINE END NEW_EXTD_DOC_DSCR
-* DEFINE BEGIN NEW_COMMENT
NEW_COMMENT/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED  EQ '004'  THEN UPCASE ( 20 ,  J003.HCP_HC_LOG.S_TO,NEW_EXTD_DOC_DSCR)  ELSE ' ';
-* DEFINE END NEW_COMMENT
-* DEFINE BEGIN NEW_COND_CD
NEW_COND_CD/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED  EQ '001'  THEN J003.HCP_HC_LOG.S_TO ELSE ' ';
-* DEFINE END NEW_COND_CD
-* DEFINE BEGIN BSCNT
BSCNT/D12 = 1;
-* DEFINE END BSCNT
END
TABLE FILE HCP_HC_OUTLINETREE
PRINT J001.HCP_HC_OUTLINEFILES.S_CODE NOPRINT
J002.HCP_HC_ASSETS.S_CODE AS 'Asset No.'
NEW_LOC_CD AS 'Cust'
NEW_CMPX_BLDG AS 'Building'
NEW_FA_DSCR AS 'Asset Desc'
NEW_MANFR_NM AS 'Manufacturer'
NEW_MDL_NO AS 'Model No.'
NEW_SR_NO AS 'Serial No.'
NEW_COND_CD AS 'Condition'
NEW_EXTD_DOC_DSCR AS 'Extended Doc Desc'
NEW_COMMENT AS 'Comments'
J002.HCP_HC_ASSETS.S_SERIALNUMBER NOPRINT
J002.HCP_HC_ASSETS.D_AUDITLAST AS 'NEW_L_INV_DT' NOPRINT
J002.HCP_HC_ASSETS.S_USER2 NOPRINT
J002.HCP_HC_ASSETS.S_DESCRIPTION NOPRINT
J002.HCP_HC_ASSETS.M_PURCHPRICE NOPRINT
HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_FOLDERCODE NOPRINT
J003.HCP_HC_LOG.S_FROM NOPRINT
J003.HCP_HC_LOG.S_TO NOPRINT
J003.HCP_HC_LOG.S_ITEMTYPE NOPRINT
J003.HCP_HC_LOG.S_TYPE NOPRINT
J003.HCP_HC_LOG.S_FIELDCHANGED NOPRINT
J003.HCP_HC_LOG.S_USERID
TOT.BSCNT NOPRINT
BY HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_TYPE NOPRINT
BY J002.HCP_HC_ASSETS.S_CODE NOPRINT
WHERE (HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_TYPE EQ 'CC')
AND (HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_FOLDERCODE EQ '&CLASS')
AND (J003.HCP_HC_LOG.D_ACTUALDATE GE '&START_DATE')
AND (J003.HCP_HC_LOG.S_TYPE NE 'AU');
HEADING
"ORANGE COUNTY COMPTROLLER"
"PROPERTY ACCOUNTING"
"CHANGES CAPTURED DURING INVENTORY"
"CLASS #<HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_DESCRIPTION"
"&DATEtMDYY"
""
FOOTING
"Total Changes Captured: <TOT.BSCNT"
ON TABLE SET STYLE *
TYPE=REPORT,
   GRID=OFF,
   UNITS=IN,
   PAGESIZE='Legal',
   SQUEEZE=ON,
   ORIENTATION=LANDSCAPE,
 $
TYPE= HEADING,LINE=1,JUSTIFY=CENTER,$
TYPE= HEADING,LINE=1,OBJECT=TEXT,ITEM=1,STYLE=BOLD,$
TYPE= HEADING,LINE=2,JUSTIFY=CENTER,$
TYPE= HEADING,LINE=2,OBJECT=TEXT,ITEM=1,STYLE=BOLD,$
TYPE= HEADING,LINE=3,JUSTIFY=CENTER,$
TYPE= HEADING,LINE=3,OBJECT=TEXT,ITEM=1,STYLE=BOLD,$
TYPE= HEADING,LINE=4,JUSTIFY=CENTER,$
TYPE= HEADING,LINE=4,OBJECT=TEXT,ITEM=1,STYLE=BOLD,$
TYPE= HEADING,LINE=4,OBJECT=FIELD,ITEM=1,STYLE=BOLD,$
TYPE= HEADING,LINE=5,JUSTIFY=CENTER,$
TYPE= HEADING,LINE=5,OBJECT=TEXT,ITEM=1,STYLE=BOLD,$
TYPE= HEADING,LINE=6,JUSTIFY=CENTER,$
TYPE= FOOTING,LINE=1,JUSTIFY=RIGHT,$
TYPE= FOOTING,LINE=1,OBJECT=TEXT,ITEM=1,STYLE=BOLD,$
TYPE= FOOTING,LINE=1,OBJECT=FIELD,ITEM=1,STYLE=BOLD,$
TYPE=TITLE, COLUMN=J001.HCP_HC_OUTLINEFILES.S_CODE,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=NEW_LOC_CD,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=NEW_CMPX_BLDG,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=NEW_FA_DSCR,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=NEW_MANFR_NM,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=NEW_MDL_NO,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=NEW_SR_NO,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=NEW_COND_CD,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=NEW_EXTD_DOC_DSCR,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=NEW_COMMENT,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=J002.HCP_HC_ASSETS.S_SERIALNUMBER,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=J002.HCP_HC_ASSETS.D_AUDITLAST,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=J002.HCP_HC_ASSETS.S_USER2,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=J002.HCP_HC_ASSETS.S_DESCRIPTION,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=DATA, COLUMN=J002.HCP_HC_ASSETS.M_PURCHPRICE,
   JUSTIFY=LEFT,
 $
TYPE=TITLE, COLUMN=J002.HCP_HC_ASSETS.M_PURCHPRICE,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_FOLDERCODE,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=J003.HCP_HC_LOG.S_FROM,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=J003.HCP_HC_LOG.S_TO,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=J003.HCP_HC_LOG.S_ITEMTYPE,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=J003.HCP_HC_LOG.S_TYPE,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=J003.HCP_HC_LOG.S_FIELDCHANGED,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=DATA, COLUMN=TOT.BSCNT,
   JUSTIFY=LEFT,
 $
TYPE=TITLE, COLUMN=TOT.BSCNT,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_TYPE,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
TYPE=TITLE, COLUMN=J002.HCP_HC_ASSETS.S_CODE,
   STYLE=BOLD,
   JUSTIFY=CENTER,
 $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
ON TABLE NOTOTAL
END
-* End Report Assistant
  

Here is what the output looks like:



Here is the code after applying the pro pastel blue style:

TABLE FILE HCP_HC_OUTLINETREE
PRINT 
     S_CODE NOPRINT
     S_CODE AS 'Asset No.'
     NEW_LOC_CD AS 'Cust'
     NEW_CMPX_BLDG AS 'Building'
     NEW_FA_DSCR AS 'Asset Desc'
     NEW_MANFR_NM AS 'Manufacturer'
     NEW_MDL_NO AS 'Model No.'
     NEW_SR_NO AS 'Serial No.'
     NEW_COND_CD AS 'Condition'
     NEW_EXTD_DOC_DSCR AS 'Extended Doc Desc'
     NEW_COMMENT AS 'Comments'
     S_SERIALNUMBER NOPRINT
     D_AUDITLAST NOPRINT AS 'NEW_L_INV_DT'
     S_USER2 NOPRINT
     S_DESCRIPTION NOPRINT
     M_PURCHPRICE NOPRINT
     S_FOLDERCODE NOPRINT
     S_FROM NOPRINT
     S_TO NOPRINT
     S_ITEMTYPE NOPRINT
     S_TYPE NOPRINT
     S_FIELDCHANGED NOPRINT
     S_USERID
     TOT.BSCNT NOPRINT
BY S_TYPE NOPRINT
BY S_CODE NOPRINT
HEADING
"ORANGE COUNTY COMPTROLLER"
"PROPERTY ACCOUNTING"
"CHANGES CAPTURED DURING INVENTORY"
"CLASS #<HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_DESCRIPTION"
"&DATEtMDYY"
" "
FOOTING
"Total Changes Captured: <TOT.BSCNT"
WHERE (HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_TYPE EQ 'CC')
AND (HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_FOLDERCODE EQ '&CLASS')
AND (J003.HCP_HC_LOG.D_ACTUALDATE GE '&START_DATE')
AND (J003.HCP_HC_LOG.S_TYPE NE 'AU');
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.250000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=DATA,
     SIZE=8,
     BACKCOLOR=( RGB(234 234 255) 'WHITE' ),
$
TYPE=TITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     SIZE=9,
     COLOR='WHITE',
     BACKCOLOR=RGB(147 172 219),
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=9,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=9,
     STYLE=BOLD,
$
TYPE=HEADING,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     SIZE=12,
     COLOR='WHITE',
     BACKCOLOR=RGB(147 172 219),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=1,
     SIZE=14,
$
TYPE=FOOTING,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     COLOR='WHITE',
     BACKCOLOR=RGB(147 172 219),
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=9,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     SIZE=9,
     COLOR='WHITE',
     BACKCOLOR=RGB(147 172 219),
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     SIZE=8,
     STYLE=BOLD,
$
TYPE=ACROSSVALUE,
     SIZE=8,
     STYLE=BOLD,
$
TYPE=ACROSSTITLE,
     SIZE=8,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     SIZE=9,
     STYLE=BOLD,
$
ENDSTYLE
END
  

Here is what the output looks like:

Your problem has nothing to do with the styling. Somehow between your first code example and second code example, the contents of the field you are printing for Asset No. has changed. And you are sorting on that field. That is why the report looks 'jumbled'. In the second code example, it looks like you are printing the customer code in the asset number column.

See if you can't figure out why that is happening.

The only thing that is different between the code examples in me applying a style.

All I am doing is making a copy of the report.
Applying a style to the copy (so I don't break the original) and running the copy with the style applied.

Your code isn't the same. In the first example you use:
J002.HCP_HC_ASSETS.S_CODE AS 'Asset No.'
in the second you just use S_CODE it is taking that value from the Host file. Your join is:

J001.HCP_HC_OUTLINEFILES.S_CODE
IN HCP_HC_OUTLINETREE
TO MULTIPLE HCP_HC_ASSETS.HCP_HC_ASSETS.S_COSTCENTRE
IN HCP_HC_ASSETS TAG J002
AS J002

It appears that S_CODE in OUTLINEFILES is the same as S_COSTCENTRE in ASSETS.

Pat,

Thanks for vindicating me. The two code sets looked different to me.

There is something strange going on with my Dev Studio. I just tried to add a where statement to a report and I am getting the same symptoms. When I run the report after applying the where statement the columns are all jumbled.

I have case open.