HTML Compound Report....

GinnyJakes

Expert

posted

Sam,

You can have multiple html outputs in the same focexec and they will all show up on the output page. Try doing 2 or 3 of your reports and see what you get.

In 7.6, you can use the PDF Layout Painter to produced compound html as well as pdf and excel.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

Platinum Member

posted

it's not multiple its dynamic...

WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI

Posts: 133 | Registered: May 12, 2007

Ignored post by focuzsambit posted

GinnyJakes

Expert

posted

The title of your topic is 'compound'. That implies multiple. You can still have multiple and dynamic.

Could you please explain what you want in more detail.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

Darin Lee

Virtuoso

posted

As Ginny states, if you run 2 or 10 or however many number of HTML reports in one fex, they all show up one after the other. No need to use -HTMLFORM or !IBI.FIL.HOLD or any of that. Just put your TABLE request in a counted loop and away you go.

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Platinum Member

posted

darin..i thought it will work in that way...but to my surprise when i printed from file car twice simultaneously it's showing only the first print....
i am on 7.1.4
Is any environmental setting required ??

WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI

Posts: 133 | Registered: May 12, 2007

Ignored post by focuzsambit posted

FrankDutch

Virtuoso

posted

F

If you combine two reports into on script they both will show up in your report, but your styling will not always work well.
If you create the first report with a footing in bold it might happen that the second report show up in bold for the whole report.

Try posting your whole fex here and let me take a view on it to see what might be the problem.

	*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

Platinum Member

posted

  
TABLE FILE CAR
SUM 
DEALER_COST
BY COUNTRY
END
TABLE FILE CAR
SUM 
DEALER_COST
BY COUNTRY
END
-EXIT

WHEN I RUN THIS CODE, IT'S ONLY SHOWING THE FIRST REPORT ?

WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI

Posts: 133 | Registered: May 12, 2007

Ignored post by focuzsambit posted

Alan B

Virtuoso

posted

This approach has always worked for me, and I have never had to change any settings.

Additionally, you can intersperse the requests with HTML, which can be done in a DM loop to build up as many reports (within reason) as you want:

-HTMLFORM BEGIN
<html>
<head>
<title>My reports</title>
</head>
<body>
<div style="width:70%;;margin-left:30px;">
<div style="float:left;">
<p>first report</p>
-HTMLFORM END
TABLE FILE CAR
SUM
DEALER_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT HTMTABLE
END
-RUN
-HTMLFORM BEGIN
</div>
<div style="float:right;">
<p>second report</p>
-HTMLFORM END
TABLE FILE CAR
SUM
DEALER_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT HTMTABLE
END
-HTMLFORM BEGIN
</div>
</div>
</body>
</html>
-HTMLFORM END

Alan.
WF 7.705/8.007

Posts: 1451 | Location: Portugal | Registered: February 07, 2007

Ignored post by Alan B posted

FrankDutch

Virtuoso

posted

F

How do you know it is showing the first report?
I would change the second (or the first) add a line in both to distinguish the first and second.
And start your fex with the line

-SET &ECHO=ALL;

first report:

HEADING
"this is the first report"
...
WHERE COUNTRY EQ 'ITALY';

second report:
HEADING
"this is the second report"
...
WHERE COUNTRY NE 'ITALY';
..

	*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

FortuneCookie

Platinum Member

posted

This should work for you:
http://techsupport.informationbuilders.com/tech/wbf/wbf_tcn_086.html

Posts: 140 | Registered: May 02, 2007

Ignored post by FortuneCookie posted

Platinum Member

posted

Frank...it's the first one...i checked.
after the first orint it's going for PCHOLD...so 2nd is not coming....

Do we have any concept of OPEN,NOBREAK,CLOSE IN BROWSER, by chance ?

tks/sam

WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI

Posts: 133 | Registered: May 12, 2007

Ignored post by focuzsambit posted

Platinum Member

posted

it seems that something going weird in 714 for me...because simple prininting 1 by 1 is not working for me but for others even on same instalation..
btw i have done through dynamic printing in HTMLFORM...

thanks for advices...

WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI

Posts: 133 | Registered: May 12, 2007

Ignored post by focuzsambit posted

Expert

posted

quote:
it seems that something going weird in 714 for me

You do surprise me

I "wonder" why that is. lol

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Platinum Member

posted

It was working for me 2 months back...now it's not.

hope they are not de-comissioning 714...

WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI

Posts: 133 | Registered: May 12, 2007

Ignored post by focuzsambit posted

Expert

posted

quote:
It was working for me 2 months back...now it's not

So what's the common factor here?

Oh I know, you lol

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Platinum Member

posted

and......... the program and IBI w/f....

WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI

Posts: 133 | Registered: May 12, 2007

Ignored post by focuzsambit posted

Expert

posted

Ok, perhaps this was too subtle.

If it was working for you two months ago, what has changed?

Have you upgraded? Have you made any changes to the configuration? Have you made changes to the program? etc. etc.

Answer these questions and find out what the variable has been .... and then you might find your answer?

For everyone else that has responded, the process has worked as expected, in various releases, on various platforms and in various browsers. So there must be something wrong with your configuration or maybe something else on your installation. Where ever the problem lies, only you are experiencing it.

It is worth you spending some time checking this out because you will soon be saying that something else doesn't work for you and everyone else will be saying "no problem for me". Until then every problem you come across that should work for you but doesn't will start you questioning what is wrong. I would suggest that it would be a waste of time anyone else responding to your pleas if you don't get your installation sorted because we will just end up going down the same route again.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Platinum Member

posted

ohk...

WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI

Posts: 133 | Registered: May 12, 2007

Ignored post by focuzsambit posted

GamP

Virtuoso

posted

I experience the same as Sam does, but also the same as Tony.
Difference is (and I do not know why this is), I see just the first report if I run the procedure from within DevStudio (although the view source tells me both requests are being run). If I run the procedure from the web-browser, I see both.
Maybe someone smarter than me has an answer to why this is?
Tried this in 71x as well as in 764. I get the same results in all these environments.

GamP

- Using AS 8.2.01 on Windows 10 - IE11.
	in Focus since 1988

Posts: 1961 | Location: Netherlands | Registered: September 25, 2007

Ignored post by GamP posted

Platinum Member

posted

there is something weird in wf7xx...

WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI

Posts: 133 | Registered: May 12, 2007

Ignored post by focuzsambit posted

Expert

posted

I see both reports either way of running the them.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

GinnyJakes

Expert

posted

Sam,

If you think there is something wrong with your installation and the answers/comments provided by the folks on the forum do not help you, then by all means open a case with IBI. I, for one, am tired of all this bickering.

BTW, I reproduced the Dev. Studio issue by having 'Message Viewer On' next to the run arrow. When on, I only saw the first report though both ran based on the stats in the message viewer panel. When off, I saw both reports.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

gregv

Guru

posted

This runs show 2 reports side-by-side for me, locally, on 7.1.7 from Dev Studio and browser.

Greg

current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8

Posts: 274 | Location: Boston/New England | Registered: February 12, 2006

Ignored post by gregv posted

Platinum Member

posted

Ginny...same with me...when i turn off message viewer, bot are coming....thanks !

WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI

Posts: 133 | Registered: May 12, 2007

Ignored post by focuzsambit posted