WF Version 7.1.3 on UNIX

Hello all,

I have a problem with a compound report. I have 5 pdf reports in separate FEXs that all run fine independently. I want to string them together into a single pdf document. Within each report, I used ON TABLE PCHOLD FORMAT PDF.

So, to create the compound report I tried to use:

SET COMPOUND=OPEN
-INCLUDE PDFREPORT1
-INCLUDE PDFREPORT2
-INCLUDE PDFREPORT3
-INCLUDE PDFREPORT4
SET COMPOUND=CLOSE
-INCLUDE PDFREPORT5

I get back an HTML page with the following warnings/messages. Changing the subhead text (which is in each report) has no effect, though I haven't tried removing them altogether. It looks like the report is running, but the warning is suppressing the pdf report. Any ideas.

0 NUMBER OF RECORDS IN TABLE= 66350 LINES= 66350
0 NUMBER OF RECORDS IN TABLE= 66350 LINES= 66350
0 ERROR AT OR NEAR LINE 36 IN PROCEDURE ZAPP0003FOCEXEC *
(FOC096) WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT
0 ERROR AT OR NEAR LINE 38 IN PROCEDURE ZAPP0003FOCEXEC *
(FOC096) WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT
0 NUMBER OF RECORDS IN TABLE= 31646 LINES= 34
0 ERROR AT OR NEAR LINE 34 IN PROCEDURE ZAPP0004FOCEXEC *
(FOC096) WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT
0 NUMBER OF RECORDS IN TABLE= 31646 LINES= 7
0 ERROR AT OR NEAR LINE 39 IN PROCEDURE ZAPP0005FOCEXEC *
(FOC096) WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT
0 NUMBER OF RECORDS IN TABLE= 29636 LINES= 12
0 ERROR AT OR NEAR LINE 39 IN PROCEDURE ZAPP0006FOCEXEC *
(FOC096) WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT
0 NUMBER OF RECORDS IN TABLE= 29636 LINES= 40
0 ERROR AT OR NEAR LINE 37 IN PROCEDURE ZAPP0007FOCEXEC *
(FOC096) WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT
0 ERROR AT OR NEAR LINE 39 IN PROCEDURE ZAPP0007FOCEXEC *
(FOC096) WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT
0 NUMBER OF RECORDS IN TABLE= 31646 LINES= 173

The first thing I'd try is to stick a -RUN right after each of the two SET COMPOUND commands. I'd also stick a -RUN after every report within those -INCLUDEs.

You also have the 'close' before the last report. I've found the only way to get the compound report to display is to edit the last report and change the pchold format pdf to be
on table set online-fmt pdf
and close the compound report within the last report not outside the report. Of course there may be better ways.

The code should work as is. Here's an example that works, with SET COMPOUND not set with an ON TABLE command:

-SET &ECHO=ALL;

SET PAGE-NUM=OFF
-RUN

-* Report 1 --------------------------------------

SET COMPOUND = OPEN
-RUN

TABLE FILE CENTORD
HEADING
"Sales Report "
"Page<TABPAGENO"
" "
SUM LINEPRICE
BY PRODCAT
ON TABLE SET STYLE *
TYPE=REPORT, FONT='ARIAL', SIZE=8, COLOR=BLUE, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END
-RUN

-* Report 2 --------------------------------------

TABLE FILE CENTORD
HEADING
"Sales Report "
"Page<TABPAGENO"
" "
SUM LINEPRICE
BY PRODCAT
ON TABLE SET STYLE *
TYPE=REPORT, FONT='ARIAL', SIZE=8, COLOR=RED, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END
-RUN

-* Report 3 --------------------------------------

SET COMPOUND = CLOSE
-RUN

TABLE FILE CENTORD
HEADING
"Sales Report "
"Page<TABPAGENO"
" "
SUM LINEPRICE
BY PRODCAT
ON TABLE SET STYLE *
TYPE=REPORT, FONT='ARIAL', SIZE=8, COLOR=GREEN, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END
-RUN

Thank you to all who replied. I have tried this a few ways now and cannot get it to work properly.

1. I stuck in the -RUN after each SET and INCLUDE as suggested. The result was exactly the same.

2. I tried putting the command on the tables as Leah suggested with online-format. No luck that way.

3. When I have this in all 5 procedures:

ON TABLE SET COMPOUND
ON TABLE ONLINE FORMAT PDF

I get a compound HTML report. Oddly, I get a reports with those commands, but if I put in the OPEN and CLOSE at the first and last report (as I thought it should work), I get no report and the warning messages.

I am open to any other suggestions. Thanks.

Back to the original problem...do you have Subfoots and Subheads? And if so..can you post a piece of the code that mentions them?

ON COLLEGE_TYPE SUBHEAD AS 'College Type'
"COLLEGE_TYPE"
ON STVCOLL_DESC SUBHEAD AS 'College Name'
"STVCOLL_DESC"

NOTE: There should be a < symbol before the COLLEGE_TYPE and STVCOLL_DESC on the second line of each, but it did not display correctly in the post, so I took it out.

With COLLEGE_TYPE and STVCOLL_DESC as BY fields in the body of the report. There may be NULL values in these by fields. As the reports display in pdf if run one-by-one, I assumed this was the case and that this message is merely a "warning" rather than an "error".


BTW: With regard to my previous post, I get the "compound" HTML report with all of the compound and formatting statements taken out completely, so I guess that wasn't really an improvement, alas.

This message has been edited. Last edited by: Brett Magill,

quote:

ON COLLEGE_TYPE SUBHEAD AS 'College Type'

is not correct syntax. It should be:

ON COLLEGE_TYPE SUBHEAD
"<COLLEGE_TYPE"
ON STVCOLL_DESC SUBHEAD
"<STVCOLL_DESC"

Francis wrote:

It should be:

ON COLLEGE_TYPE SUBHEAD
"ON STVCOLL_DESC SUBHEAD
"
Yes. That was the problem. It now works just fine with ON TABLE PCHOLD FORMAT PDF in each report and:

SET COMPOUND=OPEN
-INCLUDE PDFREPORT1
-INCLUDE PDFREPORT2
-INCLUDE PDFREPORT3
-INCLUDE PDFREPORT4
SET COMPOUND=CLOSE
-INCLUDE PDFREPORT5

Thank you to everyone who responded.

Here is a rhetorical question and a bit of a complaint. Why would WF let this run perfectly in PDF when each of these reports was run individually and only produce an error when I tried to create the compound report? Certainly had me looking in the wrong place for the problem.

Brett Magill
Office of Planning and Decision Resources
Saint Louis University
WF Version 7.1.3 on UNIX

I think the error was probably generated, but the PDF got created anyway. Did you try running one of the individual reports as HTMl and viewed the source of the HTML rpeort, I think you'd see the error.

Francis...I'm sure this has been mentioned before...but how do you get < symbol
to comeout right in the posting.

I ALWAYS put my program code in between

[code]

[/code]

tags. And I set the Options to "Disable HTML" if there's HTML in my code.

Thanks

Brett,

I have an alternative answer to your rhetorical question. The WebFOCUS works in mysterious ways. Might as well get used to it.