report design ??

[ronnie_knight]

I'm trying to design a report using the wizzard, and I have an
expression in the related query that I want to group by. But when I get
to the "group by" screen of the wizzard, that expression is not
avaliable. Is there any way to do this?

 

[Al Camp]

Ronnie,
You can use expressions in the Sorting and Grouping dialog box, or you
can evaluate the expression in the query behind the report.
What's the expression are you trying to group on?

Wizards are very limited. Use the wizard to set up the basic data, and
then use report design mode to fine tune.

 

[ronnie_knight]

Thanks! That part is working, but now, how do I get the report detail
to sort as it is in the query?

 

[fredg]

Thanks! That part is working, but now, how do I get the report detail
to sort as it is in the query?

Any sort order you have in the query is irrelevant to the sort order
in the report.
To sort the report, use the report's Sorting and Grouping dialog.
View + Sorting and Grouping

 

[Al Camp]

Fred's right. The Sorting and Grouping overrides any sorting done in the
query.