Page setup for sub-reports

[GraeagleBill]

I have a report that has a page setup of two columns that works just fine. I've recently added a sub-report that has a page setup of four (4) columns. When the report previews, the page setup of 4 columns of the sub-report are ignored. I.e., the sub-report previews as a single column. The parent's detail section continues to display properly with 2 columns. The sub-report previews with 4 columns when previewed independently. The sub-report is located in the parent report's "Report Header Section".

How do I get the sub-report's column specification to take effect when subordinate to the parent?



Thanks,
Bill Stanton

[June7]

Google: Access multi-column subreport
Review
http://support.microsoft.com/kb/208364
http://support.microsoft.com/kb/155077

[GraeagleBill]

"Across then down" in fact yields 4 columns of data in the sub-report, but that arrangement will not satisfy the needs of the application. I will pursue an alternate approach.

Thanks,
Bill

[June7]

The only alternative I can see is to rearrange the data by queries or writing to a temp table. Review http://forums.aspfree.com/microsoft-...ry-322123.html

[GraeagleBill]

June7,

Thanks for your thoughts.

The application involves a roughly 20 page directory with 10 profiles per page. My task is to produce a pdf that has a single page of names "down then across" as the first page of the pdf followed by another set of pages containing thumbnail images corresponding to profiles in the main body of the directory. Once the pdf file is established, Acrobat will be used to manually link the name list to the page where the individual will be found AND similarly with the images. With that, the end user of the directory can find an individual's profile by either knowing their name or as shown in an image.

Since from the host application reports are initiated from VBA code, I just need to learn the parameters that will save the report directly into a pdf and create 3 separate pdf files into a "controlled" folder followed by a shell to Acrobat where combining the 3 files into a single pdf is really fairly straight forward. While I could probably create a temp table to deal with the "names page", the image page(s) would be more effort than the occasional directory creation warrants.

Thanks,
Bill

[June7]

If you get that far, for PDF output and merge review:
https://www.accessforums.net/import-...ges-25042.html
https://www.accessforums.net/access/...pdf-25574.html

[GraeagleBill]

I've already bumped my head with:

DoCmd.OutputTo acOutputReport, "", acFormatPDF

as Access 2003 does not support the acFormatPDF option. (While the app runs in a 2010 environment, the app is still compiled in 2003 because 2010 does not support popup menus and I haven't had the time to convert that functionality to ribbons.)

[June7]

Sorry, been a long time since I used 2003 and my code was developed with 2007.

Does 2003 even have a print or export to PDF functionality?

Possibly if you have a virtual PDF printer driver and can open report and select that driver as destination printer, you will be able to produce PDF.

As for the other code, need a VBA reference to Adobe Acrobat 8.0 Type Library. If that is not in 2003, then that code won't work either.