Your valuable time and suggestions are highly appreciated.
My Requirement I have 3 Reports: Report1, Report2 & Report3.
I want to run these three reports and want 1 output with 3 worksheets containing Report(1) in worksheet 1, Report(2) in worksheet2 and Report(3) in worksheet3.
1 way of doing this is, via DOCUMENT where I can select the output format as xlsx and have separate pages for individual reports (report1, report2, report3).
But......
I am more interested in a more efficient way of achieving the same in any other way. I am trying to achieve this in InfoAssist+
Thank you in advance your inputs.This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8 Windows, All Outputs
July 26, 2018, 07:48 AM
BabakNYC
Here's an example I found in Focal Point. It seems to do what you want. The key syntax is OPEN and CLOSE after the ON TABLE HOLD.
TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 1
ON TABLE PCHOLD FORMAT XLSX OPEN
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report1', $
ENDSTYLE
END
-RUN
TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 2
ON TABLE PCHOLD FORMAT XLSX OPEN
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report2', $
ENDSTYLE
END
-RUN
TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 3
ON TABLE PCHOLD FORMAT XLSX CLOSE
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report3', $
ENDSTYLE
END
This message has been edited. Last edited by: BabakNYC,
WebFOCUS 8206, Unix, Windows
July 27, 2018, 06:11 PM
NewBee...WF8
quote:
Originally posted by BabakNYC: Here's an example I found in Focal Point. It seems to do what you want. The key syntax is OPEN and CLOSE after the ON TABLE HOLD.
TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 1
ON TABLE PCHOLD FORMAT XLSX OPEN
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report1', $
ENDSTYLE
END
-RUN
TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 2
ON TABLE PCHOLD FORMAT XLSX OPEN
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report2', $
ENDSTYLE
END
-RUN
TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 3
ON TABLE PCHOLD FORMAT XLSX CLOSE
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Report3', $
ENDSTYLE
END
Thank you BabakNYC for your inputs. I really appreciate it. Thank you very very much
WebFOCUS 8 Windows, All Outputs
August 17, 2018, 07:45 AM
BI Dev
Hi,
I Am trying to achieve the same functionality using infoassist but not text editor.Can you please tell me how to do this using infoassist?
Regards BI DEV
Webfocus 8105/8202 Windows All Outputs
August 17, 2018, 08:17 AM
Tony A
From the BI Portal (server: port/ibi_apps/), click on the "more" icon.
Locate and click on the "Document" icon.
Add a report to the page shown - either new or existing. Once finished with that report, click on the drop down list on the right which shows "Page 1". This shows what pages you have in the current document and allows you to switch between them.
Click on "New Page" in the drop down menu and repeat the previous step as many times as you need.
On the bottom right, you will see 3 drop down menu buttons. Click on the middle one which should show "Active Report" and choose "MS Excel (XLSX)".
Run your report.
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