Help required with invoice design

[Douglas]

Im am trying to create an invoice and am in need of a little help with
a problem , the invoice (i hope it looks of on your screen) looks
summin like this below


Page is Landscape
_______________________________________
| | Cust Details|
| Company Info | Car Info | Report Header
|_________________________|_____________|
| | |
| Invoice Item 1 | Desc. of |
| Invoice Item 2 | Work Done | Detail
| etc etc | |
|___________________|___________________|
| Invoice |
| Totals | Report Footer
|_______________________________________|
| Date Page No | Page Footer
|_______________________________________|


The problem i have is with Invoice Items and the Description of Work
Done

I want invoice Items to take up the LHS of the page (could be any
amount of items) and the Description of Work Done to take up the RHS
of the page (Desc of Work Done is a single text field)

At the moment i dont have the Desc of Work Done field in the report
because when i put it next to the Invoice items field on the report,
it appears once for every number of items in the invoice, can you see
my problem???
I only want the Desc of Work Done to appear once.

It works ok if i move it to another section of the report ie Report
Footer but it would look a lot better next to the invoice items and
would fill a big white gap.


I hope this makes sense

TIA

Doug

 

[Marshall Barton]

Im am trying to create an invoice and am in need of a little help with
a problem , the invoice (i hope it looks of on your screen) looks
summin like this below


Page is Landscape
_______________________________________
| | Cust Details|
| Company Info | Car Info | Report Header
|_________________________|_____________|
| | |
| Invoice Item 1 | Desc. of |
| Invoice Item 2 | Work Done | Detail
| etc etc | |
|___________________|___________________|
| Invoice |
| Totals | Report Footer
|_______________________________________|
| Date Page No | Page Footer
|_______________________________________|


The problem i have is with Invoice Items and the Description of Work
Done

I want invoice Items to take up the LHS of the page (could be any
amount of items) and the Description of Work Done to take up the RHS
of the page (Desc of Work Done is a single text field)

At the moment i dont have the Desc of Work Done field in the report
because when i put it next to the Invoice items field on the report,
it appears once for every number of items in the invoice, can you see
my problem???
I only want the Desc of Work Done to appear once.

Use Sorting and Grouping (View menu) to create a group on
the expression =1 and set the group's Group Header property
to Yes.

Now, move the description text box to this new header
section and make sure its CanGrow proerty is set to Yes. To
make it appear in the detail space, add a line of code to
the header's Format event procedure:
Me.MoveLayout = False

 

[Douglas]

This worked great but with one drawback
The order of the Invoice Items are now coming out in the reverse order
of that in which they were entered into the database

eg

Item 1
Item 2
Item A
Item B

as stored in the Invoice table and the order on the form comes out as:

Item B
Item A
Item 2
Item 1 on the invoice

Is there a way to get it in the right order, when i remove the =1
Grouping it is correct again but i loose my formatting.

TIA

Douglas

 

[Duane Hookom]

The only 100% accurate method of assuring the order of records in a report
is to have a field or expression that determines that order. There is no
always accurate "order they were entered".