Sue Taylor
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.Origina ted_comple te}) = 'True' and
if totext({view_PT_NC.Investi gation_com plete}) = 'True' and
if totext({view_PT_NC.Disposi tion_compl ete}) = 'True' and
if totext({view_PT_NC.Verific ation_comp lete}) = 'True' then
"closed"
else
if totext({view_PT_NC.Origina ted_comple te}) = 'True' and
if totext({view_PT_NC.Investi gation_com plete}) = 'True' and
if totext({view_PT_NC.Disposi tion_compl ete}) = 'True' then
"Verification"
else
if totext({view_PT_NC.Origina ted_comple te}) = 'True' and
if totext({view_PT_NC.Investi gation_com plete}) = 'True' then
"Disposition"
else
if totext({view_PT_NC.Origina ted_comple te}) = 'True' then
"Investigation"
else
"Unknown"
--mail-staylor--Custom-Reports-uniPo.rpt
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.Origina
if totext({view_PT_NC.Investi
if totext({view_PT_NC.Disposi
if totext({view_PT_NC.Verific
"closed"
else
if totext({view_PT_NC.Origina
if totext({view_PT_NC.Investi
if totext({view_PT_NC.Disposi
"Verification"
else
if totext({view_PT_NC.Origina
if totext({view_PT_NC.Investi
"Disposition"
else
if totext({view_PT_NC.Origina
"Investigation"
else
"Unknown"
--mail-staylor--Custom-Reports-uniPo.rpt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER