Generating PDF

Hi.

I have task to create a data report in my program, which will contain the results of a SQL query.
But which is important is this report must be saved in .pdf file. I don't know how to generate
this type of files.
As long as I know one way is to pass the data to the Acrobat PDFWriter driver.
Before I start, I want to know is there any other way(An ActiveX component, library, etc.) I can
try?

And if there are some examples I can read about it.

http://en.wikipedia.org/wiki/Ghostscript
Part of this contains a library (or two) for manipulating PDF files.