Need grouping in report

nota

Dear Nav. Gurus!
Will someone help me how to make a simple report with grouping and totaling?
Following is the requirement;
1) The report has to be based on the Tran. Sales Entry
2) Should have the columns:
Item No Description Price Quantity Net Sales
3) I want to group this report on "ITEM NO" on every change of item no, it should give me the total of "QUANTITY"
and "NET SALES"
Hope someone will help
Thanx!

DaveT

Hi,

I'm not familiar with the table but here's the steps

1. select a key which starts with Item no. use the DataItemTableView property - you will need to add one if one not there
2. add the Item no. to the GroupTotalFields property
3. add Quantity and Net Sales to the TotalFields property
4. Add a section type GroupFooter and and textboxes for Quantity and Net Sales.

nota

Thanks Dave!
It works cheers =D>

DaveT

Glad to Help