multi expand/collapse with 2 datasets using cube data

  • HI All, has anyone or anyone know how to do the following - if possible

    I have a report that has 2 tables each table has a seperate dataset called dataset1 and dataset2.

    the data source is a ssas cube.

    as I have added visibility hide/view on each of the tables they both do this independently.

    What I want to be able to do is when the user expand the left table the right table expands also and when i click the + they hide also together.

    does anyone know how to do this or have any suggestions

    Thanks in advance

    ID

  • ian.dunlop 7059 (7/20/2010)


    HI All, has anyone or anyone know how to do the following - if possible

    I have a report that has 2 tables each table has a seperate dataset called dataset1 and dataset2.

    the data source is a ssas cube.

    as I have added visibility hide/view on each of the tables they both do this independently.

    What I want to be able to do is when the user expand the left table the right table expands also and when i click the + they hide also together.

    does anyone know how to do this or have any suggestions

    Thanks in advance

    ID

    It is not possible to have a viability toggle be toggled by an item in another scope(table).

    You will get this error:

    The table ‘table1’ has ‘textbox’ as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and cannot be contained within the current report item unless current grouping scope has a Parent.

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

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