Multilevel grouping in a single column - ssrs 2008 r2

0
votes

I have been trying to add a multiplevel grouping in the job field column as shown below (sample excel sheet template), Column Job has job code and then visit dates grouped by job code. Is there any way to achieve to this in SSRS 2008 r2?

It works if i add another group column VisitDates and set the toogle item property to column Job but i need to show the visit date below the job code number.

Required

enter image description here

Achieved so far;

enter image description here

1
sql-serversql-server-2008reporting-servicesssrs-2008-r2
What is your issue? Do you need Visit Date be in the same column than job code? That is how it appears in your report. - alejandro zuleta
attached screen shot is a sample excel sheet. Yes i want visit Date to be shown in the same column. - user1263981

1 Answers

1
votes

I am using a basic example you have to adjust it to your requeriment.

  1. Add a new tablix and set the DataSetName property to the dataset you are using.

  2. In the Row Groups pane right click Details group select Add Group / Parent Group... and use these settings:

enter image description here

  1. Delete the created column in the previous step, leaving only the group.

enter image description here

  1. Delete the first row, and use the Job Code field in the remaining first row and in the first column.

=Fields!Job_Code.Value

5.In the below cell use Visit Date value:

enter image description here

  1. Set toggle in the Visit Date row as below, replace Textbox297 by the name of the Textbox where Job Code is placed:

enter image description here

It should produce:

Collapsed

enter image description here

Expanded

enter image description here

Let me know if this helps.