Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

To Create PDF from SQL stored procedure Expand / Collapse
Author
Message
Posted Sunday, February 12, 2012 2:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 27, 2012 7:24 AM
Points: 1, Visits: 11
It is possible and works. The solution is not advanced, but stable. In our company, using SQL is generated thousands of pdf's. TSQL Procedure communicates with Webservice, who runs the Crystal Reports engine. As a result of such a solution we can achieve as a result of the SQL query the PDF document.
Post #1250951
Posted Sunday, February 12, 2012 2:50 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 32,923, Visits: 26,811
juratan (2/12/2012)
It is possible and works. The solution is not advanced, but stable. In our company, using SQL is generated thousands of pdf's. TSQL Procedure communicates with Webservice, who runs the Crystal Reports engine. As a result of such a solution we can achieve as a result of the SQL query the PDF document.


Heh... not if your Websevice is down or you can't get to the Crystal Reports engine. The OP was asking for a way to do it all from SQL Server.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1250959
Posted Friday, March 16, 2012 2:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 01, 2012 1:05 AM
Points: 1, Visits: 5
please may you me send stored procedure code,how generate a pdf in stored procedure , my mail id is pardeepbachhal89@gmail.com please help, n thanks in advance
Post #1268068
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse