COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: david.stachon on 16 Sep 2013 10:55:40 AM

Title: Show and Hide in a Master Detail List
Post by: david.stachon on 16 Sep 2013 10:55:40 AM
Here's what I'm trying to do...

Imagine a list report, and in the list, there is a graph inside each row (with a master detail relationship)

By default, I don't want the graphs displaying inside the list.

...but, when user clicks a row, that row will expand to show the graph in that row only. Then, click again and it hides.

See the attached mockup ...where a user can click any city pair, and just that city pair "expands" to show the graphs.

I've attempted a JS solution with no success (as I don't think it's supported in 10.2 within active reports), and I need it to work on the Pad app as well.

Any thoughts on how I might achieve this?

thanks,
david.

Title: Re: Show and Hide in a Master Detail List
Post by: Anantula on 16 Sep 2013 06:14:36 PM
Hi David,

Attached report from Cookbook might give you an idea.
Probably by using decks and 2 lists (one without graph and the other with graph)

Regards,
Anand
Title: Re: Show and Hide in a Master Detail List
Post by: david.stachon on 17 Sep 2013 08:17:21 AM
Thanks for the reply Anand.

I had actually seen that before, and it's certainly a possibility to get close enough to the requirement.

The business did have their heart set on just expanding the one row while the others remain intact (and on screen), but, I don't think it ought to be a show stopper.

thanks very much!