Hi All,

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,

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.

https://webfocusinfocenter.inf...5e-A3AD-25E40CC97E0B

 
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,

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.

https://webfocusinfocenter.inf...5e-A3AD-25E40CC97E0B

 
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

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

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