consignment report

[hugz via AccessMonster.com]

Hi...

I have a problem regarding my consignment report..

I have my supplier name, label Of Product description, label of qty delivered,
label of qty sold, label of unit price, label of stock on hand, label of
discount rate and label of amount in the Supplier Name Header...

In the detail section there is the product description txtbox, qty delivered
txtbox, qty sold txtbox, unit price txtbox, stock on hand txtbox,
discountrate txtbox and amount txtbox...

What I want is all the products under the same supplier will be group..

what is happening in the report i constructed is that every tym a new product
is sold under the same supplier it creates a new section repeating the
supplier name but with different product..

How can i keep all the products under the same supplier grouped together??

Pls help me again..

tnx...

 

[Klatuu]

Use the Sorting and Grouping in the report builder to group by supplier.