InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 10:31:54 GMT20http://www.sqlservercentral.com/Forums/Topic1407621-391-1.aspxFollow the blog in servercentral [url]http://www.sqlservercentral.com/articles/Miscellaneous/creatingapdffromastoredprocedure/1104/[/url]Also another useful link[url]http://www.codeproject.com/Articles/19236/Create-data-driven-PDF-on-the-fly-by-using-SQL-ser[/url]Thu, 17 Jan 2013 23:31:17 GMTitsmemegamindhttp://www.sqlservercentral.com/Forums/Topic1407621-391-1.aspxYou'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.Thu, 17 Jan 2013 13:14:02 GMTShineBoyhttp://www.sqlservercentral.com/Forums/Topic1407621-391-1.aspxHi, we use ASPPdf from persits for this and it has worked very well. Rather than clr we use OA procedures.Asppdf.comRegardsThu, 17 Jan 2013 06:12:57 GMTderek.gileshttp://www.sqlservercentral.com/Forums/Topic1407621-391-1.aspx[quote][b]ShineBoy (1/16/2013)[/b][hr]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.[/quote]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.Wed, 16 Jan 2013 03:23:51 GMTdemonfoxhttp://www.sqlservercentral.com/Forums/Topic1407621-391-1.aspxI'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.Wed, 16 Jan 2013 02:46:33 GMTShineBoyhttp://www.sqlservercentral.com/Forums/Topic1407621-391-1.aspxYou 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.Wed, 16 Jan 2013 01:00:06 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1407621-391-1.aspxi 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?Tue, 15 Jan 2013 23:25:01 GMTsarthakmajithia