with one request can we get multiple pdf reports

Gold member

posted

I am having one html report. In that report print button is there. when user clicks on print button then it should return 4 PDF's but HTML report data wont be distributed to 4 PDF's. 4 PDF's having 4 different queries with different data but for these parameters are same.

So with one request can we call 4 FEX files which will give 4 PDF's?

Web FOCUS 7.7.03
PDF

Posts: 69 | Registered: May 24, 2013

Ignored post by santu posted

Guru

posted

Do you have Developer Studio?

If so, you should get familiar with the HTML Composer. It will do exactly what you want. Create a form and point the run button to execute the 4 different procedures.

WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs

Posts: 402 | Location: Upland, IN | Registered: June 08, 2012

Ignored post by J posted

Gold member

posted

Sorry for the mistake.

when user clicks on JSP page then it should return 4 PDF report's.

From jsp page 1 request should go.
From webfocus 4 reports have to get.

Web FOCUS 7.7.03
PDF

Posts: 69 | Registered: May 24, 2013

Ignored post by santu posted

Guru

posted

Is that what you really want?

syntax: http ://webservername/ibi_apps/WFServlet?&IBIF_ex=test.fex

WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs

Posts: 402 | Location: Upland, IN | Registered: June 08, 2012

Ignored post by J posted

j.gross

Virtuoso

posted

Something has to fire off four requests, which will be fulfilled by separate agents on the webfocus reporting server, and targeted to different areas of a single page rendered in the browser. Right?

Have the fex called by JSP return an html page (that you created in dev studio), with four target regions (e.g., tabs), and have the page issue (without user action) the four fex calls, targeted to the four respective portions of the page.

That's the big picture. There are lots of details to attend to -- what event triggers the four requests, how to include parameters passed by JSP (if applicable) in those 4 calls, yada yada.

- Jack Gross
WF through 8.1.05

Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005

Ignored post by j.gross posted

Guru

posted

If you are going j.gross's route, the easiest thing to do for the html page created in dev studio is to have four ibi javascript execute calls to the different procedures.

In the documentation the syntax is:

   
IbComposer_execute('reportID', ['outputTarget']);

The code goes in the OnInitialUpdate function.

OR do what I said initially and have a button pointing to the four reports and opening them in different tabs. In the OnInitialUpdate function just click that button so that it is automatically pressed on load.

Both solutions are easy and through the GUI except for OnInitialUpdate. If you don't want the html page to appear, have one of the reports point to _self while the others point to _blank

This message has been edited. Last edited by: J,

WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs

Posts: 402 | Location: Upland, IN | Registered: June 08, 2012

Ignored post by J posted

George Patton

Master

posted

It's quite likely that I misunderstand the issue, but what is so difficult about doing it as a single compound report? That would allow the parameters to be reused throughout and produce 4 outputs ...

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Ignored post by George Patton posted

Gold member

posted

I tried with below as J mentioned.
IbComposer_execute('reportID', ['outputTarget']);

I tried to give the report name as a first argument for IbComposer_execute but it didn't worked for me.
I know reportID means not report name. but i need to open 4 FEX Files as outputs. So these FEX files dont have any report ID right?

I tried with OnInitialUpdate function by writing below lines inside.

window.open(rpt1,'_self');
window.open(rpt2,'_blank');
window.open(rpt3,'_blank');
window.open(rpt4,'_blank');

where rpt1,rpt2,rpt3 and rpt4 are different FEX file URL's. Window.open() solved my problem but Window.open() is proper way to solve it?

I don't know about below syntax.
IbComposer_execute('reportID', ['outputTarget']);

In my case i need to open FEX files. So What will be the reportID for FEX files?

George Patton: I want 4 reports in 4 different PDF's with one click but not in one PDF. I think you misunderstood.

Thanks j-gross and J for your reply.

Web FOCUS 7.7.03
PDF

Posts: 69 | Registered: May 24, 2013

Ignored post by santu posted

Guru

posted

Santu, the ibcomposer function expects the id of a frame that the reports are in,, you could create 4 frames pointing to the reports and hide them.

I wasn't talking about doing window.open. If you point the html composer button to the for reports and by creating a hyperlink through the gui it will execute those reports. Just click in oninitial update.

George's suggestion is probably best unless you absolutely have to have separate documents. In document composer compound report, you could have a table of contents and the user could click on the section they wish.

WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs

Posts: 402 | Location: Upland, IN | Registered: June 08, 2012

Ignored post by J posted

Gold member

posted

Hi J,

Its great information.

Is there any other solution to get the reports as different documents instead of getting one report?

Web FOCUS 7.7.03
PDF

Posts: 69 | Registered: May 24, 2013

Ignored post by santu posted

George Patton

Master

posted

Me, I like to do things the easy way:

Create a file for each report as follows:

First report:

-* File a_test1.fex

-SET &&CTRY=&COUNTRY;
-RUN

TABLE FILE CAR
PRINT DEALER_COST
BY COUNTRY
BY CAR
BY MODEL
WHERE COUNTRY EQ '&&CTRY'
ON TABLE SAVE AS 'C:\TEMP\DEALER.PDF' FORMAT PDF
END
-RUN

EX a_test2.fex
-RUN

The last line of the first report calls the second report.
Now make the second report

-* File a_test2.fex

TABLE FILE CAR
PRINT RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
WHERE COUNTRY EQ '&&CTRY'
ON TABLE SAVE AS 'C:\TEMP\RETAIL.PDF' FORMAT PDF
END
-RUN
-SET &&CTRY='';

! C:\TEMP\DEALER.PDF
-RUN
! C:\TEMP\RETAIL.PDF
-DONE

This should work for as many reports as you want and they will get displayed in sequence at the end of processing. The display phase could be in a separate FEX of course.

If you save as HTML the reports display as side-by-side tabs in the browser, which is kind of neat.

This message has been edited. Last edited by: George Patton,

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Ignored post by George Patton posted

FrankDutch

Virtuoso

posted

You might take a look at the report library function.

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006

Ignored post by FrankDutch posted