Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Single display of Multiple reports

Status
Not open for further replies.

pvuppa1

Programmer
Nov 14, 2003
61
US
Can anyone tell me how to display multiple reports in one single report(WEBFOCUS 4.3.6) So far i tried
-TYPE WEBFOCUS CGIVAR IBIWF_mreports=index
TABLE FILE .....
COUNT ID AS REPCOUNT1
WHERE MYFIELD1=&PAR1
HEADER
...
ON TABLE PCHOLD FORMAT PDF
END
-RUN
TABLE FILE ..
COUNT ID AS REPCOUNT2
WHERE MYFIELD2=&PAR1
HEADER..
ON TABLE PCHOLD FORMAT PDF
END
it still dont work..SOMETIMES when i run it opens one report and if i close it it opens the next report. Any way of viewing it in a single page.(PDF or HTML)
 
There is new COMPOUND DOCUMENT function, but you would need to contact IBI for details.
 
Hellow! My name is Zushi.

You can

-TYPE WEBFOCUS CGIVAR IBIWF_mreports=index
-TYPE WEBFOCUS CGIVAR IBIWF_mprefix=TEST
TABLE FILE .....
COUNT ID AS REPCOUNT1
WHERE MYFIELD1=&PAR1
HEADER
...
ON TABLE PCHOLD FORMAT PDF
END
-RUN
-TYPE WEBFOCUS CGIVAR IBIWF_mprefix=TEST
TABLE FILE ..
COUNT ID AS REPCOUNT2
WHERE MYFIELD2=&PAR1
HEADER..
ON TABLE PCHOLD FORMAT PDF
END
 
1/ Save them in HTMLTABLE format
1ST REPORT "ON TABLE HOLD AS 'XXX' FORMAT HTMLTABLE"
2nd REPORT "ON TABLE HOLD AS 'YYY' FORMAT HTMLTABLE"

2/ AT THE END PUT THESE LINES WHERE abcdef IS AN HTML FILE NAMED abcdef.htm

END
-RUN;
-HTMLFORM abcdef

abcdef.htm is a usual html file with all tags, java scripts, etc...
In this file insert this where you want your reports to appear

<!--WEBFOCUS TABLE XXX>
...
...
<!--WEBFOCUS TABLE YYY>


This works perfectly well and I have developped 3 applications using this technique .

 
Hi,

I am having same requirement..

Above may work with the HTML Display.. Can anyone help me, how to work on multiple report for user define format (PDF,EXCEL..)

I mean when user select PDF option, both hold file data should goto the same PDF. But actually what happens for me is, it is taking only the last created HOLD File.

Urgent help isrequired...

Thanx in advance
 
SET COMPOUND=ON

TABLE FILE ...
ON TABLE PCHOLD FORMAT PDF OPEN
END
TABLE FILE ...
ON TABLE PCHOLD FORMAT PDF CLOSE
END

(I havn't tried this in 4.3.6 though)

Hilfendorf gave a good example of using an html version of the report as well
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top