This is a two part question:
I have an SSRS report I'm working on.  I have Row Groups plus details.
A)  How can I get the row group headers to repeat on every line?
B) I would still like to use the drill down, click the plus sign, and have that work when I export to excel.

Here is the report header:  http://1drv.ms/1UJiFto

My first thought was is there a way simply to cause the header to repeat.  I cannot find that anywhere to do that.

My second though was to split the cells and copy the fields to all the rows.
Here is the same header with split cells:  http://1drv.ms/1UJiKNM
Two problems.
A) I cannot split one cell; See the "X" in the second capture.
B) How do I still hid the rows until I drill down.

Any help would be appreciated.

Thank you,

• Edited by KLN Group 16 hours 14 minutes ago

Put the header rows in the detail row of the report.

I've edited my post for clarity and added a link to see what I'm trying to accomplish.

Thank you,

Hi KLN

A)How can I get the row group headers to repeat on every line?
Do you mean each detail row will have one row above them to display row group headers? If that is a case, as Milan mentioned, you can add a row in detail rows. Please refer screenshots below:

If not, please share screenshots about the expected results for our analysis.

B)I would still like to use the drill down, click the plus sign, and have that work when I export to excel.
To create a drill down action, we can open Visibility tab in Group Properties, then specify the group can be toggled by parent level values. You can set this property for all items in row group pane. Please refer to screenshots below:

In Reporting Services, normally, we can split a cell that was previously merged. We can also split cells horizontally across columns or vertically down rows. To split a cell into a block of cells, split the cell horizontally first, and then split vertically as many times as necessary. But we cant split a cell (which is neither a merged cell, nor a cross cell) to multiple cells.

Regarding the requirement that you want to hide rows until drill down, would you please share some screenshots about this requirement?

Besides, would you please dont update the comments in your original reply? You could display your comments in a new reply. So that forum communities can view your original issue.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu