Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Applying style jumbles report data

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Applying style jumbles report data
 Login/Join
 
Platinum Member
posted
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?


prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL

 
Posts: 133 | Location: Orlando, FL | Registered: August 04, 2005Report This Post
Expert
posted Hide Post
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.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Virtuoso
posted Hide Post
Don't recall ever having that issue, does it jumble with other style options?


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Platinum Member
posted Hide Post
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.


prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL

 
Posts: 133 | Location: Orlando, FL | Registered: August 04, 2005Report This Post
Expert
posted Hide Post
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.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Platinum Member
posted Hide Post
I have open a case. I cannot see anything in the code that could be causing it.


prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL

 
Posts: 133 | Location: Orlando, FL | Registered: August 04, 2005Report This Post
Expert
posted Hide Post
just stick in
TYPE=DATA,COLUMN=SALES,BACKCOLOR=( SILVER WHITE),$
and that should do it, quick and simple.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Guru
posted Hide Post
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

In FOCUS Since 1990
Production 8.2 Windows
 
Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004Report This Post
Expert
posted Hide Post
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?


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Expert
posted Hide Post
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 Wink)? If you get the same problem then I would call it in as you may have a deeper problem Frowner

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



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
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 Wink.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Platinum Member
posted Hide Post
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.


prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL

 
Posts: 133 | Location: Orlando, FL | Registered: August 04, 2005Report This Post
Platinum Member
posted Hide Post
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:



prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL

 
Posts: 133 | Location: Orlando, FL | Registered: August 04, 2005Report This Post
Expert
posted Hide Post
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.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Platinum Member
posted Hide Post
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.


prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL

 
Posts: 133 | Location: Orlando, FL | Registered: August 04, 2005Report This Post
Master
posted Hide Post
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
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Expert
posted Hide Post
Pat,

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


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Platinum Member
posted Hide Post
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.


prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL

 
Posts: 133 | Location: Orlando, FL | Registered: August 04, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Applying style jumbles report data

Copyright © 1996-2020 Information Builders