I have a request to produce a report
1 prompt page
3 page reports ( Page 1 - list report to obtain # of records to be displayed onto the prompt page)
Page 2 - page for a pdf output
Page 3- page for an excel output
Would it be doable to be able to run the page 1 in the background after prompts have been selected to get the # of records to display on the prompt page. and once a threshold has been met for # of records the user has the option to either output the pdf or the excel output. Just 1 will run and render for display
Hope this makes sense
see attachment for sample of prompt page
I can't think of a way to run the query to display the reconds on the prompt page, however...
What you could do is to run the report after the prompt page, and have the first page of the report looking exactly like the prompt page. On that first page you could show the number of records, and have the output options. Then you could have render variables so that the first page isn't shown and the right version of the report is.
BigChris... I like that idea seems easier
Sometimes you just have to think sideways to get what you want out of Cognos ;)