Export Cognos report into Excel & PDF using Buttons

    Export Cognos Report into Excel & PDF using Buttons

Requirment: Export Cognos report in to Excel/PDF if cognos toolbar is hidden, without using default functionality.

Solution: This can be done using drill through functionality.

Insert a Prompt Button in your report, make it Finish type and edit the text with “Export to Excel”.

Click “Export to Excel” text and select Drill through definitions.

In drill through definitions select the same parent report as the target report and change the Format to “Excel 2007”.

In case you have some parameters defined then set the Parameters value also for drill through.

Click ok and do the appropriate formatting of Button accordingly.

Similarly you can create Button for Export to PDF.

For PDF outputs just change the format to PDF.

------------------------END------------------------------------