Can someone tell me how to schedule a report that contains a drop-down list (Value Prompt) so that I see this drop-down list (Value Prompt) on the scheduled output?
Currently, when i schedule this report in HTML, my drop-down boxes are gone.
Thanks.
Hi,
Prompts don't get included in pre-rendered outputs - there would be no point in rendering them since no prompting can be done. The easiest solution is to include layout calculations that display the chosen parameter values.
Cheers!
MF.
I don't understand. The Value Prompt I am using is really just an optional filter against the data that was pulled by the database fetch. If I pulled data for 5 States in the output report, I should be able to filter that data in the output report using something similar to the Value prompt I am using in the report itself. My problem then is that I don't know how to do that at this point. I want the output report instance to work just like the report itself works. I need a selection box or something.
I believe that when you produce a standard scheduled report of any format (be it HTML, PDF etc..), it is a static report - There is no way to then subsequently filter that output (which is why prompt pages are not produced in output).
As MFGF points out, you can add layout calculations to display the Parameters you selected when the report was executed.
If you truly want to schedule a report that renders in HTML that includes some "filtering" ability, you can create an Active Report.
However, the creation of this type of reporting is a "whole new kettle of fish"!
http://www.ibm.com/developerworks/data/library/cognos/reporting/active_report/page593.html
Hope this helps.