[SOLVED] Multiple Reports in Multiple ExcelL Tabs

Hello Everyone,

I have searched the forum but still not getting what I need.

I want to display like 10 webfocus reports in one tab and 10 reports in other tab. The e.g. I have shared below is showing 2 on each tab but it isn't working can someone tell me what am I missing.

 

TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 1
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report1', $
ENDSTYLE
END
-RUN

TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 2
ON TABLE PCHOLD FORMAT EXL2K CLOSE
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report1', $
ENDSTYLE
END
-RUN


TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 3
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report2', $
ENDSTYLE
END
-RUN
TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 4
ON TABLE PCHOLD FORMAT EXL2K CLOSE
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report2', $
ENDSTYLE
END
-RUN

Thanks is advance.
Gaurav Tyagi

This message has been edited. Last edited by: <Kathryn Henning>,

WebFOCUS 8.1.05
Windows, All Outputs

Posts: 58 | Registered: November 19, 2014

Tomsweb

Master

posted

Hide Post

Your first report (tab) should be a straught-up table request, like you've done.

The second tab should be like this example...
http://forums.informationbuild...371018331#3371018331

Tom

Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36

Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006

Ignored post by Tomsweb posted

Show Post

Gaurav

Gold member

posted

Hide Post

Hello Tom,

Thanks for your response.

Can you please make some changes in the code I have pasted. I don't get exactly what I need to do to make it work. Loops will run same reports again but I have all different reports.

Thanks & regards,
Gaurav Tyagi

WebFOCUS 8.1.05
Windows, All Outputs

Posts: 58 | Registered: November 19, 2014

Ignored post by Gaurav posted

Show Post

Waz

Expert

posted

Hide Post

You need to understand how a compound report works.

You only have one OPEN and one CLOSE statement.

With EXL2K, and TABLE FILE where the previous compound command does not have a NOBREAK will be moved to a new TAB.

Play around with your sample, and remove that extra CLOSE and OPEN

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!