conditional sub-grouping - cr11

[mleckie]

I would like to have a sub-group change which field is use to group on based upon the a parent group field.

for example - if the parent status field is 1, 2, or 3 I want my sub group use the coordinator name field but if it is 4,5 or 6 use the project manager field.

Is there a way to do so w/o resorting to subreports?

thanks
mike

 

[lbass]

Insert a Group#2 on this:

if {table.parentstatus} in [1,2,3] then {Table.coordinatorname} else
if {table.parentstatue} in [4,5,6] then
{table.projectmanager}

-LB

 

[mleckie]

Wonderful, it worked perfectly. This will open up a lot more options for me to fix other reports.

Thank you.