asked on

Crystal Reports: How to create an invoice (Header and invoice line on one page)?

Hi experts

I'm trying to create an invoice (customer, orders).
Currently I have the whole data (customer data and order-data) in one query and I can't use a subreport.
The problem is that every invoice line (every order) is on a new page. I already tried to group by customer-id.

How can I have the Invoice header with the customer's data in my page header an all my orders in my detail section?

Thanks

Marcus Aurelius

So you want the Customer Name, Address, City ZIP etc..to appear in your HEADER of the invoice?

If so, then you'll need to somehow get that info into the QUERY...OR...better yet just use a VIRTUAL TABLE Query to pull that data into your report.

Write the SQL like this:

select CustID, CustName, Address, City, State, Zip
from yourTable

Then enter this SQL at the DATASOURCE ADD COMMMAND line. It will create a "virtual" table...that you can use for reporting. You can then use these data objects in your Header or wherever else you want to use them.

Oh,..you'll need to include a LINKING field in your SQL so that the table can be linked to your other tables.

M

Arikael

ASKER

thanks,

I forgot to mention that I use Crystal Reports from VS2008.

yes, I want the Customer Data in the header.
The information is already in the query which holds the invoice lines.

ASKER CERTIFIED SOLUTION

Marcus Aurelius

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Mike McCracken

Agree. I don't see the problem unless you have NEW PAGE BEFORE or AFTER set on the detail sectiion.

Is the customer id unique to the customer?

Does a customer have several orders?

Do orders have a unique id?

mlmcc

Arikael

ASKER

Hi,
Sorry, I was really busy this weekend.

a customer may have more than one invoice and every invoice contains (n) orders.
Every customer has a unique id and so does an order

Arikael

ASKER

well, to be more specific

there is a customer, a customer has multiple offices.
Every office can have multiple orders with multiple articles.

I now have to create an invoice for every office

Arikael

ASKER

Hi,

don't know where my mind was last friday *g*

Grouping by customer did it thanks

Marcus Aurelius

LOL, I know what you mean,...I've had those kinds of weeks myself....anyway, I'm glad I could be of service.

M