SSRS Sub Reporting.

RiazFarooqui · August 30th, 2009, 04:52 PM

I have put the Sub Report Control and set the report name which i want to show in the control, but when i m trying to setup the parameter to link master report with sub report but NAME combo is empty no one link field i could see, what I am doing wrong please do tell me.

Paul_Turley · August 30th, 2009, 05:19 PM

What verison of Reporting Services are you using and what design tool (i.e. Report Builder 2.0 or BIDS?) Report Builde will not show you a list of reports. BIDS or Visual Studio will show a list of all reports in the same project. Does the subreport render if you just type the name of the report?

RiazFarooqui · August 31st, 2009, 11:25 AM

Thanks Mr. Paul, I am using Sql server 2008 reporting services and using BIDS to develop the report, actually i can see report list in the report combo i have set the report also but when i m trying to set the parameter to call up the detail report in the Advance>Parameter>Name Combo is empty whereas ValueCombo which is next to it is showing all Master report fields.

RiazFarooqui · September 1st, 2009, 02:09 AM

Same kind of problem I am facing in linking or drill through the report. I have select Goto Report, Selected the rptCustomer from the Report Selection Combo, when i m trying to setup the Parameter again NAME combo is not showing any field to be linked with the current report Value Combo which is next to Name Combo is showing all the fields of current report. Then I Typed CustomerID in Name box and select CustomerID from Value box but still error is appearing CustomerID is found in the report.

RiazFarooqui · September 1st, 2009, 03:13 AM

I am sorry Paul, i did not follow your book instruction by instruction, I missed that instruction where you mention creating of Parameter in calling report and then link it with master report, anyway I download the code from this forum and check each step, i made same what you have done in your example and it is working now.

Thanks & Regards.