Can I customize the export functionality?

Question

User1335966484 posted

I am running SSRS on Sql Server 2008 R2. I am being requested to customize the SSRS export functionality to accomplish the following:

We have a report (with a list of students) from which I linked a drillthrough report, so when you click any student name you get student details (courses, attendance, etc).

The requirement is that, when the user tries to export the main report, present to him the option to include in the exported file the detail reports for all the students displayed in the main report.

So basically, the question is... is there a way to "extend" the export functionality in order to ask the user some questions and based on that return a pdf with results from a linked report which hasn't even been opened yet?

Thanks

Answer 1

User1711366110 posted

So basically, the question is... is there a way to "extend" the export functionality in order to ask the user some questions and based on that return a pdf with results from a linked report which hasn't even been opened yet?

  As per your case,
   you can extend some in-built export functionalities in ssrs report like enable,disable & hide.
But I think ,ssrs don't have an options to add the customized menu in export area.
 For your reference ,check the following links :
1. Click here to know more about the rendering extension types of exporting reports

2. Click here to learn about How to show/hide rendering extensions (export formats)

3.Click here to get the sample code & demo of ASP.Net RDLC (Local SSRS) Report Viewer: Hide (Disable) specific export option (Word / Excel / PDF) from Export button

--
with regards,
Edwin

Answer 2

User1335966484 posted

Thanks Edwin! That sure helped.... One of the links you provided me has a section that says "Other ways to export Reports"...

https://msdn.microsoft.com/en-us/library/dd239307.aspx#OtherWaysExportingReports

Reading here gave me an idea that could solve my problem, but I am not sure if it's possible to do...

Maybe I can export the main report and the set of drillthrough reports using NOT the built-in export function, but just a link somewhere in the main report that would say "Export all reports", and I could set an action to the textbox with a "Go To URL" option, and then do what the link above says to call the drillthrough report one time per student, sending the corresponding parameter (there are several parameters to send, but they will be all the same for all students, excepting the student ID).

So I am wondering... if I have an expression in the Go To URL option, like this:

=http://server/ReportServer?/Folder/report&parameter1=studentid&rs:Format=PDF&rs:Command=Render

Is there a way I can iterate through all the student id's I have in that report in order to "run" this request for each one? 

Thanks for your time!