none
Changing header text with each group

    Question

  • Instead of having a group listed in the far left column can I simply display it similar to a header and have it change when the group changes? Meaning... have the first related column under it and not beside it. All columns will still have their static heading including the one I want under it.

    For example:

    Instead of:

    First group here       Column1 Column2 Column3

                                    Column1 Column2 Column3

                                    Column1 Column2 Column3

    Second group here  Column1 Column2 Column3

                                     Column1 Column2 Column3

                                     Column1 Column2 Column3

                                     Column1 Column2 Column3

    I want this:

    First group here

    Column1 Column2 Column3

    Column1 Column2 Column3

    Column1 Column2 Column3

    Second group here

    Column1 Column2 Column3

    Column1 Column2 Column3

    Column1 Column2 Column3

    Column1 Column2 Column3


    • Edited by TapNamron Friday, December 27, 2013 7:18 PM Text didn't line correctly
    Friday, December 27, 2013 7:17 PM

Answers

  • Hi TapNamron,

    Suppose Group1 is the group field in the tablix. Please refer to the following steps:

    1. Based on your design, select the Group1 column, right click it.
    2. Select “Delete Columns”, then, select “Delete columns only” option.
    3. Right click the second row, select “Insert Row” option, and click “Outside Group-Above”.
    4. Add Group1 field in the corresponding text box.

    If you have any questions, please feel free to let me know.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    • Proposed as answer by Meagan Longoria Sunday, December 29, 2013 2:22 AM
    • Marked as answer by TapNamron Monday, December 30, 2013 1:45 PM
    Saturday, December 28, 2013 7:21 AM
    Moderator

All replies

  • Hi TapNamron,

    Suppose Group1 is the group field in the tablix. Please refer to the following steps:

    1. Based on your design, select the Group1 column, right click it.
    2. Select “Delete Columns”, then, select “Delete columns only” option.
    3. Right click the second row, select “Insert Row” option, and click “Outside Group-Above”.
    4. Add Group1 field in the corresponding text box.

    If you have any questions, please feel free to let me know.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    • Proposed as answer by Meagan Longoria Sunday, December 29, 2013 2:22 AM
    • Marked as answer by TapNamron Monday, December 30, 2013 1:45 PM
    Saturday, December 28, 2013 7:21 AM
    Moderator
  • Thank you so much Alisa.  Wasn't exactly sure about everything you said but I played with it using your suggestions and got it to work.  Couldn't have done it without you.
    Monday, December 30, 2013 1:46 PM