Advertisement

03.24.2008 at 06:27PM PDT, ID: 23265843
[x]
Attachment Details

SSRS How do you pass a parameter to a subreport

Asked by JeffStone in SQR, SQL Server 2005, Visual Studio

Tags: , , ,

I am new to SSRS and have created three reports in VS2005 and all seems to work fine in preview mode and when referenced via the URL and reporting services.  The URL is something like this:

http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fMonthlyInvoiceSummary&rs%3aCommand=Render&invoiceid=7

invoiceid=7 is a parameter that I can pass to this and in fact all three subreports and individually they all work via this url.

THE PROBLEM: I have a wrapper report that contains the three "subreports" and this too works fine in the VS2005 preview mode but I get a blank report when I call it from the URL ... I suspect that the invoiceid parameter is not reaching the subreports ... any thoughts on how to pass a parameter to a subreport?Start Free Trial
[+][-]03.25.2008 at 05:39AM PDT, ID: 21201260

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQR, SQL Server 2005, Visual Studio
Tags: Microsoft, Sql Server Reporting services, 2005, Reporting services
Sign Up Now!
Solution Provided By: sjturner2
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628