Print Page - Prompt Issue in report Page

Title: Prompt Issue in report Page
Post by: kiran04 on 14 Jun 2011 03:31:19 PM

Hi All,
I'm having two value prompts in the report page as well as in the prompt page. The issue is , they are cascaded prompts and they are working fine in prompt page but in the report page, when the first prompt is selected , it is directly running the report without selecting the second prompt.
note:
the two value prompts here are --required
the autosubmit is kept 'yes' for the first prompt in both the pages.
please , reply me with your suggestions to resolve this issue.

Title: Re: Prompt Issue in report Page
Post by: kattaviz on 16 Jun 2011 10:04:28 AM

Hi,

Do you see any prompt value selected in the second prompt in the report page. That may be the issue here.

HTH

Title: Re: Prompt Issue in report Page
Post by: kiran04 on 17 Jun 2011 03:52:26 PM

The second prompt is taking values from the first, after the the first prompt is being selected and it runs the report without hitting the finish button.
I thought , in the report page as it is a cascaded prompt, the page is refreshing after the first prompt is selected and then it's selecting the second one and running the report.
so, any thoughts on this issue ..or I need to javascript to use for this one.

thanks,
kwas04.

Title: Re: Prompt Issue in report Page
Post by: MFGF on 20 Jun 2011 08:21:43 AM

The issue is that 'submit' is submitting the page, which is both populating the second prompt and also the report object on the page. I don't see what you can do to change this, other than to move the prompts onto a prompt page.

MF.

Title: Re: Prompt Issue in report Page
Post by: kiran04 on 22 Jun 2011 09:29:01 AM

Hi MFGF,
Yes, i think you are correct but the requirement is that we need to have those prompts in the report page. In there any way, we can do it or if any java script can help me.

Thanks,
KWAS04.

Title: Re: Prompt Issue in report Page
Post by: cogswell on 22 Jun 2011 10:18:15 AM

I think NimrodA's idea (http://www.cognoise.com/community/index.php/topic,13441.msg42499.html#msg42499) should help you.

Title: Re: Prompt Issue in report Page
Post by: kiran04 on 23 Jun 2011 01:04:58 PM

I resolved my problem. I used a conditional variable to see if the second prompt is null or not. so , if the first prompt is selected then it is autosubmiting to second prompt and running the report..Now it will check that if second prompt has selected a value or not. If it is selected , the report will run otherwise not. In short im hiding the report output when the second prompt is not selected. This solved my problem.

thanks,
KWAS04.

Title: Re: Prompt Issue in report Page
Post by: PRIT AMRIT on 23 Jun 2011 09:04:57 PM

KWAS04-- Good work around 8)

Title: Re: Prompt Issue in report Page
Post by: Amruta Gandhi on 28 Jul 2011 02:23:44 AM

Good one! :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: kiran04 on 14 Jun 2011 03:31:19 PM