Use ReportViewr To create Invoices

[Guest]

I am trying to create an app that creates invoices from data in a database.
Sales information is imported/entered throughout the day, then at EOD, all
the reports are generated and printed.

The data in the order information database might look something like:

OrderNumber / CustomerName / Item / Price
0001 / John / Ord1Itm1 / 1.00
0001 / John / Ord1Itm2 / 1.54
0002 / Sally / Ord2Itm1 / 2.00
0003 / Steve / Ord3Itm1 / 1.00
0003 / Steve / Ord3Itm2 / 4.30
0003 / Steve / Ord3Itm3 / 3.50

As you can see, a single order may have several records to reflect line item
information.

What I would like, is when the "report" is run, each page contains a single
invoice, so in this example, there would be 3 pages. Page 1 would have John
and itemize his 2 items, page 2 would have Sally and her Item, etc...

I am able to get the report to come out correctly if i specify the order
number:
I.e., Use: "Select * from Orders where OrderNumber = '0001'"

So this means the report would need to be run 3 times in this example. I
would like to use instead: "Select * from Orders", that way i only have to
run the process once.

Any suggestions or information is much appreciated.

 

[Guest]

Hard to find a sample that explains it all

I think in this post you will find how to make it (master detail + page
break):

http://www.codeproject.com/sqlrs/1t...sp?df=100&forumid=226607&exp=0&select=2224223

Good luck
Braulio

/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------