Post reply

Dynamic column headers

  • July 17, 2010 at 11:33 pm

    #237794

    I have a problem which so far has eluded me.

    I need a column header, but a dynamic column header, that is, a column header that changes with a row grouping.

    This is the design view for my current report:

    https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png

    See where the ActivityTypeCategory is? This currently remains the same for every activity type category. I need this to change based on the row Group6 which groups by ActivityTypeCategory. How do I do this?

    (I can't just move it down one spot because then it will repeat along with the columns which I don't want.)

    Please help!!!!

  • July 20, 2010 at 6:29 am

    #1195450

    maloriopolium (7/17/2010)

    I have a problem which so far has eluded me.

    I need a column header, but a dynamic column header, that is, a column header that changes with a row grouping.

    This is the design view for my current report:

    https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png

    See where the ActivityTypeCategory is? This currently remains the same for every activity type category. I need this to change based on the row Group6 which groups by ActivityTypeCategory. How do I do this?

    (I can't just move it down one spot because then it will repeat along with the columns which I don't want.)

    Please help!!!!

    The text box where ActivityTypeCategory falls under a column group, not under a row group. So I would group group1 on ActivityTypeCategory. That way the ActivityTypeCategory text box will just change dynamically with every column group.

    It's sort of difficult to give you a really good answer since I don't have all the info I would like to have.

    What do the groups do? What do they group on? That includes all groups, 1,5 and 6.

    The point of a matrix is to show values for the intersections between row and column groups. You have a matrix but try to turn it into a table. If you want dynamic column headers, they need to fall under a column group.

    If you want the header to change dynamicaly with group 6, it has to fall under group 6.

    If your hierarchy is: ActivityTypeCategory>Activitytype>statename then you should add them as either 3 row groups or 3 column groups, splitting them up into 2 row and 1 column group is kind of silly. Unless I am totally missing the point.

Viewing 2 posts - 1 through 1 (of 1 total)

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