report from many queries

[nitr0]

Dear all,

i am facing problem and i dont know how to solve it or i dont know if it is possible to make it in access. Problem is

1, i have one table with around 50 columns
for this moment are important this: customer_id, customer name, id_invoice, and some number..

2, in table there are many customer names /and IDs/, one customer can have one or more invoice_ids

i want to make separate report for each invoice_id and save it like pdf or something, there are thousands of invoice_ids so i cannot do query for each of them..(should autogenerate according column id_invoice)

there will be also many more calculations and so on, but i think i will be able to make it yourself

it is possible please? thanks in advance

 

[boblarson]

You don't need to make a separate report for each invoice_id. You create ONE report and then you Open the report by passing the invoice_id. See my sample here on how to create a generic report and then open it using different ways to get essentially different reports.
http://downloads.btabdevelopment.com/Samples/reports/Sample-GenericReport.zip
As for generating each of them, it isn't too hard to do with using a recordset to get each invoice_id and then use the method I show in my sample to output the report to PDF and then move to the next invoice_id to generate the next one.

 

[John Big Booty]

Welcome to the forum

...

1, i have one table with around 50 columns
for this moment are important this: customer_id, customer name, id_invoice, and some number..

...

Yowsers, there would seem to be a problem right there You might want to read up on the subject of Data Normalisation and possibly work through a tutorial on the subject.

Having done that you will probably want to redesign your table structure, and from there you will most likely find you task a whole lot easier.

 

[boblarson]

Welcome to the forum



Yowsers, there would seem to be a problem right there You might want to read up on the subject of Data Normalisation and possibly work through a tutorial on the subject.

Having done that you will probably want to redesign your table structure, and from there you will most likely find you task a whole lot easier.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
And some very good points there to take notice of.

 

[nitr0]

thank you for quick answers, i will try to do it in that way..if something i will write again, which will probably happen

thanks again

 

[nitr0]

Hi,

i tried to create something for one invoice, but i dont know how to make it for all really.
I did it in this way

1, I clean up my database according to your advice (now there is round 10 columns instead of 50)
2, need to have 3 selection for one invoice, so i made query for each of them..where invoice_id is typed in criteria
3, from every query i made report, total 3 reports and include it to subreport

i am able to make it like this in criteria will ask for ID, or i will choose it from dropdown menu, but i want something like this:

to make some "foreach" button which will make this:
1, select all unique IDs from Invoice_ID (because it is not unique, 1 item have id which tell that is on same invoice with other items have same id)
2, run query with criteria = I+ (i = 1st ID), and make report

or make 1 report as you told but, each new invoice should be on new page (if 1st invoice will have 1 and half page, 2nd invoice start on page 3)

i dont know if you understand me what i am thinking.. i attach database with "sample data" - not real but it represent what i need, and also picture

any others advice for me pls?

 

[boblarson]

Okay, here's your sample back with some modifications.

1. I changed your queries to include the Invoice_ID.
2. I changed your main report to use a query of invoice_ID's for its record source and then linked each subreport by Invoice_ID on their Master/Child links properties.
3. I then added a form to run the invoices - either all or individual ones.

Check it out and ask questions.

 

[nitr0]

this is what i am talking about..thank you

and question is : main report to use a query of invoice_ID's for its record source?

what this do and why i need to create this? this one i dont understand how its work..i know where and how you do this but i dont know why, and when i will do this in future.. thank you again