CODEWITHSUNDEEP
sql-server-2014-expressssrs-2014
Inna Kleinerman
Inna Kleinerman

Reputation: 1

How to launch SSRS report on demand

We have an application that is inserting data to the SQL Server data base. I have to create a report based on the data from this SQL Server data base.The report should be generated on a demand (by a user click from the application) as a HTML file and saved in a specific folder on a PC.

I think the best way is to use SSRS, but I'm not so familiar with it. I've created a report using Report Builder tool.

How can I create the report on demand each time the user requires it?

Upvotes: 0

Views: 444

Answers (1)

vS12
vS12

Reputation: 310

You need to have a back-end running on C# to consume SSRS web service. Along with this you will also need to have a .rdl file (template/design) for representing that sql-data.

On click of the button/link you can have a server call to generate that report for you.

Refer : https://learn.microsoft.com/en-us/sql/tutorials/access-report-server-web-service-vb-vcsharp-ssrs-tutorial?view=sql-server-2014

and https://www.codeproject.com/Articles/1110411/How-to-Write-a-Csharp-Wrapper-Class-for-the-SSRS-R

Upvotes: 0

Related Questions