sorting fields

  • Thread starter klp via AccessMonster.com
  • Start date
K

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!
 
J

Jan @ Family Service Lincoln

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top