Focal Point
heading NOT on first page

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9581050461

April 18, 2006, 12:16 PM
Pam Kratt
heading NOT on first page
I am doing a compound report, so I have the heading appear at the top of the first page but when I add on the 2nd section, the heading appears again and it appears in the middle of the page. So, I want to skip the headings on the 1st page and just have them appear on subsequent pages.
1. I've tried a -IF TABPAGENO NE 1 and skip the headings but it totally ignores the if statement
2. I've tried a WHEN statement at the bottom of the HEADING code and it did not like that at all and gave me an error. WHEN TABPAGENO NE 1
3. I tried putting a when statement in the stylesheet on the HEADING= lines but that just changed the formatting, it didn't drop the headings.

Suggestions?? This should be an easy problem, I just can't get it to work.

Thanks.


webfocus 8.105M; os: windows; pdf, html, exl2k, csv
April 18, 2006, 02:32 PM
Prarie
Try
WHEN TABPAGENO GT 1


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
April 18, 2006, 03:06 PM
Pam Kratt
would I put the when statement in the stylesheet or below the actual heading or somewhere else?


webfocus 8.105M; os: windows; pdf, html, exl2k, csv
April 18, 2006, 03:11 PM
Prarie
After the Heading.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
April 18, 2006, 04:19 PM
Pam Kratt
I got the following error
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: TABPAGENO
0 NUMBER OF RECORDS IN TABLE= 19 LINES= 1
0 ERROR AT OR NEAR LINE 745 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC002) A WORD IS NOT RECOGNIZED: WHEN

This is the heading code:
HEADING
"WELLS FARGO"
"&TITLE1 <40>General Reporting"
"By Industry Class<40>&DATEHEAD"
"&COMPANYID <40>&DATEDISP"
" "
-IF &XACCOUNT NE 'ACTGRP' THEN GOTO PDF11
"ACCOUNT GROUP:<+1> &TITLE2 <0X
&TITLE3"
-GOTO PDF21
-PDF11
"ACCOUNT:<+1> &TITLE2 <0X
&TITLE3"
-PDF21
WHEN TABPAGENO GT 1


webfocus 8.105M; os: windows; pdf, html, exl2k, csv
April 18, 2006, 04:36 PM
Prarie
That may only work with Subfoot and Subhead...I'm sorry.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
April 19, 2006, 09:11 AM
Kamesh
This one works,

TABLE FILE CAR
PRINT CAR MODEL BODYTYPE
BY COUNTRY
ON TABLE HOLD AS TEST
END
-RUN

DEFINE FILE TEST
CNT/I2=IF COUNTRY EQ LAST COUNTRY THEN CNT ELSE CNT +1;
END


TABLE FILE TEST
HEADING
"TEST"
PRINT CAR MODEL BODYTYPE
CNT
BY COUNTRY
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=HEADING,COLOR=WHITE,WHEN=CNT EQ 1,$
ENDSTYLE
END


WFConsultant

WF 8105M on Win7/Tomcat
April 19, 2006, 12:56 PM
Pam Kratt
the color=white did work. I had thought of this a couple of days ago but didn't think it would work because I have 5 or 6 lines for my heading and I thought it would be too much of a gap. Instead, I reduced the amount of room for my graph so that there is not a lot of blank space. Thanks for the suggestion.


webfocus 8.105M; os: windows; pdf, html, exl2k, csv
April 19, 2006, 04:50 PM
Prarie
Yes I thought of that too...glad you got it to work..


In Focus since 1993. WebFOCUS 7.7.03 Win 2003