GPSPOW
asked on
Using Visual Studio to create a PDF from SQL data and output to a shared drive
I have been using MS Access and a Pass Through Query for a long time to generate a distributable PDF every morning. However, this methodology is not stable and this past weekend the server running the program crashed and I cannot get it to work.
I have been playing around with Visual Studio to create the PDF report from the SQL data set. I have been able to create the Visual Studio report but not having access to a SQL Report directory I am at a loss on how to run my creation daily and save the output as a PDF to a shared folder that the application has privileges to.
I have been searching the internet for a solution but cannot find a straight forward answer.
Any help will be appreciated.
Thank you
Glen
I have been playing around with Visual Studio to create the PDF report from the SQL data set. I have been able to create the Visual Studio report but not having access to a SQL Report directory I am at a loss on how to run my creation daily and save the output as a PDF to a shared folder that the application has privileges to.
I have been searching the internet for a solution but cannot find a straight forward answer.
Any help will be appreciated.
Thank you
Glen
1 - Your Visual Studio project now able to create the PDF report
2 - You mention "SQL Report directory"... does this mean you are using SQL Server Reporting Services to create the PDF?
3 - Is it an option to just use SSRS for the delivery of the reports (https://docs.microsoft.com/en-us/sql/reporting-services/subscriptions/e-mail-delivery-in-reporting-services)
2 - You mention "SQL Report directory"... does this mean you are using SQL Server Reporting Services to create the PDF?
3 - Is it an option to just use SSRS for the delivery of the reports (https://docs.microsoft.com/en-us/sql/reporting-services/subscriptions/e-mail-delivery-in-reporting-services)
ASKER
I do not have any access to save reports on the SQL server. My access is limited to creating tables and stored procedures. I can email via an SMTP connection from the SQL server.
The server that houses the SQL server does not have a Microsoft Office suite. It does have a Visual Studio 2008 application that I can use. I am using the SQL database as a dataset and I have created the RDL. I want to be able to produce the RDL report and save it as a PDF to a specified path "//pcmfs/groups/Accounting /Test.pdf" .
How is this done?
Thank you
Glen
The server that houses the SQL server does not have a Microsoft Office suite. It does have a Visual Studio 2008 application that I can use. I am using the SQL database as a dataset and I have created the RDL. I want to be able to produce the RDL report and save it as a PDF to a specified path "//pcmfs/groups/Accounting
How is this done?
Thank you
Glen
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the tutorial. I have been able to follow it along in my VS sandbox on my laptop.
What directory? when you create a report in Visual Studio, it's part of the application. The application runs, generates the report, saves it as PDF file wherever you want.