How can i create only 1 Column header per group in SSRS 2008 report
-
I want to create a group of values with only 1 column header [IBOS_NT_UserName] in a SSRS 2008 report
In other words , I want to display it as follows:
IBOS_NT_UserName
LONCGOJ8
LONCOMJ8
LONEXJJ8However the field name is repeated per row like this:
IBOS_NT_UserName LONCGOJ8
IBOS_NT_UserName LONCOMJ8
IBOS_NT_UserName LONEXJJ8How I can stop the column header repeating?
-
When you add the new group, check the box to Include the Group Header. Then delete the new column that was added by the group. In the Group Header, put your grouping field.
Wes
(A solid design is always preferable to a creative workaround) - chris.asaipillai-624309 - Tuesday, February 14, 2017 5:28 AM
Without actually seeing your RDL file, I can't be sure, but what you describe sounds like the column headers were placed somewhere other than in a grouping section or header section. You can't place a column header to the immediate left of a column value without using an UNDERLAY check box for the section your headers are in, or using something like a matrix or tablix.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy) -
This is how my report looks like at the moment.
I really only want to display one Instance of the label 'IBOS Broker Code'
So in actual fact, it should like this
IBOS Broker Code
LONCGJ8
LONCOMJ8
LONEXJJ8This is how my groups look:
With the properties of IBOS_BrokerCode
- Can you post a screenshot of the tablix in design view?
Another thing you can try is setting Hide Duplicates = True for your IBOS Broker Code field.
Wes
(A solid design is always preferable to a creative workaround) -
This Is a screenshot of the Tablix in Design View
-
We'll need to see the row and column handles to determine groupings. Can you set focus on one of the cells and grab a new screenshot?
Wes
(A solid design is always preferable to a creative workaround) -
Ok here is an updated screenshot
- chris.asaipillai-624309 - Tuesday, February 14, 2017 11:23 AMOk here is an updated screenshot
Not sure why that last row exists... It appears the header is down there as well as up above. I'd say that last row needs to be removed.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy) -
Also, why do you need the tablix? Why not just a standard Grouping section with a header and no footer, with the header showing the field office and the column headers to the right of it, then the data section with the usual list of fields you're using?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy) - chris.asaipillai-624309 - Tuesday, February 14, 2017 9:48 AM
Your text is repeating because you have it in the [IBOS_BrokerCode] group. You need to insert a new row above IBOS Broker Code outside of the group, then move your text in the new top row. Then, put [IBOS_BrokerCode] in the field where 'Broker Code' was. Finally, you can delete the last row.
Once finished, the columns should look like this:
Notice the groups on the row handles. "Broker Code" is not in a group. It may be hard to see, but there is also a vertical dashed line between the white cells, indicating the left cell is a header in a different group.
Each IBOS_BrokerCode should show once, with the IBOS_NT_UserNames listed vertically next to it.On a separate note, I assume you used the report wizard to generate this. I highly recommend abandoning the report wizard. It makes some design choices for you that are not very friendly to build upon. It is much better to build your tablix from scratch. Once you are used to building them yourself, the wizard doesn't really save any time on a simple report and can make customizing a real hassle.
Wes
(A solid design is always preferable to a creative workaround) - chris.asaipillai-624309 - Tuesday, February 14, 2017 9:48 AM
The edit mode made the header and detail look like they are in separate columns.
If you want this instead :
Insert the new top row as before and move your text.
Delete the first column
In the row above [IBOS_NT_UserName], set the field to use [IBOS_BrokerCode]
Delete the last row.
The first column should look like thisWes
(A solid design is always preferable to a creative workaround)
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply