Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: mallika on 11 Oct 2005 05:11:53 PM

Title: [Unsolved] Using a prompts static choice values in an expression
Post by: mallika on 11 Oct 2005 05:11:53 PM
i have created static choice values on a prompt. Is there any way to use the prompt values passed by the user in an expression.

ParamValue and ParamDisplayValue functions seem to work only in the layout expression windows and not either on filter expression or calculation expression.Ã,  Ã, :-\

Thanks
Title: Re: using a prompts static choice values in an expression
Post by: BIsrik on 12 Oct 2005 10:02:03 AM
can the values be equated to some columns in report. if so, try column = ?prompt?

Srik
Title: Re: using a prompts static choice values in an expression
Post by: mallika on 12 Oct 2005 12:30:24 PM
actually i am using the static values (not related to the database) for some logical grouping of data in the report. if i were to create two static choices A and B, when the user selects A , I want a  filter condition applied on the report and if user selects B, a different filter condition applied on the report. I guess I can use condtional formatting with a conditional block but that is so much more work... if i could only use the values in a regular filter expression that would be easy.

Please let me if anyone has any ideas, otherwise I will go with the conditional block approach. Thanks
Title: Re: using a prompts static choice values in an expression
Post by: sir_jeroen on 13 Oct 2005 05:21:33 PM
Little reminder: close the topic if it's been solved/closed (see board rules)
Title: Re: using a prompts static choice values in an expression
Post by: mallika on 14 Oct 2005 08:36:12 AM
i managed to resolve this issue partially, still working on it. I created conditional layouts for each static variable, each layout with a different query and different filters to achieve the output i want. The only problem is i am unable to create more than two conditional layouts, in my requirement, i need to create 3 layouts for 3 static variables. Does anyone know if this is a reportnet limition? Please let me know if you had similar issues.

Thanks,
Mallik
Title: Re: using a prompts static choice values in an expression
Post by: sir_jeroen on 14 Oct 2005 09:57:03 AM
Don't use a boolean, go for a string condition
Title: Re: using a prompts static choice values in an expression
Post by: mallika on 14 Oct 2005 10:58:30 AM
Oh yes , I did use a String Variable... for some reason when i create the two layouts + the default layout, it does not work.... With only a total of two layouts it works  ???. Server's been down since morning... will try closing this topic shortly..

Thanks
Title: Re: using a prompts static choice values in an expression
Post by: mallika on 17 Oct 2005 11:54:01 AM
Couldn't resolve the multiple layout issue... had to create two seperate reports..

I am closing this topic. If someone has created more than two conditional layouts in a single report , pls. post solution if possible.

Thanks
Text only | Text with Images