Numeric field under string caption 1

[Ladyazh]

I have a numeric field.
I need to have it as a parameter.
If Y then show everything,
if N shoe only 0s.

I set it up as 1 as Y and 0 as N.

Now how do I show captions in Crystal so user will see Y and N and not numbers? Thanks

 

[synapsevampire]

Try:

Report->Selecton formula->record;

If{?Parm} = "Y" then
{table.field} = 1
else
{table.field} = 0

Check out my FAQ for advanced theory:

faq767-3825

-k

 

[Ladyazh]

Hi!
I had probably said it wrong.
If{?Parm} = "Y" then // {?Parm} is numeric field so it is not ='Y' it is 1

It goes like this
If Y show all Numbers else If N show only Zero values

 

[synapsevampire]

Try:

If{?Parm} = "Y" then
{table.field} <> 0
else
{table.field} = 0

-k

 

[Ladyazh]

Sorry {?Parm} can not be "Y" - it is numeric and default for it is number.

 

[Ladyazh]

Field CoName
0 A
0 B
1 C
2 D
3 E

If {?Field}<>0
then {t.Field}={?Field}
else
If {?Field}=0 then
true

I works well.

Now I need to find way to have user to choose not from 0,1,2,3 but Y and N

thanks

 

[synapsevampire]

Create default values in the parameter and place the letters in the description side and select show description only.

-k

 

[Ladyazh]

WOW! that was esy wasn't it? Never knew this!!! THANKS a million!