>Hello!
>
>I'm trying to create groupings in a report based on what fields a user selects from a picklist. I create a variable that contains the fieldname to be grouped on and I put that variable in my report's "Data Grouping".
>
>My problem is that I can't seem to pass it as a reference. I've tried &gcGroup also (gcGroup) also (&gcGroup) also just plain gcGroup. Nothing works. My conclusion is that I can't use name expressions or macro substitution in a report form. Is this true or am I doing something stupid. If so, does anyone have any other ideas how to set up groupings in a report on the fly?
>
>AHWBGA!!!
>
>Thanks
>
>Kevin

You could use Doug Hennigs report object classes and add the Group Bands to the FRX programmatically prior to running the report. I believe these were published in the June issue of FoxTalk.

BOb