0

I was wondering if it is possible to have a SSRS table where I group by the part number and all preceding field's values will show after I click on the drop down? Currently I have a list grouped by part numbers and the parts requirements show on the same line.

How it would look like is this:

|Part Number||Requirement|Value|
--------------------------------
   +ab1

Dropped down it would look like this:

|Part Number||Requirement|Value|
--------------------------------
   -ab1    
                  r1      200
                  r2      100

Thanks guys!

ltsai
  • 757
  • 3
  • 8
  • 16

1 Answers1

1

Yes, that is called a toggle. You need to set the toggle for the visibility for the grouping rows to be controlled by the part number text box.

If you read the following article it shows you how to do it:

Toggling Visibility

JesalynOlson
  • 503
  • 3
  • 9