[Unsolved] Using a prompts static choice values in an expression

[mallika]

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

[BIsrik]

can the values be equated to some columns in report. if so, try column = ?prompt?

Srik

[mallika]

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

[sir_jeroen]

Little reminder: close the topic if it's been solved/closed (see board rules)

[mallika]

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

[sir_jeroen]

Don't use a boolean, go for a string condition

[mallika]

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

[mallika]

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