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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

summarys at beggining of report

Status
Not open for further replies.

Bloke152

Programmer
Aug 9, 2005
123
NO
Does anyone know how i would be able to produce summarys at the begginging of a report?
What it basically is, is that Im reading from a file with different types of suppliers in it. These suppliers can either be a L type or an E type. What i need to do is count how many of each are in the table. I also eventually need to count how many invoices there are associated with each type of supplier but i'll think about that later. The difficult bit is that user wants this information displyed on the first page. Any help would be much appreciated!
Thanks!
 
Insert a crosstab where you use type as the row and count of suppliers as the summary. You can then add a second summary, count of invoices, for your other requirement.

Place the crosstab in a report header section.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top