Access Report

clock1
clock1 used Ask the Experts™
on
I have a report produced from Tables in Access that I want to take out of Access to do more formatting for publication.  I know that I can export to Word, Excel, PowerPoint, PDF.  However, these applications don't have the high-end formatting capabilities that I need (although Word comes closest with its ability to create indexes).

Does someone know of a publishing tool that works really well with Access reports?  Years ago I worked with Adobe FrameMaker with some success.  Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Bill RossProgrammer

Commented:
Hi,

Send to PDF and use Adobe Acrobat.  We do that and can make documents look as needed for professional presentations, binders, etc.  Added ability to create PDF books, etc. and easy to email or set up for download.

In my opinion it's worth the $.

Regards,

Bill
Most Valuable Expert 2012
Top Expert 2014

Commented:
Generally speaking, if you need something other than the formatting capabilities of Access you're better off with one of the more high-powered reporting engines, like Crystal Reports. CR (and most other enterprise-type reporting apps) can get data directly from Access, and you can then create the reports you need. I've worked in Crystal quite a bit in the last few years, and it is quite full-featured.

There are plenty of other reporting platforms as well, depending on how much time and money you want to invest.

Author

Commented:
I've worked with CR before and it works great for what you described.  My experience is nothing beats Access reports when it comes to data residing in Access. I need to locate a product/tool that will enable me to format, edit, and prepare the report for publication. Think I'm leaning more toward a publishing tool.

Author

Commented:
Can you tell me more about using Acrobat to create PDF books?  Or, refer me to a URL? Thanks!
Programmer
Commented:
Hi,

There are loads of examples on the Adobe sire.  Check out:

http://forums.adobe.com/thread/1034789 for specifics.

Try http://www.adobe.com for general overview.

Regards,

Bill

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial