COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: srinu1253 on 08 May 2011 10:59:45 AM

Title: Overide Default Prompt Selection values??
Post by: srinu1253 on 08 May 2011 10:59:45 AM
Hi

I am using Prompts in the Report Page.I have set default values to these Prompts?
When I run the Report first time I am getting  data in the List Correctly.

But When I am selecting values in the Prompts and then Submit. I am unable to get the data??


Please any Ideas would be Appreciated.....

Title: Re: Overide Default Prompt Selection values??
Post by: srinu1253 on 09 May 2011 10:19:58 AM
Hi,

Please find th attached Report specification....


Regards
Srinivas.
Title: Re: Overide Default Prompt Selection values??
Post by: kattaviz on 09 May 2011 10:38:52 AM
Hi,

Change your prompts Autosubmit to "NO" and see if you get the correct data?
Title: Re: Overide Default Prompt Selection values??
Post by: srinu1253 on 10 May 2011 02:15:12 AM
Hi Satish,

Thanks for your Response!!
Done but no change....

Title: Re: Overide Default Prompt Selection values??
Post by: bdbits on 10 May 2011 01:24:02 PM
Change your prompt button type from "Reprompt" to "Finish".
Title: Re: Overide Default Prompt Selection values??
Post by: srinu1253 on 13 May 2011 06:09:43 AM
No its not working...
Title: Re: Overide Default Prompt Selection values??
Post by: kattaviz on 13 May 2011 04:01:25 PM
Hi,

It seems you are using relational filter syntax for a Dimensional source. Try using the dimensional filter syntax like  "[level or hierarchy]->?p?".Also remove the "cast" function from the filters.

HTH

Title: Re: Overide Default Prompt Selection values??
Post by: srinu1253 on 19 May 2011 02:19:41 AM
Hi Suresh,

Thanks for your Reply.
I have tried using -> in the filters by dragging the level for Product Line & Product Type but its of no use...


Regards
Srinivas