SSRS with parameters export to excel using textbox?

Question

I have a Reporting Services (SSRS) rdl report with parameters. The user can select multiple values in one of the parameters. I need to export the report to Excel file using a hyperlink with a button. Here is my current URL =Globals!ReportServerUrl & "/Pages/ReportViewer.aspx?" & Globals!ReportFolder & "/" & Globals!ReportName & "&Command=Render&rs:Format=Excel" The report cannot run without the parameters. Is a VB code that can help me in this case?

Answer 1

I'm filling out my Wyzant profile and this was one of the latest unanswered questions. I see that its almost 7 years old.

Are you getting an error that says "The report cannot run without the parameters."? VBA can be used to create a URL. There's many more details needed to know where the problem is. You mentioned one parameter is from multiple values, double check you're encoding white space and special characters correctly.

It doesn't make sense to go into much more detail in a very old post. What you're asking for is doable with VBA programming knowledge. I'm a VBA expert with many years of experience. If anybody sees this I'm available as a tutor or consultant.