CODEWITHSUNDEEP
sqlreporting-servicesssrs-2008ssrs-2012ssrs-2008-r2
Avinash Kumar
Avinash Kumar

Reputation: 41

how to download all the report from SSRS report

I am new in this field and I am looking to download a single report, but it has more than 200 values in a drop down. Can you guide me how to download all the report with 200 values in one go.

screenshot

Let me give you an overview of what the data looks like:

There are 200 practices and each practices has 5 or 6 providers. I am new in healthcare industry. So, I need to manually click on each practice and each provider and click on the view report to see the report and then download the report. So, we have run the report and click to save in PDF for all 1000+ reports.

We use the standard version of SSRs and we don't have any Enterprise version of it.

Can you guide me what to do in this case? Thanks.

Upvotes: 0

Views: 1988

Answers (3)

sushi
sushi

Reputation: 306

You can also use URL Access and pass in the parameter you want.

Go to http://<server_name>/ReportServer/ and find the report you want.

Then tack on to the end the parameter name and value you want. &param=val&param2=val2

Then add the &rs:Format= command and put your desired extension like CSV.

e.g. http://<server_name>/ReportServer/Pages/ReportViewer.aspx?<my_report_path>&param=val&param2=val2&rs:Format=CSV

https://learn.microsoft.com/en-us/sql/reporting-services/pass-a-report-parameter-within-a-url?view=sql-server-ver15

If you have a lot of parameters, then run this through for loop. Python may be easiest.

Upvotes: 0

StevenWhite
StevenWhite

Reputation: 6034

I would recommend using a data-driven subscription to generate these reports. When you set up the subscription, you can provide a query that lists all the practices. When the subscription runs, it will generate a separate copy of the report using each practice as a parameter value.

You can set the subscription to email the reports or save them in a folder. This way, it doesn't matter so much how long it takes to run and there is much less manual work for you once you set it up.

Upvotes: 1

Matt
Matt

Reputation: 835

You need to amend the report definition so that the filters allow for 'Select Multiple' that way you can select all in the drop downs.

So for example: enter image description here

The option "Allow Multiple Values" would allow you to Select all of that parameter.

Upvotes: 0

Related Questions