report form with conditional grouping doesn't work

Question

I created a report (after the user answer certain questions). One of those question was regarding grouping.

The report (which originally didn't have grouping) now will have a conditional grouping

IIF(LEFT(lc_group,1)="C", "Custno", IIF(LEFT(lc_group,1)="L", "loctid+custno", ""))

However, even when the index is the right one, and the groop header starts correctly, the groups end at the end of the report and no at the end of each group.

What am I doing wrong r am I missing any step?

 

Answer 1

Both "Custno" and "loctid+custno" are string literal constants and they do not change during the report. You have to remove double quotes.

Answer 2

Thank you