Hi Team, New guy here, so please be gentle :). I've spent the majority of the day reading various articles until my head is now spinning. I'm wanting to create a report that will let me drill down into individual cells, this would be for a test with three sections. I need to put a summary as the upper section stating the # of students who have passed a section versus who has not passed it, like this: ____________________At Standard_________________Not At Standard Section 1____________35________________________________13 Section 2___________45____________________________3 Section 3____________25_______________________________23 Each of the #s should be drillable, so that when a teacher clicks on the number it will show the Student Names that make up that particular number. Is this possible? I feel like I've been close to having a solution, but nothing is quite getting the job done and wanted to see if it even can be before I continue

Hi, You can achieve this by using creating drilldown/drillthrouogh reports in SSRS. For Creating Drilldown reports please refer the link below http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/creating-a-basic-drilldown-report-in-ssr-2005. For Creating a drillthrough report : You have to create two reports Report A (for number of students) and Report B (For displaying student names) 1. ReportA will be showing all the details of the number of students. 2. ReportB will be displaying the details of the student names 3. In ReportA on the Number of student column you will set Jump to report in the Navigation property. 4. To jump to ReportB by passing the Number of Student column and other parameters defined in Report A as parameter to Report B. 5. When user clicks on Number of Students in ReportA he will be taken to ReportB. 6. Details of the students is seen in ReportB. http://msdn.microsoft.com/en-us/library/ms159847.aspx HTH, Ram

Thanks for the quick response Ram! You are on the right track, but what was outlined in the blogs you referenced aren't exactly what I am hoping for. I've been able to create the "traditional" drill-down -- Multiple columns that are grouped from left-to-right, and clicking Column A will expand Column B, which will expand Column C, etc. What I'm looking for is a solution that will let me have one expandable column, that basically expands itself. In my <horrible> report mock-up in my original thread: Column A Column B Section A Detail A Section B Detail B I need it so that when somebody clicks on "Detail A" in Column B, that same cell expands to reflect the data underneath it -- I don't want to create a Column C that contains those details and gets expanded. It might be that this is not possible, and I will have to use the drill-through method that you outlined above, but I'm trying to give my customer exactly what they asked for, which was everything in one report, with the least amount of columns possible.

Hi puffster, From your description, if you want to click one cell and then the cell expands to display the detail data underneath it, we can add a group header and use the drill-down feature to achieve it. For example, I have two fields in my dataset which are Category and OrderQuantity. Please take the following steps of my sample as a reference: 1. Drag a table from the Toolbox to the design surface, and then drag the OrderQuantity field to the second row of the first column. 2. In the Row Groups pane, right-click Details and select Add Group->Parent Group. 3. In the Group by drop-down list, select [Category], and then select “Add group header” checkbox, click OK to close the dialog. 4. Point to the group header which is on top of the OrderQuantity field, click the Field List icon, and select Category, and then delete other columns except the OrderQuantity column. The table as shown in the following figure: Order Quantity [Category] [OrderQuantity] 5. Click anywhere inside the Table, in the Row Groups pane, click Details. In the Properties window, set the “Hidden” property to “True”. In the “ToggleItem” property, click the drop-down list and then select “Category”. After previewed the report, we can use the drill-down feature to display the detail data and the cell expands to display the detail data underneath one of the category. If you have any questions, please feel free to ask. Regards, Bin Long

I can't thank you <and Ram> enough for your kind responses, this is exactly what I was looking for, everything is coming together beautifully now, and I think the principals in my school district are going to be very pleased with the results. Thank you very much for the help!