×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Single display of Multiple reports

Single display of Multiple reports

Single display of Multiple reports

(OP)
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)

RE: Single display of Multiple reports

There is new COMPOUND DOCUMENT function, but you would need to contact IBI for details.

RE: Single display of Multiple reports

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

RE: Single display of Multiple reports

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 .

RE: Single display of Multiple reports

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

RE: Single display of Multiple reports

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close