Hello all,
My company has a procedure database. The procedures only apply to certain plants that we have. I've written a program to keep track of whcih procedures are attached to which plant. The program that we were using to do this previously was using the reporting feature of Access. We had to make the report, then save it as a PDF. For 15+ plants, this was time consuming. This is where my program came in. It was designed to handle all of this printing autmatically, but I don't have a way to make and export that report anymore.

I need to be able to make a report similar to Crystal Reports but export it in a PDF. I can code the report manually if need be, so that I don't have specific sections and divisions displaying data based on the database like Crystal Reports does, but rather I have a form like a Microsoft Word macro that I could write and would input the data into the software.

Anyone have any good suggestions for a good control or coding references?