Post reply

Group Header formatting. Want separate headers on the same line... (pics included)

  • November 9, 2009 at 8:46 am

    #227805

    I'd like one level of group header-dom to have 3 distinct (and equal width) components, each corresponding to 4 of the underlying 12 data columns.

    The leftmost group header should correspond to the first 4 data columns, the rightmost header should correspond to the last 4 data columns, and 1 in the middle soaking up the remaining 4.

    I've effected this the best I can by using underscores between the group header names, and vertical pipes to delimit the columns, but that gets wonky quick.

    I've also tried to forgo group headers completely in favor of text boxes, but this translates horribly to the web.

    I've also tried separating the 3 subsets of columns into their own reportset, mimimizing the middle and rightmost group columns, but that had it's own unique issues.

    Screen shots are worth a thousand words, so please check those out.

    Thanks in advance SSC!

  • November 9, 2009 at 9:45 am

    #1076743

    Hi,

    I may be misunderstanding this but are you trying to merge the heading values in the row above to cover the four columns?

  • November 10, 2009 at 6:19 am

    #1077175

    ... and I might be misunderstanding you as well, but yes Nick, that sounds about right.

  • November 10, 2009 at 6:27 am

    #1077178

    if that's the case then you can select/highlight the four cells in the row where you would like the heading to appear then right click and select 'Merge cells' this would then give you once box spanning the four cells for you to add your header to, this can then be repeated for the other tow headings which you wish to add.

  • November 10, 2009 at 7:29 am

    #1077242

    I'm not seeing the merge option Nick. When I right click on the 4 cells, I see:

    Select 'matrix4'

    Select 'Body'

    Cut

    Copy

    Paste

    Delete

    Expression

    Properties

    <where indented options are disabled>

    ???

    I'm using Microsoft SQL Server Reporting Services Designers Version 9.00.3042.00

    Thanks!

  • November 10, 2009 at 7:43 am

    #1077260

    ah, I didn't realise that you were working with a Matrix not a Table. I don't know how to merge those columns I think they are just driven by the the groupings sorry.

    An alternative could be to add those headings as a field in your dataset if this is possible and then use that field as a column group within the matrix?

  • November 10, 2009 at 11:10 am

    #1077395

    thanks Nick. recreated is as tabular and got exactly what I wanted. solved another issue too.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply