Hi,
I have reports with dropdown prompts, and text describing the prompt, displayed on the results page so user can easily change the filters without re-running. When the results are exported to Excel, the prompts are hidden and I have hidden the text from Excel.
What I would like to do is present a text value of the prompts in Excel so the user can better understand what filters have driven the Excel sheet they're working with.
Is this possible?
Thanks in advance.
Have you tried ParamDisplayValue() or ParamValue() as layout calculations? You could conditionally render those so they only appear in the Excel output.
Hi,
I have tried the ParamDisplayValue which displays the text great. But how do I conditionally render that text to not display on screen and only display in Excel? (So as to not double the information on the screen with both the text and the prompt.)
Thanks again.
Just wrap the whole thing up in a block and give it a render variable using reportOutput() function, and you should be good to go.
Such as this:
Variable name: Is_HTML
Variable definition: ReportOutput() = 'HTML'
If condition is satisfied, don't display.
(../..)
Sorry Nimrod, I'm not jumping on your (illustrious) bandwagon, but my reply to m shea was 90%drafted when I noticed that....... you get the rest :)
Perfect!
It works like a charm. I was unaware of the ReportOutput function.
Thanks,
m
m
I agree, ReportOutput () is not well-documented at all. Here:
http://www.ironsidegroup.com/2013/03/05/report-studio-cookbook-formatting-based-on-report-output/ (http://www.ironsidegroup.com/2013/03/05/report-studio-cookbook-formatting-based-on-report-output/)
is an article which will show you some of its possibilities. And in general, one can learn a lot from following the Ironside blog. I certainly have found it useful.
Thanks for the link. I need to spend some time reviewing the Ironside Group site and all those functions buried in Report Studio.
Thanks again for all help.