Repeating same reports in a PDF with different values in a prompt

[UseCog]

Hi All,

I have list report and It has a filter. But now I have a requirement to create a single PDF file usign this report by combining all the reports which is created from all(each and every) values values of the filter.

eg: my filter is on different designations in the organization and i want to pass each designation to this report and produce a single report which needs to get into a single PDF file

please offer your comments here

Thanks in advance

[billylodz]

not sure if it's what you need
but
if you need to run report for all values from filter, add static choise to prompt like "All"

and in filter for the query add


[xxxxx]=?Parameter?
or
?Parameter?='All'

[UseCog]

I would like to repeat the list report for each parameter selection (after enabling multiselect), to be combined into one report.

I dont think 'All' will help here

any other thoughts

[DSR]

Hi,

The below idea may help you to get your output as you required....

First you need to have that filtered values column in your report/list.

Then you need to create section on this column and then you need to create page breaks on the column which ever your using for the filter.So that your report is going to split based on the different values in your filter column rows/value.

This will give you total report in a single PDF file separating with different values in different pages.

Good luck.... :)

Regards,
Sanjeev

[Sreeni P]

Yeah.... it will helps u to create report,using above approach...

[UseCog]

Thanks Sanjeev and Sreenivas

[billylodz]

create new page in new page set, so the first page will contains total data , and the pages from page set for all possible fileter.

do not use any filter for query

use new query for page set.
and for list/crosstab on page from page set use Master Data Relationship option.