How to get the data in different formats like HTML, PDF, CSV

[carvy_49]

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.

[josepherwin]

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.

[IceTea]

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.

[jatin.popat]

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...............

[dumbell]

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.