January 15, 2013 at 11:25 pm
i have a simple table with 3 columns and 3 rows.
is it possible to generate a pdf document by directly firing query in SQL which contains the table and its contents?
January 16, 2013 at 1:00 am
You can use Reporting Services (SSRS) for that.
Just build a very simple report using a table.
Output the report to pdf and you're done.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2013 at 2:46 am
I've made use of a CLR to do this, very fast, did pay about $US 300 for the DLL's but that paid for itself many times over. If you're keen on this I can dig around and get you more details. We use it to generate personalised legal contracts, at reasonable volumes. and never had a miss fire from the CLR so far, this process has been going about 5 months now, so seems quite reliable.
we're really just populating a contract that was composed in word and then really just converting/printing that to PDF.
Tell me if you are interested.
January 16, 2013 at 3:23 am
ShineBoy (1/16/2013)
I've made use of a CLR to do this, very fast, did pay about $US 300 for the DLL's but that paid for itself many times over. If you're keen on this I can dig around and get you more details. We use it to generate personalised legal contracts, at reasonable volumes. and never had a miss fire from the CLR so far, this process has been going about 5 months now, so seems quite reliable.we're really just populating a contract that was composed in word and then really just converting/printing that to PDF.
Tell me if you are interested.
For word to pdf convertors , there are plenty of tools available ; or write a C# code to do that , the code is also available on internet.
Well, I think SSRS approach is well and good enough for this work ...or if BI tools are not available then download the report editor tool , it is free and I think does have functionality of exporting reports in pdf's.
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
January 17, 2013 at 6:12 am
Hi, we use ASPPdf from persits for this and it has worked very well. Rather than clr we use OA procedures.
Asppdf.com
Regards
January 17, 2013 at 1:14 pm
You're right plenty of Word to PDF convertors around. But most require Word installed on the machine. We had a need whereby the Compliance Officer would be able to alter the source contract (or template) easily, that really meant Word. BUT as we are generating the PDF off the server we did not want to install Word on it. The solution we used meant no Word installed on the server, just access to the Word file. We chose a CLR simply because most of the process is in TSQL and ease I guess.
January 17, 2013 at 11:31 pm
Follow the blog in servercentral
http://www.sqlservercentral.com/articles/Miscellaneous/creatingapdffromastoredprocedure/1104/
Also another useful link
http://www.codeproject.com/Articles/19236/Create-data-driven-PDF-on-the-fly-by-using-SQL-ser
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply