Link to home
Start Free TrialLog in
Avatar of Sue Taylor
Sue TaylorFlag for United States of America

asked on

Grouping/Sorting Help in Crystal Reports

I'm trying to create a report that will show me what stage a non-conformance report is in.  There's various tabs within the program that get completed (Origination, Investigation, Disposition, and Verification) There is a check box that the user marks to complete that particular section.    I thought that the best way to be able to show me the current stage was to  group my report by what stage it is in.  So I've attempted to create a formula but I'm having issues getting the formula's syntax correct.

Is this the best/easiest way to do this?  I also suppose I need to check if isnull in my formula as well which I haven't done yet.

My formula reads:
if  totext({view_PT_NC.Originated_complete}) = 'True' and
if totext({view_PT_NC.Investigation_complete}) = 'True' and
if totext({view_PT_NC.Disposition_complete}) = 'True' and
if totext({view_PT_NC.Verification_complete}) = 'True' then
"closed"

else

if  totext({view_PT_NC.Originated_complete}) = 'True' and
if totext({view_PT_NC.Investigation_complete}) = 'True' and
if totext({view_PT_NC.Disposition_complete}) = 'True' then
"Verification"

else

if  totext({view_PT_NC.Originated_complete}) = 'True' and
if totext({view_PT_NC.Investigation_complete}) = 'True' then
"Disposition"

else

if  totext({view_PT_NC.Originated_complete}) = 'True' then
"Investigation"

else
 "Unknown"
--mail-staylor--Custom-Reports-uniPo.rpt
ASKER CERTIFIED SOLUTION
Avatar of UnifiedIS
UnifiedIS

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sue Taylor

ASKER

Thanks!