Founder / Director / Co-founder at easyBacklog / Aqueduct / Econsultancy
14 October 2002 10:30am
I am currently trying to create a directory like listing of data from a SQL database, and have had problems finding a tool that can do the job effectively.
I am currently using Access to create an Access Report Snapshot file, which I print to PDF and then edit manually to add the cover pages, and index etc. This is extremely tedious and I am sure is not the best way of doing it. If I try to export the Access Report to RTF format, the formatting is lost and the RTF document is almost unusable. Strange that Access does not export to a richer format such as Word.
Other options I have thought of are creating a VBA app within Word to import the data from the SQL database, and create the document on the fly. Although this is feasible, I imagine it will be a lot of work considering Access reports hide a lot of the formatting and sizing issues that one would normally have to manually deal with. On top of this, we are using 2 columns per page which would further complicate things in MS Word.
Does anyone have any ideas of other tools which can create Access Report like documents, which are editable in Microsoft Word or similar tool. Acrobat is not really ideal for editing documents. Has anyone used Crystal Reports, what is the export to Word document like, would formatting and graphical elements such as lines be maintained after exporting?
Architect/Developer at Freelance
14 October 2002 13:15pm
Even though I realise that Acrobat is a little limiting, I've found ActivePDF (http://www.activepdf.com) to be a *really* useful tool for reports.
It's a COM(& .Net) object which allows you to manipulate pdfs by appending/removing pages, pasting images, substituting text and other such things.
I recently used it for a dynamic presentation project, where the entire site was converted to separate pdf "chapters" based on the sitemap, which enabled a customisable cut-down version of the site to be printed and given to clients.
The other bonus is that the files are a whole lot smaller than word documents. (A 10Mb word document is often ~600k as a pdf)
Hope that helps,
Free market research on digital marketing
Daily Pulse: award winning newsletter
It takes 30 seconds to register