Expand/Collapse Ability in List/Crosstab Report

[dmk.3678]

Hi,



I have a list report build in report studio (Cognos 11.0.9) with relational package. In the list report have three columns. Region, Country and Total Count.

I at trying to build the report in such a way that when the report runs, it shows the List of Regions and its Total count first and with Expand button (Like + Sign) near each region i can expand to its countries which falls under that region. See Attached Image. I am trying to achieve the same.

I have tried many java scripts posted by users on various forums and sites, but none of them seems to work with Cognos 11 version.

If someone here can guide me or provide me the javascript which works with Cognos 11, i would really appreciate it. Also wanted to know if this functionality would work with Active reports also or not?

Thank you in advance.

Regards,
DK

[MFGF]

Hi,



I have a list report build in report studio (Cognos 11.0.9) with relational package. In the list report have three columns. Region, Country and Total Count.

I at trying to build the report in such a way that when the report runs, it shows the List of Regions and its Total count first and with Expand button (Like + Sign) near each region i can expand to its countries which falls under that region. See Attached Image. I am trying to achieve the same.

I have tried many java scripts posted by users on various forums and sites, but none of them seems to work with Cognos 11 version.

If someone here can guide me or provide me the javascript which works with Cognos 11, i would really appreciate it. Also wanted to know if this functionality would work with Active reports also or not?

Thank you in advance.

Regards,
DK

Hi,

The ability to expand and collapse that you describe is delivered out-of-the-box when you use a dimensional package. That would be your easiest option here.

You can emulate expand and collapse in active reports using nested decks, but it's quite involved and messy.

Cheers!

MF.

[CognosPaul]

DK, that gif you attached was from an article I wrote on C11. It works great in interactive mode. Can you tell me what's going wrong?