[DarenR]

I am trying to repair a crystal report in which the field is a bit 1= true 0 = false.
We use a stored proceedure to gather info for the report.
The client wants all information returned in groups such as a true group and a false group.
This is for login information such as being active.
I usually do not work much with crystal reports so I am shooting in the dark.

GroupName ({pr_get_all_inactive_and_active_employees;1.bit_active} = 1 then true)
else
GroupName ({pr_get_all_inactive_and_active_employees;1.bit_active} = 0 then false)

I put the above in group selection but when i try to save it says missing ")"

can anyone see where it is missing? or is there a better way to write this true false statement?

thanks

[e_i_pi]

I don't use Crystal Reports, I use SSRS, but having a look at your syntax, it looks out to me. Notice what happens when I indent:

GroupName (
	{pr_get_all_inactive_and_active_employees;1.bit_active} = 1 then true
) else GroupName (
	{pr_get_all_inactive_and_active_employees;1.bit_active} = 0 then false
)

Your conditional statement is being closed off by the ) brackets before the else keyword is reached. I imagine this is the problem, but I don't know enough about Crystal Reports to help you any further

[DarenR]

you have to close the statement before else in crystal