Convert SQL data to PDF

DireEmblem

DireEmblem

DireEmblem

Associate
Joined
25 Aug 2008
Posts
947
Does anyone know any good sites that help give examples of code to do this?

In SQL, i will contain a list of pre-defined images I want placed in set positions, and text, again in set positions etc etc...

There must be a means in SQL to pull data from the table, referencing everything i want on my PDF document, and then on the call put something like template #1 or #2, and from that it would know how to order the data?

Much appreciated.
 
If I was doing this myself, I'd probably use something like VB and crystal reports to generate the page, and then "print" it to PDF using one of the free utilities out there - e.g. cutePDF. Probably not the most efficient way of doing it, but the simplest I can think of off the top of my head :)
 
There is no direct route from SQL to PDF. You'll need to use some intermediary software, either existing like Crystal Reports or something you can write from scratch to meet your exact requirements.
 
Hi,
I have a fast reports component and I did a basic test form that can connect to a database and output to lots of formats including PDF. If you would like a copy I could upload it somewhere for you.

It’s quite a good reporting tool.
 
Last edited:
Spunkey said:
There is no direct route from SQL to PDF. You'll need to use some intermediary software, either existing like Crystal Reports or something you can write from scratch to meet your exact requirements.
Click to expand...

I need it to run from a site when a user requests basically, so thinking if i can find something in php or some kind of script... sofar i've found this which for first instance appears to do what I need, I just need to script up a sample template to test it proper.
 
I've used FPDF for a couple of projects at work - does the job quite well and fairly easy to put together - as you say you've got all the images, dimensions and positions, I had a nice looking PDF thrown together within half an hour.
 
You must log in or register to reply here.
Back
Top Bottom