Report Groupby variable

[cdesio]

Group by variable

Does anyone know how to group a report by a varible set on a form? I have
tried using
the expression type and using =[forms!filters!filter_name but it seems to
just ignore it.

 

[Marshall Barton]

Group by variable

Does anyone know how to group a report by a varible set on a form? I have
tried using
the expression type and using =[forms!filters!filter_name but it seems to
just ignore it.

The group level must already exist, but you can modify the
field that is used for the grouping.

Use code in the report's Open event:

Me,GroupLevel(0)/ControlSource = forms!filters!filter_name

 

[cdesio]

Marshall,

When I enter the below code into the open event I get this:

The expression you entered contains invalid syntax, or you need to enclose
your text data in quotes.

Group by variable

Does anyone know how to group a report by a varible set on a form? I have
tried using
the expression type and using =[forms!filters!filter_name but it seems to
just ignore it.

The group level must already exist, but you can modify the
field that is used for the grouping.

Use code in the report's Open event:

Me,GroupLevel(0)/ControlSource = forms!filters!filter_name

 

[cdesio via AccessMonster.com]

Got it. Thanks for pointing me in the right direction.

Marshall,

When I enter the below code into the open event I get this:

The expression you entered contains invalid syntax, or you need to enclose
your text data in quotes.
[quoted text clipped - 9 lines]

Me,GroupLevel(0)/ControlSource = forms!filters!filter_name

 

[Marshall Barton]

Sorry about the typo. Clumsy fingers and weak eyes
sometimes combine to put a comma where I meant to put a dot.
--
Marsh

Got it. Thanks for pointing me in the right direction.

Marshall,

When I enter the below code into the open event I get this:

The expression you entered contains invalid syntax, or you need to enclose
your text data in quotes.

Group by variable

[quoted text clipped - 9 lines]

Me,GroupLevel(0)/ControlSource = forms!filters!filter_name