GROUP SPECIFIED ON A NON-RECURRING FIELD.

[dellguy]

CRXI

I created a formula that originally contain a value from one of 3 table fields based on a parameter and this was used for report grouping.

formula:

IF {?GROUP} = 'C'
THEN TRIM({ARINVT.CLASS}) + " : " + {ARINVT_CLASS.DESCRIP}
ELSE
IF {?GROUP} = 'P'
THEN TRIM({PROD_CODE.CODE}) + " : " + {PROD_CODE.DESCRIP}
ELSE
IF {?GROUP} = 'M'
THEN {@Minor Group}


This was fine. Now I want to add a 4th parameter for a value that can only be derived from a subreport. I know if you try to use a shared variable in a formula that is used as a group, you get the subject error.

Is anyone aware of a way to accomplish this some other way ?

Larry

 

[lbass]

You can't group or sort based on a subreport shared variable, so you would have to find a way to eliminate the need for a subreport.

-LB

 

[dellguy]

Exactly what I was thinking. I've written a COMMAND file to get the same output as the subreport. Complex SQL not my forte but I'll figure it out.

Thanks LB.