Unique issue in displaying selected Prompt values in answers request (10g)
438410Mar 29 2011 — edited Mar 30 2011Hi,
I have a requirement to display the prompt values selected by a user in an answers request, even if the user does not select any value (which effectively does not filter on that field), in which case they want to display the value 'ALL'. This requirement is so that when printing the report (Print -> PDF), the prompt selections are displayed.
We cannot add the "Filters" view in answers because it reveals too much information for our users regarding security and other filters on the report.
We cannot simply use presentation variables because all of our prompts are multi-select, and 10g does not allow assigning presentation variables from multi-select prompts.
I have tried some intricate workaround using Javascript which works well when the request is displayed in the browser, but when using Print -> PDF, the javascript variables containing prompt selection values are not displayed. I'm assuming this is because PDF printing does not play nicely with anything HTML/Javascript related.
Our last resort would be to create a BI Publisher report but we are really trying to avoid this because it would create double work for every report we have to develop.
Are there any other options for me in this case? I'm out of ideas.
Thanks!