Sub report
I'm trying to put together a report about usage on some of our machines here. I've got a report that show logout and login information for any machine. For this report I just want to show "Machine Name" "Count" (logins) Then if user needs more they can either drill down or open a sub report that shows the login information. What would be the best way to accomplish this. I've tried the drill down but can't seem to get it right. Any help would be greatly appreciated.Univ of Missouri St. Louis
June 15th, 2011 11:24am

Hi Don, I don't think you need a subreport in your report. Simple report grouped by Machine Name will do it. Then in the Row Groups open up properties of the Detail group, go to Visibility and check off "Display can be toggled by this report item...". Remember to mark as an answer if this post has helped you.
Free Windows Admin Tool Kit Click here and download it now
June 15th, 2011 12:17pm

Hi, You can create drill through reports in SSRS. You can create two reports one for the summary section and the other for details section. You could set the action property to "jump to another report" to achieve your requirement. HTH, RamRam
June 15th, 2011 12:19pm

Hi Don, Thanks for your question and other partners’ valuable replies. Based on your description, my understanding is that: you would like to display the machines’ names and the count login times of each machine, after expanded the drill-down on the machines or clicked to open a sub report, the all records of this machine’s login and logon information will being displayed, right? If I misunderstand your question, please let me know. Generally speaking, for this category of requirement, if there are many columns in the Data region, using a sub report as the solution has the better performance, if there are several columns, I would suggest you creating the drill-down in the data region. Based on this condition, you should set the field machines as other fields’ parent group, then add a drill-down on it. I will give the example of how to add the drill-down in the data region of table, detail steps as below, Supposing that your database table is logs, the Dataset’s name is dslogs, the logs’s structure and records just like this: , the dslogs’s T-SQL query is: select * from logs. 1. Drag the table into the Design surface from the Toolbox window, in the Property window, locate to the Datasetname, select the Dataset name is dslogs, delete the second and third columns. 2. Type Counts in the first row of the first column, right-click the second row of the first column, select Expression, in the Expression dialog box, type in like this: =count(Fields!machines.Value), click OK. 3. Right-click the second row of the first column, select Add group, select Row group, select Parent Group, select machines in the drop-down list of Group on, click OK, replace the group name Group1 with Machines in the first row of the first column. 4. In the Row group section, right-click Group1, select Add Group, select Child Group, select loginTime in the drop-down list of Group on, click OK, replace the group name Group2 with loginTime in the first row of the second column. 5. In the Row group section, right-click Group2, select Group Properties, click Visibility in the left pane, select Hide below When the report is initially run, check the check box of Display can be gtoggled by this report item, select Group1 in the drop-down list,click OK. 6. Repeat the previous two steps to add the Group3 of logonTime. After these steps, please preview your report, the effect just like below, For more detail information about Developing Report Drilldown, please see: http://msdn.microsoft.com/en-us/library/aa964132(SQL.90).aspx. I had handled a similar thread about Sub report for drill down tablix report , I suggest you see it: http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/5221efc8-00b7-47d6-8ffc-0a6b2d416a05. If you have any other question, please feel free to let me know. Thanks, Sharp Wang Best Regards. Sharp Wang
Free Windows Admin Tool Kit Click here and download it now
June 16th, 2011 8:40am

Thanks for getting back to me so quick. Everyting seems to go fine but when I drag a table to the design surface I can't figure out how to get the drill down option. I don't have the drill down option the report is just one big report. This is new territory for me here. But what you described is exactly what I want.Univ of Missouri St. Louis
June 16th, 2011 4:53pm

Hi Don, Thanks for your reply. Could you please represent the data region's detail structure here? It may help us to found the better solution for your requirement. Thanks, Sharp Wang Best Regards. Sharp Wang
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2011 7:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics