Clever Geek Handbook

SSRS 2005 Guide: Headers for Groups within Groups?

Seems pretty straight forward to get what I want. The data data is showing correctly, but I can't seem to get the headers to cooperate.

I have a number of clients with their activity in the report. I want the customer name in the header and then the column names below that. But I either get columns repeating before each record or no client name.

This is what I want the reports to look like:

**Client # 1**

Col1   Col2   Col3
data   data   data
data   data   data


**Client # 2**

Col1   Col2   Col3
data   data   data
data   data   data


**Client # n**

Col1   Col2   Col3
data   data   data
data   data   data

Unfortunately I am getting the following:

**Client # 1**

Col1   Col2   Col3
data   data   data
Col1   Col2   Col3
data   data   data
Col1   Col2   Col3
data   data   data
Col1   Col2   Col3
data   data   data

Or that:

Col1   Col2   Col3

**Client # 1**

data   data   data
data   data   data
+2


source to share


1 answer


Add an extra row to the group header at the level at which the customer's name appears (right-click the gray box outside the edge of the RH row and select add row below).



Put the column headings on this row and they will repeat as often as the customer name.

+5


source






More articles:


All Articles