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

[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]

using render variable u can achieve this

[MFGF]

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.

[PaulM]

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.