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