Hi, All,

I've worked with .net and sql server for some time, but I am new to Reporting Services and I'm on a real short time frame, so I'm hoping someone can give me some quick info.

I need to generate invoices and purchase orders. The invoice examples I've seen are selected by invoice #, so of course the invoice always has the detail and header info with the same invoice #. My invoices and purchase orders will typically have more than 1 detail row.

How do I print invoices or purchase orders in batch mode, typically selected by date, and have the correct header information (vendor name or customer name) at the top of each invoice & purchase orders so that it syncs with the detail rows?

I'm assuming I'm going to insert a table in the invocie for detail rows, but I haven't figure out how to sync it with the customer's info in the header.

I'm using sql 2000 and rs 2000 with vs 2003.

Thanks a lot.