How to create this report

[ak]

I need a invoice report as below. Please inform how to do.


INVOICE_NO ___________ DATE________
TO _______________________________

___________________________________________________________
LINE_NO DESCRIPTION QTY UNIT PRICE TOTAL
___________________________________________________________

1 XXXXXXXXXX XX XXXX
XXXX
2 XXXXXXXXXX XX XXXX
XXXX
3 XXXXXXXXXX XX XXXX
XXXX
4 XXXXXXXXXX XX XXXX
XXXX

 

[Allen Browne]

Open the Northwind sample database that installs with Access.
Look at the Invoice report for an example of how to do it.

You will need to understand how the data is stored in tables.
The Invoices query combines the data from the tables to feed the report.

 

[ak]

Mr. Allen,
For more easiness for me I would like to know how to print according to line
numbers. Please specifically tell me this. This is very important for me.
Your great help will be a very big advantage for me.

 

[Allen Browne]

In report design view, use the Sorting And Grouping dialog to choose the
fields you want to sort by.

If you want to sort the line items, in a particular order, you may need to
add a field to the subform where you enter the line items.

 

[Evi]

Ak, do you mean that you want each record in your list to be numbered?
Evi

 

[ak]

Evi,
Yes, I mean each record in my list to be numbered. This is the only problem
I face.

 

[ak]

Please help me. I need to know how can I get each record in my list
numberwise, line by line. There are multiple invoices. How can I arrange
this per invoice?

 

[Evi]

See if this does it. Put a text box in the section where you want the
numbers to go. type
=1
next to Control Source in the Properties box
In the Properties box, choose Over Group next to Running Sum.
If that isn't what you require, try 'Over All'
Evi

 

[ak]

Dear experts,
I have done my targeted work in probable success. Let me mention my report
as it is. I believe you will get an idea about what I mean really.
I got report as below. Instead of repeating LINE_NO of next invoice I
need only invoice by invoice. For example for INV_NO.1 LINE_NO are 1
and 2.
Other 1,2,3 and 4 are for 2nd Invoice. What to do to get this? Would
appreciate your
greate favor.
If you want I will forward to you my report design. Please inform.

INV_NO : 1
DATE : 10/2/08
TO : XXXXXX

LINE_NO DESCRIPTION PRICE

1 PEN $2.00
2 PENCIL $5.00


1 CUTTER $2.00
2 RUBBER $6.00
3 STAPLER $9.00
4 clip $4.00

 

[Evi]

If this is a simple report (and not a report with a subreport) then follow
the instructions I gave for creating a Running Sum control and choose Over
Group next to the Running Sum property. That will give you the line numbers

Ensure that your report is grouped by eg Invoice number and choose Force New
Page After Section in Properites while you are clicked on the InvoiceNumber
Footer.
Evi

 

[ak]

This is a report with a subreport because in table1 fields are :
INV_NO
DATE
TO
In table2
fields are :
LINE_NO
DESCRIPTION
PRICE
I need your instruction based on the above method.

 

[ak]

I need such a way which is northwind invoice arranged. Per invoice
corresponding line numbers.

 

[Evi]

The Northwind Invoice doesn't have a subreport. Where that invoice has
ProductID, that is where you can put the running sum control as described.
Make a copy of the Northwind Invoice and try it out.
Evi

 

[ak]

How can I total price in each invoice? Please comment.

 

[Evi]

Put a textbox into the Invoice footer and type into it

=Sum([Price])

Evi