Problem in showing toggle item ( expandable/collapsable) in SQL Reports 2000

Last post 01-01-2009, 11:56 PM by mpk. 0 replies.
Sort Posts: Previous Next
  •  01-01-2009, 11:56 PM Post number 71046

    • mpk is not online. Last active: 01-04-2009, 11:27 AM mpk
    • Not Ranked
    • Joined on 01-02-2009
    • Level 1: Deep thought

    Problem in showing toggle item ( expandable/collapsable) in SQL Reports 2000

    Hi

    My problem is i have a selection criteria  in reports.Based on selection criteria i am displaying data.

    Selection criteria contains different grouping levels(3 level, 2 level , 1 level).

    For example 3level grouping  report  looks like this.

    Site

         lob

              Bu

                  some data

    2level grouping report look like this

    lob

         bu

              some data

    1level grouping report look like this

        Site

            some data

    I am able to put all the above mentioned grouping levels in a single table control.Based on selection criteria i am hiding the required table row.Now the requirement is i need to put expandable/collapsable(toggle) property at all the grouping levels. I have acheived this at 3 level grouping i.e in the first case.But in the other two cases i am failing because i am hiding the respective table rows.

    If i take 3 table controls, i am able to solve the above mentioned problem.

    But i want to do it in a single table control.

    Any solution ?

    Thanks in advance

     

View as RSS news feed in XML