Query/Report Problem

[Benn]

Hello all, wasn't quite sure whether this was specifically a query related problem or something to do with the report so thought it fit better in the 'general' category.

Basically I have a customer table and an orders table that I am trying to generate invoices for.

I am using a query with the fields I require and the problem I am having when running it is that it is showing the customer information multiple times.

Example:

Customer name, address, etc - OrderID1, order details
Customer name, address, etc - OrderID2, order details
Customer name, address, etc - OrderID3, order details
etc, etc.

I just want to display the customer information once, have this formated nicely in the corner (ready to be sent to the customer) and then have a list of all of their outstanding orders.

I'm hoping there is a simple solution to this and I have not got to redo my realtionships.

Thank you for any help and advice you can give.

Edit: Using parameters in the criteria of Customer field to generate orders only for that customer.

 

[rainman89]

There are some sort options that you can do in the report properties that should do what you want.

 

[Benn]

Thanks, I found it in the Grouping and Sorting in the right click menu.

 

[Kiwiman]

Howzit

Try putting your Customer Information (Name, address etc) in the Report Header section - it should only show the once, no matter how many times it shows in the underlying query. Put the Outstanding Order Details in the detail section of the report.

I do this for my invoices and it works just fine.

 

[dan231]

I have a similar problem.
What sorting options did you use?

My scenario is a client listing with multiple project data. My query is correct, but my report keeps picking up the list of projects in the query regardless of the client. I'm trying to make a letter with client info on top and project data in the detail.