Show Detail

[tjw2006]

Is there a way to use a formula to set the 'Detail' section to 'Show' when it has been set as 'Hide(Drill-down OK) - could this formula be run by a link on the report?

Thanks

 

[raja2008]

can you explain in little more detail like why you want to do it

 

[tjw2006]

It's just that I've got a drilldown report - where I drilldown to the detail level, but if I try to export the report, the detail level doesn't get exported, so I thought if there was a way to show the detail level before exporting, that might fix the problem.

 

[raja2008]

Not that i know of,i had the same requirement .All i did was create other one with everything showing and export it.
Please post if you come across anything.

 

[lbass]

You can create a parameter {?ShowDetail} that you then use to conditionally suppress sections instead of using "hide", using a formula like this in the suppress->x+2 area for that section:

{?ShowDetail} = "No" and
drilldowngrouplevel = 0 //for group#2-first drilldown level

{?ShowDetail} = "No" and
drilldowngrouplevel < 2 //for details-second drilldown level

Then if you choose "Yes" all sections will appear; otherwise, you will have the drilldown functionality.

-LB

 

[tjw2006]

Yeah, thanks for that - I did think of that, but ideally I was looking for a way of doing this without having to run the report again, but I suppose running the report isn't a big deal. Shame you can't have events and variable value implementation in a live report.