If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to render multiple pages of a report in different output versions?

Started by actcognosuser, 11 Jan 2010 09:49:06 AM

Previous topic - Next topic

actcognosuser

Hi all,
             I have a report with multiple pages.Is there a way to render the first page as a PDF and the rest of the pages as csv/excel?

Can this be done with render variables?

Also, another question I have is whether I can change the naming of pages in report studio.If i have a report with excel output and pages abc, cde, efg.It is displayed as abc-1,def-2,efg-3.Is there a way to remove these 1,2, 3 numbers?

I'm using version 8.3.

kathirsivan


MFGF

Quote from: kathirsivan on 12 Feb 2010 01:51:55 AM
using render variable u can achieve this :)

Are you sure about this?  I didn't think this was possible - could you share the details of how this can be done?

Thanks,

MF.
Meep!

CognosPaul

Well, you can't run a report in any more than one format at a time. What you can do, however, is use a render variable to determine the report output, pdf, excel, and render specific pages based on what's chosen.

For example, you'd create a String variable called 'Report Output'. The function would be 'reportoutput()'. Add 'PDF', 'XLS', 'singleXLS', 'MHT', 'CSV' and 'XLWA' at choices. For each page you'd set the render variable to Report Output and the outputs in which you want it to be rendered. Lets say Page 1 is set to PDF, while Page 2 is set to the others. If the report was run in PDF only the first page would be rendered. If it was set to XLS the other two would be rendered.

It sounds like you're looking to run the report once and get two files though. That functionality is found in Event Studio. What you could do is build two reports, one for the PDF and the other for the excel. In Event Studio you can run both reports in the correct format, and attach both outputs into the same email.