Expand Collapse in CrossTab Report

[d0n_mac]

Hi,

I'm looking to emulate the reporter mode from powerplay. I found the below example and it seems to be working like a charm. I was wondering if anyone had any experience of adding multiple items.
e.g. have a collapseable hierarchy for markets and a nested one for products. 


When I have tried it the report fails on run but I think it might have something to do with my dodgy changes to the javascript. I tried making a new function for the second heirarchy

http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14237617&tstart=0

Thanks in advance

David

[MFGF]

I'm afraid I can't help with the javascript (it's not my thing at all, sorry!!) but an easy solution might be to allow you users access to Business Insight Advanced. It has these kinds of capabilities built in (just like PowerPlay) so the users can self-serve instead of needing you to build their reports for them.

Just a thought!

MF.

[Amruta Gandhi]

Hi,

We had implemented some similar functionality for our reports. Here's an attachment which contains the code described with an example. Hope it helps you in some way!
Please let me know in case of any concerns.

[d0n_mac]

Hi Thanks for the replies.

MF- I've had a look at the Business Insight and it does do exactly that it's under expand and collapse but our users want to use it on specific reports and not self serve. They want to know an entire department can look at the same figures and not have differences due to how that user has put the adhoc report together.

Amruta- Thanks I'll give it a try and post back my results. I can't believe it's something that IBM has missed out of there standard development. This  Along with freezing headers and rows has caused me know end of issues. At least this hasn't involved a whole load of css changes.

Thanks Again David

[Archana_M]

Hi
I am having the similar requirement in the mentioned link,but is there a way to avoid  dragging HTML item in the report.
(http://www.cognosonsteroids.com/2012/02/create-report-with-collapsible.html)

Thanks & Regards
Archana.

[mohisy]

Hi,

We had implemented some similar functionality for our reports. Here's an attachment which contains the code described with an example. Hope it helps you in some way!
Please let me know in case of any concerns.

Hi Amrutha,

can you please share any idea to get similar functionality in crosstab reports?

Thanks in advance ..

Reagrds,
Mohi

[Francis aka khayman]

i tried that for crosstab.... you need to rewrite the javascript and its not that easy and so much complications.

not worth the effort and i'm not that good in javascript anyway