Problems with reports (Invoice)

  • Thread starter Thread starter MarioCirillo via AccessMonster.com
  • Start date Start date
M

MarioCirillo via AccessMonster.com

Hello all,

Im having a big problem with reports in access, ive created a system which
will generate invoices for customers. I have finalised the template of my
invoices which will be displayed as a report. When i view a report with one
set it works fine but as soon as it generates one or two invoices lets say
for the same customer things start to get interesting. Rather than placeing
one report per page the system merges all the invoices into one which is not
what im looking for. Ive tried to get around this but have not had much luck.

I was wondering if anyone could be so kind as to lend me a hand as this is
driving me mad now. I have attached the file to make things easier to explain
where the problem is occuring.
FILE: www[DOT]cirillowebdesign[DOT][COM]/file.zip
PASSWORD TO DATABASE: microsoft94

open reports, Each invoice should look like this one
[Open report INVOICE and enter invoice number 10 as criteria]

This is how the invoices should look, when i load a quiery into this template
that has more than one result for example when u search invoices by date i
want each one to load on an individual page but it merges all of the data
together and i cant seem to get round this.

[open INVOICEBYDATE and enter 13/02/05]
As you can see it mundles up all of the data, ive looked at the sample
databases in access and have tried many things but cannot seem to get round
this?

Any help would be greatly appriciated!
Thank you

Mario Cirillo
 
MarioCirillo said:
Im having a big problem with reports in access, ive created a system which
will generate invoices for customers. I have finalised the template of my
invoices which will be displayed as a report. When i view a report with one
set it works fine but as soon as it generates one or two invoices lets say
for the same customer things start to get interesting. Rather than placeing
one report per page the system merges all the invoices into one which is not
what im looking for. Ive tried to get around this but have not had much luck.

I was wondering if anyone could be so kind as to lend me a hand as this is
driving me mad now. I have attached the file to make things easier to explain
where the problem is occuring.
FILE: www[DOT]cirillowebdesign[DOT][COM]/file.zip
PASSWORD TO DATABASE: microsoft94

open reports, Each invoice should look like this one
[Open report INVOICE and enter invoice number 10 as criteria]

This is how the invoices should look, when i load a quiery into this template
that has more than one result for example when u search invoices by date i
want each one to load on an individual page but it merges all of the data
together and i cant seem to get round this.

[open INVOICEBYDATE and enter 13/02/05]
As you can see it mundles up all of the data, ive looked at the sample
databases in access and have tried many things but cannot seem to get round
this?
Click to expand...


Sorry Mario, my newsreader discards most attachments. I
would not open a file that I had not previously negotiated
for anyway. Besides attachments are not acceptable behavior
in newsgroups unless their name ends with "binaries".


With the protocol stuuf out of the way, I think you need to
use Sorting and Grouping to create a group (with header) on
the invoice number field. Move the stuff you put in the
report header section to the group header and if you had
anything in the report footer, move that stuff to the group
footer. To get each invoice to start on a new page, set the
group header section's ForceNewPage property to Before
Section.
 
Back
Top