If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Show report output (after prompt pages) in new browser window

Started by ltc, 28 Oct 2009 04:59:27 AM

Previous topic - Next topic

ltc

Hi,

I have really "fancy" request from my client.
They want such a functionality:
- open report from portal, display prompt page with web controls
- after successfull option selection, prompt page SHOULD BE still opened but the output results must appear in new web browser (prompt page can be used for another invocation then).

I haven't found any property or "magic checkbox" for "Prompt Button" object (in fact I'm using HTML Item for buttons but it doesn't really matter in this case). I even briefly check cognos javascript API and it seems that they do not prepared any methods for that. Are there any chances to force RS to show output reports in new web browser window? Any ideas?

Thanks in advance.

DSR

Hi,

You can get this functionality by creating a Drill through report.

First you need to create your original report with normal prompt page and detail page.

Again you need to create one more report with the detail page only and with the filters existing for each and every query.

Then Just you need to remove the finish button from your prompt page then....you need to put text 'Finish' at your finish button place.

Then you need to create drill through on this 'Finish' text.In drillthrough you need to pass all the parameter values to your drill target report.

Here there is some tricky point....which is...you need to have one extra prompt not visible to the user but it should be mandatory in the prompt page....

Your last prompt not extra prompt.....should be auto submitted to store or hold all the parameter values in the prompt page for drill through.

Your extra prompt need to be cascade from your last prompt....

You will get your output in extra page and your prompt page will be always open.....

Good Luck :)

Regards,
Sanjeev

Aish

This works like a breeze in cognos analytics too. Thanks Sanjeev
I made all prompts as cascading , created a dummy prompt which is cascading to the last prompt and hide them from users( this is to hold your prompt values)
Used reprompt button to get all prompt values and then a text  'Finish' as a drill through link (Open in new tab checked ) to the report with parameters
The User has to click on 'Reprompt' before clicking 'Finish' to pass all values to the report.
This renders report opens in new tab from prompt page  :)