Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Order by number of pages

Status
Not open for further replies.

usercry

Technical User
May 3, 2010
4
IT
I have a report with a detail section. Each invoice can have 1, 2, 3, 4 or 5 pages. There is a way for order report by number of page? Because I need to print before one page invoice, and then the others.
(In the report I have a group)

Sorry for my little english

Thanks a lot for help
 
I don't think you can do this just by pages, but you could do a group sort that might do basically the same thing. Place the invoiceID in the detail section and right click->insert summary->insert a count on it at the invoiceID group level. This will activate the group sort. Then go to report->group sort and select "All"->count of invoiceID->descending.

This should work if each row in the invoice was only one "line"--no wrapping of text.

-LB
 
This trick is amazing! Working perfect. Thanks thanks a lot for help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top