Select case statement 1

[mchambers]

Hello
First off I am using a cross tab if that helps.
I have a select statement here below:

Select case {Patient.sex}
Case "M" :
"Male"
Case "F" :
"Female"
Default :
"Unknow"


I get no errors, but the problem is this result:

Total
0%
Male 34%
Male 65%
Total 100%

Why is it only showing the label male?

When I remove the formula I get

Total
0%
F 34%
M 65%
Total 100%

Can anyone help me correct this issue? Thanks

 

[IdoMillet]

Are you 100% sure you are using that Select Case formula as the CrossTab row? Looks to me like you are using something else for it.

hth,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Where are you putting the formula? Display string doesn't work for this. You should go into the crosstab expert->select the row field->group options->options tab->customize group name->use a formula->x+2 and enter it there.

Or you could just the formula as the row field.

-LB

 

[mchambers]

@lbass

Thanks, it worked great!!! I was sticking in the display field and thats why I was getting it wrong. I add the formula where you said and it worked great. Thanks again!!

 

[mchambers]

One more thing. I have a top row with 0%...i dont know why that is there. Can anyone help me with that?

 

[mchambers]

Opps never mind I figured out how to suppress them. Thanks