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

 

How to run a report with prompts based DMR and avoid the prompt using URL?

Started by will.sl, 19 Dec 2008 09:33:52 AM

Previous topic - Next topic

will.sl

Hi,

I will develop a report with prompts and the report will be passed parameters and run through a webpage (.asp) using URL. I've learn related documents and samples with SDK and tried to test them but failed. The curious thing is the prompt page always pop up even I run the samples comes from Cognos (at ../../samples/asp). My developing environment is Cognos 8.1.

Thanks in advance,

Sunchaser

Hi,

In the Cognos folder where the report is stored, go to the "Properties" of the report (Set properties), and search the "Prompt for values" option -> uncheck this option.

When launching the report using the URL, if each of the required parameters really have at least one value, the prompt page shouldn't appear.

Hope it helps,
vinc.



will.sl

Thanks for your reply. But still no luck on it. Following is the method I used. Please review it(separated into lines intentionally):

http://192.168.0.120/Cognos8/cgi-bin/cognos.cgi?b_action=xts.run
&m=portal/launch.xts
&ui.tool=CognosViewer
&ui.object=/content/folder[@name='11111']/report[@name='test']
&run.prompt=false
&ui.action=run
&p1=2005



Sunchaser

Hi,

I don't have such problems (I'm launching my reports with URL too), but according to Cognos docs, you should try to add:

&run.prompt=false

at the end of the URL.
(if you have access to cognos support, i can give you the link)

Hope it's the good one ...

will.sl

No, it isn't working. I'm wondering if cognos8.1 surports this method. Any ideas? 

Sunchaser

Hi,

OK, I don't know for 8.1 but can say for sure that it's working on 8.2 and 8.3.

I'll tend to think that some parameter given to one of the SQL is missing; I mean that even if you define the property "Required" of a value-prompt (for example) to "No", depending how you use the paramter for the SQL it can be still considered as Required by cognos and it will ask you for some value.


will.sl

Would you mind posting an example for me if possible? It seemed if report is based on DMR then it didn't work. This problem has me completely stuck. Thanks.

Sunchaser

Hi,

I can't answer you for the "DMR" problem, I don't know and I'm sorry.
May be you should first try to put on the prompt page of the "target report" some items like "?param_display_value?" (see calculation or layout calculation item for ex): the idea is to see if the values expected are passed through the URL, or if there are any values passed. (you will see it, because for the moment whatever happens your prompt page is alwways shown, isn't it ?).

One question from my site: how is your URL (i mean the par with the parameters) ? Which syntax do you use ? Maybe there's a small problem in it ...

I won't be able to post anything from the current system on which I'm working, sorry: everything has to be like "encrypted", so I can't let even a folder name appear.