Prompt on a expression 2

[MitraMIS]

Hi group;
I have made an expression in my report(named BACKLOG) that it's values are "Yes" and "No".
I have made a prompt for my backlog field using File picklist type with values "Yes", "No" and "All".
When user chooses "All" at the prompt, I need to show records containing Yes and No for backlog filed.
How would I do that?
I can get it to work when my prompt options are just "Yes" and "No", but not when I include "All".
TIA;
Mitra

 

[drlex]

Assuming you're using Impromptu, then you'll want the filter to include code like

(BACKLOG = ?Prompt? OR ?Prompt? = "All")

{'Fraid I don't know ReportNet syntax}

soi la, soi carré

 

[Nuffsaid]

drlex,

I tried it in ReportNet and it works!!
Thanks dude, I'll be adding it to my toolkit.


Nuffsaid.

 

[MitraMIS]

Thanks drlex.
It worked.

 

[drlex]

You're welcome and thank you both; you fellows are too kind.
lex

soi la, soi carré