May 3, 2007 #1 Ladyazh Programmer Sep 18, 2006 431 US 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
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
May 3, 2007 1 #2 synapsevampire Programmer Mar 23, 2002 20,180 US 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 Upvote 0 Downvote
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
May 3, 2007 Thread starter #3 Ladyazh Programmer Sep 18, 2006 431 US 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 Upvote 0 Downvote
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
May 3, 2007 #4 synapsevampire Programmer Mar 23, 2002 20,180 US Try: If{?Parm} = "Y" then {table.field} <> 0 else {table.field} = 0 -k Upvote 0 Downvote
May 3, 2007 Thread starter #5 Ladyazh Programmer Sep 18, 2006 431 US Sorry {?Parm} can not be "Y" - it is numeric and default for it is number. Upvote 0 Downvote
May 3, 2007 Thread starter #6 Ladyazh Programmer Sep 18, 2006 431 US 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 Upvote 0 Downvote
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
May 3, 2007 #7 synapsevampire Programmer Mar 23, 2002 20,180 US Create default values in the parameter and place the letters in the description side and select show description only. -k Upvote 0 Downvote
Create default values in the parameter and place the letters in the description side and select show description only. -k
May 3, 2007 Thread starter #8 Ladyazh Programmer Sep 18, 2006 431 US WOW! that was esy wasn't it? Never knew this!!! THANKS a million! Upvote 0 Downvote