How to Build an Invoice Report

[Auguy]

I need some general guidance on how to build something like an invoice report where you have header information, then some detail records, and finally some totals at the bottom. Do you use a subreport for the detail lines? What controls do I use for the different sections? As you can see, I need some assistance.

Auguy
Northwest Ohio

 

[xlbo]

really depends on teh exact layout of your data

Would've thought you can do it all in 1 report with a couple of tables

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Auguy]

Thanks Geoff. What I have is a table returned form an SQL proceduere that joins the invoice header table and the invoice detail table. This returns a table with N rows of data containing both the header and detail information. The problem I'm having is I want to be able to position labels and fields in a free form mode because I have many different types of fields I need in the header info. If I use a table control I can't do this, if I use a List control, it will repeat the info for every record. There must be something simple I'm missing here. This type of report must be fairly common where you have header and detail information.

Auguy
Northwest Ohio

 

[Auguy]

I found some help here. Hope the folks at Tek-Tips don't mind.

http://www.codeproject.com/KB/reporting-services/1tomanyreports_vsnet2005.aspx

Auguy
Northwest Ohio

 

[xlbo]

Yup - based on last response, was going to suggest eith er2 tables in a list control or some textboxes for the header info and a table for the detail, again within a list control. The key, I think is in the group setup

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Auguy]

Thanks Geoff. The part I was missing from the start (why I don't know) was the grouping on the list control to prevent repeating the header info. I also downloaded a back button icon to place on the report because this report is being called thru a jump to URL.

Auguy
Northwest Ohio

 

[xlbo]

ooooh - "Back Button" - do you have a link for that?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Auguy]

I think I got it free here (

http://www.icongalore.com/software-icons/back-button-icon.htm),

but can't seem to find it now.
If you're looking for the code, see the thread I started "SQL Jump To Report Not Working" in the Tek-Tips Visual Basic/VB.net forum.

Auguy
Northwest Ohio