In Access, How to Convert Multiple Reports to 1 PDF file?

[liimra]

?

Glad we achieved something. For saving all into one file,
How about creating one main unbound report with all the reports inside it as sub reports? This will work.

Regards,
Ali

[Otter7]

I will give it a try and reply back tomorrow....Tha nks for checking in and assisting!

[Otter7]

Unsuccessful, could not get the unbound report/subreports to work either...VBA must have some type of operator? to cause ongoing pagnation when saving multiple reports to the same pdf....I'll keep trying different variations of all that you submitted...any other coding you can think of? Thank you!

[Otter7]

How do I create an unbound main report with all the existing reports being the subreports plus when clicking on this report opens only 1 record from the If combobox = 0; MsgBox "No Audit has been selected"?

I am still trying to save 1 selected record after selecting through a combox listing, the 23 reports into 1 pdf file...

[liimra]

Solution/

Create one main report (make it your 1/23 report) and put all the other 22 reports inside it (so they become subreports). You have to note however, that unless you put each report in seperate section, you will get alittle mess with all reports above each others. To overcome this, create groups and set the expression value to =true for each one. For the msgbox, you can use the same as stated before "Is Null" or ="" although they are not exactly the same.

Last but not least make sure you link all the subreports to the main report through "ID".

Please report here if you have any problems and I will search tonight when I get back for a ready example over the net or create it.

Regards,
Ali

[liimra]

?

Did you get it working?

Regards,
Ali

[Otter7]

Thank you for responding...I was out of town on the weekend. I will follow your instructions today and respond wtih the results this afternoon.

[Otter7]

Still need your assitance...I seem to be missing something as the subreports are not showing as separate sections and not sure how to do a grouping with subreports...wo uld you mind posting a sample..or please post as a private message...Thank you!

[liimra]

//

Please find in the attached database the example I am talking about. Unfortunately the maximum number of groups is 10 so The main report has 10 reports. Of course you can add two reports to each group and then two reports in the form itself so you can reach 22 reports. Without any doubt there must be a way to add 23 reports but I will be traveling in the next two days so I won't be able to assist further. Anyways, here is how it works:

First you create report based on the table you are getting the records from, then you empty it (you just use it as source so you can create Master-Child Link for the subreports in order to filter). Next, you create groups (Group&Sort --> add group --> expression --> =true). Now you add report to each group (or two) and you are done.

Regards,
Ali

[Otter7]

Thank you for the sample...it helps to use a visual...I should be good from here...hope your travel is relaxing!

[Otter7]

Ali, I am still working on this and need assistance. Here is what I am trying to create as you stated - 1 report with groups with subreports totaling 23 reports with 1 record selection and forcing a page break each report:

main report
Group - subrpt 1; subrpt2
Group - subrpt 3, subrpt4
Group - subrpt 4; subrpt 5
etc. to last has 4 subrpts

This is advanced for me...step by step would be helpful, if you have some time....Thank you!