Nicole Furnival
asked on
Titles in grouped crystal report based on formula not correct
When I am grouping fields in my crystal report, I have added a formula to the group expert options formula saying IF {CnAct_1AttrCat_4.CnAct_1A ttrCat_4_D escription } = "A" then "IMMEDIATE PRIORITIES" else "TOP PROSPECTS". This works great until the end, when it adds another TOP PROSPECTS name to the end of the report. Does anyone know how I can fix this. The group footer is already suppressed.
{CnAct_1AttrCat_4.CnAct_1A ttrCat_4_D escription } = "A" then "IMMEDIATE PRIORITIES" else "TOP PROSPECTS"{CnAct_1AttrCat_ 4.CnAct_1A ttrCat_4_D escription } = "A" then "IMMEDIATE PRIORITIES" else "TOP PROSPECTS"
Solicitation-Tracking-report-Photo.docx
{CnAct_1AttrCat_4.CnAct_1A
Solicitation-Tracking-report-Photo.docx
Most likely, it's caused by a record with a NULL for the field you are grouping on.
That creates a new group, but the group name maps to "TOP PROSPECTS" because of the logic of the the Group Name expression.
That creates a new group, but the group name maps to "TOP PROSPECTS" because of the logic of the the Group Name expression.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Are you grouping on that formula?
Can you upload the report file?
mlmcc