June 9, 2011 at 11:12 am
Hey,
I am using SQL Server 2008 R2. I am using the BI studio to create the reports.
I created a report that shows employee by facility and then by supervisor.
Then the manager wants to modify the report.
1) Make the report drilldown.
2) Make the facility collapsed.
3) Show the facility and the number of rows in that group.
4) Let the user click on a facility and then see sub group of supervisors
5) Make the supervisor collapsed.
4) Show the supervisor and the number of rows for each supervisor
5) click on the supervisor and see the employees.
Pretty Straight forward. But when I went to make the facility group collapsed, I get an error message.
The grouping ‘table1_Facility’ has ‘facility_name’ as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and cannot be contained within the current report item unless current grouping scope has a Parent.
I have no idea what this error means.
Can anyone offer any pointers?
Thanks.
Tony
Things will work out. Get back up, change some parameters and recode.
June 9, 2011 at 12:38 pm
This is taking way longer than if I had used Crystal Reports.
I cheated and used the wizard.
Now I have two collapseable groups.
+Facility_name
+SupervisorA
+SupervisorB
Now I want to show how many Records are in each group.
+Facility_nameA This has group has 10 employees
+SupervisorA This group has 5 employees
+SupervisorB This grop has 5 employees
+Facility_nameB This has group has 30 employees
+SupervisorC This group has 25 employees
+SupervisorD This grop has 5 employees
I am not seeing how to write an expression to create an agregation (count) for upcoming rows in a group.
This is a simple thing to do in Crystal Reports. You create a subtotal. Change the subtotal to count. And then drag it to the group header.
I'm not getting how to do this in SSRS.
Things will work out. Get back up, change some parameters and recode.
June 9, 2011 at 12:54 pm
Ok, I figured out the textbox expression:
=str(CountDistinct(Fields!Emp_Name.Value,"table1_facility_name"))+ " employees in this facility."
OK...now I wish I could do the drilldown from scratch. For now, I will just use the wizard.
Thanks.
Tony
Things will work out. Get back up, change some parameters and recode.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply