Access Reports Problem

[Cleis]

Hi All:

Need some help! I'm trying to combine 20 different reports into one report! These reports are business review summary reports that will run and print every month. I want to sequentialy number them and bundle them together into one report then e-mail them insteaad of printing 200 pages. I'm planning to dump the final report into an Adobe file and e-mail them off. So far, I've got the reports to sequentially number correctly. This can be done one of two ways.

First, was to open each report in sequence and reference an unbound feld with a contol setting set to =[Page]. The problem is I don't get one report to export but 20 different reports numbered correctly.

Second, is to nest one report into the previous report. Problem is that Access will only allow two nested reports! I've got 20 of them!!!!

I'm short on time here and what I thought that would be easy is NOT!

Does anybody got any ideas??? I could sure use them!!


Rich

Chicago

 

[ghubbell]

Any chance you could "tie" the reports together earlier i.e. in the queries that run them? If there is a relationship between one and another you may be able to handle the results differences in the sorting/grouping of one report its self. When that gets too "heavy" you could do the same with your max of 2 other subs...? Ideas? Gord
ghubbell@total.net

 

[Cleis]

Hmm! How will relating the queries help me to print reports together as one report? I'm not sure how that will help??? Can you further explain

Thanks

Rich

Chicago

 

[ghubbell]

If your report is say, Monthly sales, based on customer and order date, order number, and the order number and relate the order contents, and the order contents can relate to their usage history or stock levels or whatever.... Some times you'll build a query like this and look at it on its own and it's a duplicated mess. When you build a report with a wizard, you get offered options to sort and group with grouping options, summary options etc. Optionally if there is a relationship to the main report data that is common to all of your subs you could place many subs on the main. If you figure you have to put a sub in a sub in a sub then you could have probably done this in the query if the DB structure is good. I think the most I have ever had to do was two seperate subs on one main, but with about 3 or 4 grouping levels and summary options. We'll find a solution! Gord
ghubbell@total.net

 

[Cleis]

Thanks for your suggestion!!!! I've solved my problem! This is what I came up with. Time is short and I found the path of least resistance; I'm sure that you can relate! Adobe allows me to export each report into its own file then allows me to combine all reports into one file!!! The net effect is that I've combined all reports pages sequentially numbered and colliaded into one report! Thanx for your suggestions!

Have a great day!!!!!!!


Rich
Chicago

 

[7ony]

Try making ALL 20 reports sub-reports on 1 main report w/ the Main report doing the page numbering.
7ony