Multiple values into one parameter into one pdf multiple pages

Question

Hello,

I have a report with a parameter which allows for multiple values (think of them as IDs for customers) to be passed into the report. All of these IDs have the same numerical data displayed on the report.

How do I set up the report to iterate through all these values and print their respective data on separate pages and stitch them all into one PDF?

Thank you

Answer 1

Hi @Susheel Palakurthi ，
My understanding is, suppose I have a parameter "CalendarYear" with four values 2010, 2011, 2012 and 2013, and you need to export the report to pdf in the order of the values.
First, I select "CalendarYear" in Tablix, right-click to add the row group-parent group-Group by CalendarYear, then delete the parent group "CalendarYear"-Delete only the columns (this will keep the number of your original columns),the operation is only to sort the report by "CalendarYear". Please refer to the following gif file for specific steps：

Second, select the desired value in the parameter and export it to pdf format. At this time, the export orders will be sorted in order of year.
The above is for test reference only.
If you only want to consult information about parameter creation, you can refer to: Tutorial: Adding Parameters to the Report (Report Generator).
If I misunderstood your meaning, please feel free to correct me.
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.