Generate .pdf from SQL Server

smart+ · Post by **smart+** » Tue Dec 21, 2010 6:35 am

Hello,

does exist way for generating .pdf files from SQL Server stored procedure or Job?
If yes, where I can see some sample?

Or I must use external application for this?

Best regards,
Sasa

Post by **Alex K.** » Tue Dec 21, 2010 7:36 am

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.

smart+ · Post by **smart+** » Tue Dec 21, 2010 2:42 pm

I must generate 150 .pdf reports each 2 hours from our ASP.NET application.
We use your Stimulsoft.Report component for ASP.NET.

My database is SQL Server and I can use SQL Server Agent for creating and scheduling Job for this interval of 2 hour.
In this scheduling Job I want execute stored procedure which generate 150 PDF reports with your component.

Does exist any way for doing this with stored procedure?

JorisWils · Post by **JorisWils** » Wed Dec 22, 2010 4:36 am

Maybe you could create a .NET Console app which takes a few parameters and generates the report?

Then you could call the executable from within your stored procedure.

smart+ · Post by **smart+** » Wed Dec 22, 2010 6:55 am

JorisWils wrote:Maybe you could create a .NET Console app which takes a few parameters and generates the report?

Then you could call the executable from within your stored procedure.

I know for this solution and this is my backup solution if not exist simpler or better solution.

Second solution is creating SSIS package which call my web service which generate PDF reports.
For this package I can create Job in SQL Server and make scheduling.

I only ask if Stimul.Report have some other simpler solution?

Post by **Andrew** » Wed Dec 22, 2010 7:14 am

Hello,

The solution offered by JorisWils is the good one because we do not have import from PDF.

Thank you.

smart+ · Post by **smart+** » Wed Dec 22, 2010 7:42 am

Andrew wrote:Hello,

The solution offered by JorisWils is the good one because we do not have import from PDF.

Thank you.

I use Stimulsoft.Report for web and with JorisWils solution how can I generate PDF in console application?

Post by **Alex K.** » Thu Dec 23, 2010 7:10 am

Hello,

You can create a simple console application that will connect to the database, execute the procedure, send the data to the report template, render them (without showing) and then export to a PDF file with the specified name and the specified path.
As another way you can implement these actions in your application.

Thank you.