Post reply

adding a row group with toggle

  • February 29, 2012 at 8:07 am

    #269230

    Hi

    I have a report with data that looks like the following

    Client Jan Feb Mar

    -------------------------------------

    Alan 10 5 6

    Andrew 8 5 1

    Billy 5 4 11

    Bob 7 9 0

    and i want to add a toggle item on the client name that opens new rows detailing the projects for each client

    Client Jan Feb Mar

    -------------------------------------

    Alan - 10 5 6

    Project 1 4 2 3

    project 2 5 1 5

    Andrew + 8 5 1

    Billy + 5 4 11

    Bob + 7 9 0

    could anyone give me directions on how to do this? i assum i would need to add a group within the client group? but when i do this i dont seem to be able to configure the group to behave as i would like.

    thanks in advance

  • February 29, 2012 at 9:17 am

    #1453232

    Hi

    Yes this is possible

    You need to create another group within your Client group and call it Detail or something

    Then in the Detail group properties go to the visibility section and set the default to Hidden, next select the check box ("Display can be toggled by this report item") below this and select your Client field.

    Cheers

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • March 1, 2012 at 12:32 am

    #1453463

    Yes ive tried that, as a child group?

    It turns the parent row header into a cell that covers both rows, if i add a row below the group it adds the detail at the end of the report

  • March 1, 2012 at 2:16 am

    #1453491

    Hi

    Yes you add it as a child group

    Then use the parent row add the client name and any summary data you wish and the detailed data should be added to the child group.

    The parent group should have a small + that you can click on to expand - initially the parent group will just be a header or sorts as you have

    set the child group to be hidden by default.

    Its difficult to know whats going on without any screenshots so I can see whats going on.

    Take a look at this thread here and maybe it will help you

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/2bf867b4-6e1d-45cf-be15-e8ae89049a52

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

Viewing 4 posts - 1 through 3 (of 3 total)

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