sorting fields

[klp via AccessMonster.com]

I have a report that I created a group on Customer #. BUT I need my report
to be sorted by descending dollar value. I've done a few different things.
I've changed my query sort order and in the sorting & grouping I added my
extAmount field sort descending. If I put it after the CustNo, it does not
sort, if I do it before CustNo, then my CustNo field is not grouped together.
Any suggestions?

Also on a different report I want to print out customer information BY
CUSTOMER. So I grouped my customers using sorting & grouping but it prints
all the customers together. I want them on separate pages. I put a page break
in but I get a blank sheet. In the reportHeader I set forceNewPage =
BeforeSection still does not work. Any suggestions on this one?

Thanks in advance!

 

[Guest]

Are you using a query to create the report? You should be and use the
autosum feature. This adds another line to the query setup where you can
change grouping options. I use this to do totals and counts.