How do I pass variables for 'Sorting and Grouping' in a report?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Emvee - 10 Sep 2005 16:54 GMT

We can have data source an sql query, a query name or a table name by sorted.
But in case I want grouping, without using 'sorting and Grouping' provided in
the report. Need to pass grouping variable thru code?

Reply to this Message

Allen Browne - 10 Sep 2005 17:03 GMT

For an example, see:
Sorting Records in a Report at run-time
at:
http://allenbrowne.com/ser-33.html

In Access 2002 or 2003, you can pass the value(s) in the OpenArgs of the
report. In earlier versions, use a public string variable.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> We can have data source an sql query, a query name or a table name by
> sorted.
> But in case I want grouping, without using 'sorting and Grouping' provided
> in
> the report. Need to pass grouping variable thru code?

Reply to this Message