question

SusheelPalakurthi-9548 avatar image
0 Votes"
SusheelPalakurthi-9548 asked Joyzhao-MSFT commented

Multiple values into one parameter into one pdf multiple pages

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

sql-server-reporting-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Has your issue been resolve?

0 Votes 0 ·

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @SusheelPalakurthi-9548
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:

89357-10.gif
89336-03.jpg

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.



10.gif (445.4 KiB)
03.jpg (13.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.