0

I have an SSRS report that has several row groups ('Account No.', 'name', 'MAR Type') as well as row visibility toggled by the value 'Bill Date'. When I export the report to Excel and try to filter on the grouped columns, the only option that shows up is '(Blanks)' I have to make all the rows visible for filtering to work.

Is there any way to get the column values for the grouped rows to show to show up under filtering?

example Excel report

Stedman
  • 65
  • 2
  • 9
  • 2
    You need to change the report field so it repeats values where they are duplicated (e.g. Account No.). A bit messy in the SSRS, but would filter ok In Excel, – MiguelH Oct 22 '18 at 14:20
  • (Hide Duplicates setting on the textbox in question) – MiguelH Oct 22 '18 at 14:52
  • I tried hiding duplicates, but it has not changed the issue. There are no duplicates in the columns since they are row groups. – Stedman Oct 22 '18 at 14:59
  • OK. There is this ... https://stackoverflow.com/questions/868064/ssrs-repeat-tablix-left-most-row-group-value-on-each-row – MiguelH Oct 22 '18 at 15:25
  • Got it figured out. I re-added the parents groups of 'Account No', 'name', 'MAR Type' but with a header row this time. This is allowing their values to show up when running a filter in Excel. – Stedman Oct 22 '18 at 15:32

0 Answers0