Hi I have a reporting services summary report which automatically selects the past 6 months data. I have a drill down functionality to the finer details, but when I drill down it displays the whole 6 months (as defaulted in the parameter) rather than the month I select e.g. The report dispays from 01/01/2012 - 30/06/2012 with a summary for each month: Jan - 50 Feb - 40 Mar - 12 Apr - 17 May - 56 June - 12 When I click on the figure for June, it will display all 187 records rather than just the 12 for June. Is there any way of knowing what month the user will select so that it can be put into the drill down too? e.g. if they clicked on Jan it would show 50 results, or Feb 40 etc thanks

HI reporter ! Assuming that you have Row Group on your Month Field. You can set the Visibility of this group by doing following; Group Properties Page -> Visibility -> Select the radio button "Hide" and Select the check box stating "Display can be toggled by this report Item" and specify the name of you Month Text box in the Drop Down List. Please let me know if this helps. Hopefully i have answered you correctly. Thanks, Hasham Niaz

Hi there! Thanks for your reply. I dont really want to toggle the report. I have a summary of the data e.g. example below in a table. It displays the last 6 months worth of data by month. I have set the parameters to automatically pick the last six months: Jan - 50 Feb - 40 Mar - 12 Apr - 17 May - 56 June - 12 What I want to do is have a drill down function which will allow me to click on the month e.g. June, and it only displays Junes data. Currently I have it working, but it is displaying all months data instead of just Junes. I currently have 2 reports, 1 with the summary by month, and the other with all the data. When I click on the figure on the summary report, it takes me to the other report with all the data, but its showing all data and not just the month I select.

HI Reporter ! Okay i got it. So you are calling Sub-Report with click on Main Report Month Name textbox. You might need to add a parameter "MonthNo" or "MonthName" at your sub-report and in your main report "MonthName" textbox properties -> Action -> Go to Report And add one more parameter as "MonthName" and set the below expression in value against it; =Fields!MonthName.Value Please let me know if this helps. Hopefully i have answered you correctly. Thanks, Hasham Niaz

Hi, here is a video of a presentation where I show how to drill down into sub reports using parameters. It's toward at least the last half of the video, so you may want to fast forward: Easy Reporting off of SharePoint DataLaura Rogers Rackspace: SharePoint Consulting Blog: http://www.wonderlaura.com Twitter: WonderLaura Books:Beginning SharePoint 2010: Building Business Solutions with SharePoint Using InfoPath 2010 with Microsoft SharePoint 2010 Step by Step