Hi Everyone,
Report Studio (Version 8.3)
The report is containing with 3 pages (page1 named as HTML, page2 named as PDF, page3 named as CSV)
each and every page is having different data.
when I execute the report and based on selection (HTML, PDF, CSV), the data should be displayed in different formats.
like when I select the HTML the HTML Page data should be displayed in the HTML format.
when I select the PDF the PDF page data should be displayed in the PDF format.
when I select CSV the CSV page data should be displayed in the CSV format.
Thanks in advance.
Sounds to me that you will need 3 separate report for this. 1 for each format.
Reason being is that Cognos process based on Reports, not Page on Reports. And in a report, you can only display it in 1 format.
Quote from: carvy_49 on 01 Sep 2009 05:08:47 AM
when I execute the report and based on selection (HTML, PDF, CSV), the data should be displayed in different formats.
like when I select the HTML the HTML Page data should be displayed in the HTML format.
when I select the PDF the PDF page data should be displayed in the PDF format.
when I select CSV the CSV page data should be displayed in the CSV format.
Is it right, that when you select...
- HTML... only the HTML-Page should be shown and PDF and CSV should NOT be shown...
- PDF... only the PDF-Page... (and so on)
?
If yes, you don't need to have 3 Report-Pages. You can do this with one Report-Page and conditional blocks. Depending on the Output-Format of the report, you can show different Blocks with different content.
Create 3 report pages - HTML, PDF and XLS.
Each page will have their corrsponding data.
Now create a string variable as :
reportoutput() and add 3 values as PDF,XLS and HTML.
Now use this variable as render variable for each page.
Hope it works...............
Part of what you need to do is as said by cog_user.
In addition you need to explicitly define the output formats.
I saw some where you can mention the output to be different formats using html object.
Good luck with the search.