write C# code to create pdf files from SSRS reports; what is best practice; write console application and etc

Question

I would like to write C# console or some project type from Visual Studio that will create PDF files on our network from SSRS Reports; It needs to be part of a job or task that runs every night; What is the best Visual Studio project to use? What is the library I can use to tap into the SSRS Reports with passing parameters from a table?

Answer 1

Hi @Joseph Kashishian

Sorry I'm not very familiar with C#, I'm in charge of SSRS related issues.

Do you mean want to export SSRS report as Pdf file as per schedule? If it's a single file, you can use file sharing to deliver it.

https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/file-share-delivery-in-reporting-services?view=sql-server-ver16

If you want to use C#, you can refer to this link: https://social.msdn.microsoft.com/Forums/en-US/fb61c11b-f873-4924-9ef4-dbb694fed580/how-to-export-the-ssrs-reportxls-or-xlsx-format-at-given-physical-location-through-c-code?forum=sqlreportingservices.

Best regards,

Aniya

Answer 2

trying to SSRS report as Pdf file but trying to do it thru asp.core console application.

After I connect to the WEB Services ReportServer/reportexecution2005.asmx

I'm having issues getting libraries or namespaces to work with the code. in the console application I want to read 2 parameters and go thru a loop on a table with to read parameters, execute the ssrs report and export to pdf. I did this years ago but I think the libraries have changed