0

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

user1263981
  • 2,953
  • 8
  • 57
  • 98

1 Answers1

1

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.

alejandro zuleta
  • 13,962
  • 3
  • 28
  • 48
  • thanks for the reply. I have updated my question with the screen shot of what i achieved so far. – user1263981 Nov 09 '16 at 17:39
  • @user1263981, First add a Visit Date then add Job Code as parent group as mentioned in step 2 in my answer. Once you have the setup for Job Code you can add additional groups. – alejandro zuleta Nov 09 '16 at 18:45