All geek questions in one place

Display SQL Server Report over the Internet

I read tons of different articles, but for some reason I could not get a direct answer to my question.

Q: In a SQL Server report, is it possible to display reports to users over the Internet without embedding them in an application using the ReportViewer control? (I know that I can use ReportViewer Control, its quite amazing and its definitely an option, I got it working fine).

This part is fuzzy for me, in my opinion, I want to give the user the web address of the report, they register with the username and password, and then view their reports.

Is it possible? Every time I read something related to this, they talk about intranets, not the Internet.

Any input would be appreciated.

+4
source share
2 answers

Yes,

Reporting Services installs a site in IIS, which, if configured correctly, can be viewed over the Internet. This is called a report manager. It has built-in roles to restrict user access only if necessary.

http://msdn.microsoft.com/en-us/library/ms157147.aspx

+1
source

I believe that this is what you are looking for, Pass parameters and parameters using a URL in SQL Reporting Services .

You can also force the application to invoke a report on behalf of the user and deliver a PDF file or other output. See the ReportExecutionService class and ReportExecutionService.Render Method .

+1
source

Source: https://habr.com/ru/post/1387655/

More articles:


All Articles