stored procedure value format simple i hope 1

[Sammy145]

I have the desired result i recieve 2 rows from a query total sales by gender but instead of male and female i get 0 and 1 how can i format this in crystal

eg

0 $320002 1987
1 $450333 1976

thanks
s

 

[Turkbear]

Hi,
What is the data field that determines Gender and what values are in it..







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Sammy145]

hi i have create a cross tab report and have the following

age range as coloumns
gender as sub colomn and it works but show 0 or 1
category as row
order value as summary

 

[lbass]

Create a formula:

if {table.gender} = 0 then "Male" else
if {table.gender} = 1 then "Female"

Use this instead of the groupname (if you are grouping on {table.gender}, or insert the group on the formula instead of on {table.gender}.

-LB

 

[Sammy145]

lbass u rock matey thanks worked perfect

 

[Turkbear]

Hi,
I assume the 0 is Male and 1 is Female ( otherwise some folks may be upset by their designation)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

There was no doubt in my mind.

-LB