October 5, 2016 at 7:54 am
Hello, I have a potentially dumb question ...but there are no dumb questions right?!?
I have only ever used reporting services with the report viewer that comes with SQL Server. How do you get the reports onto a website without the report viewer?
October 5, 2016 at 8:27 am
Part of the SSRS setup is configuring a Report Server URL. This is something you can also do after SSRS is set up. The Report Server URL is where you deploy your reports. Then, in Visual studio, you specify the URL where your reports are deployed in the project. The URL is usually something like https://<my server>/ReportServer/MyReports. People with rights to those reports can view them using their browser when they're on the same network, and view them via a browser over a VPN otherwise.
-- Itzik Ben-Gan 2001
October 5, 2016 at 8:30 am
amy26 (10/5/2016)
Hello, I have a potentially dumb question ...but there are no dumb questions right?!?I have only ever used reporting services with the report viewer that comes with SQL Server. How do you get the reports onto a website without the report viewer?
When you install SSRS, you have all the pieces you need installed, including the report viewer. If you are using SSRS 2008 and above (hopefully) and running in native mode, there is no dependence on IIS or much to do with configuration of any website pieces really. You're just configuring SSRS for the security, reports, data sources, etc. and the basic initial configuration of SSRS.
If you had a website outside of SSRS where you wanted to render reports using the report viewer, you can download the Report Viewer runtime separately.
Sue
October 5, 2016 at 8:33 am
But the report viewer is only available "intranet" its not available on the internet... our website is public facing. The database server is not accessible from the outside. I want to just be able to see a graphical report like in the middle of one of our web pages...
What's the point of reporting services if its so limited in functionality that you can only use the report viewer internally?
October 5, 2016 at 9:05 am
amy26 (10/5/2016)
But the report viewer is only available "intranet" its not available on the internet... our website is public facing. The database server is not accessible from the outside. I want to just be able to see a graphical report like in the middle of one of our web pages...What's the point of reporting services if its so limited in functionality that you can only use the report viewer internally?
If you want to make a graphical report available on a public facing web site you could publish the SSRS report internally, then make the report accessible to a public facing website. The database does not need to be accessible from the outside, just accessible to SSRS reports that you want to make public.
I'm a data guy, not a web guy so I can't give specifics on how you do this but I have worked on projects where we had a public facing SharePoint-based website and made SSRS reports available to the public via SharePoint web part.
-- Itzik Ben-Gan 2001
October 5, 2016 at 9:30 am
Heh, yea I'm also not a web person.... 😀 So, I need to figure out how to do all that. I have configured reporting services before and built reports and stuff but it was all stuff that only had to be available internally. I never had to figure out how to do it for external use. 🙁
October 5, 2016 at 9:34 am
amy26 (10/5/2016)
But the report viewer is only available "intranet" its not available on the internet
That would be incorrect. It's not an intranet only control.
What's the point of reporting services if its so limited in functionality that you can only use the report viewer internally?
That's not how it works. In addition, there are methods other than just the Report viewer control. That control is just a small piece from Visual Studio that is used by Reporting Services. What have you tried?
Sue
October 5, 2016 at 9:43 am
To display reports on a front end page for external users you want the Microsoft.ReportViewer.WebForms Assembly in your web project.
This is something I did with our Web Team maybe 2 and a half years ago, so I'm about as rusty on it Alan.B is on how we got it working. We can simply then add a report onto a page using html similar to the below.
<rsweb:ReportViewer BackColor="#ffffff" ID="ReportViewer2" BorderWidth="1" BorderColor="black" runat="server" Height="150px"
ProcessingMode="Remote" Width="300px" ShowDocumentMapButton="False"
ShowExportControls="False" ShowFindControls="False" ShowBackButton="false"
ShowPageNavigationControls="False" ShowPrintButton="False"
ShowPromptAreaButton="False" ShowRefreshButton="False"
ShowZoomControl="False" AsyncRendering="False" InternalBorderStyle="None"
SizeToReportContent="True">
<ServerReport ReportServerUrl="http://SSRSServer/ReportServer"
ReportPath="/ReportFolder/reportName" />
</rsweb:ReportViewer>
Someopne else might be able to help you on how in install and get the assembly working on your ISS Web Server.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 5, 2016 at 10:13 am
Sue_H (10/5/2016)
amy26 (10/5/2016)
But the report viewer is only available "intranet" its not available on the internetThat would be incorrect. It's not an intranet only control.
What's the point of reporting services if its so limited in functionality that you can only use the report viewer internally?
That's not how it works. In addition, there are methods other than just the Report viewer control. That control is just a small piece from Visual Studio that is used by Reporting Services. What have you tried?
Sue
How is it not correct though? I cannot access the report manager or the report viewer from outside the network.
I haven't tried anything yet as I dunno where to start. 🙂 I haven't used reporting services in many years and I really want to introduce it to my current project, but if its going to be a pain in the butt to set up, I don't want to recommend it cause we need this report relatively quickly.
October 5, 2016 at 10:15 am
Thom A (10/5/2016)
To display reports on a front end page for external users you want the Microsoft.ReportViewer.WebForms Assembly in your web project.This is something I did with our Web Team maybe 2 and a half years ago, so I'm about as rusty on it Alan.B is on how we got it working. We can simply then add a report onto a page using html similar to the below.
<rsweb:ReportViewer BackColor="#ffffff" ID="ReportViewer2" BorderWidth="1" BorderColor="black" runat="server" Height="150px"ProcessingMode="Remote" Width="300px" ShowDocumentMapButton="False"
ShowExportControls="False" ShowFindControls="False" ShowBackButton="false"
ShowPageNavigationControls="False" ShowPrintButton="False"
ShowPromptAreaButton="False" ShowRefreshButton="False"
ShowZoomControl="False" AsyncRendering="False" InternalBorderStyle="None"
SizeToReportContent="True">
<ServerReport ReportServerUrl="http://SSRSServer/ReportServer"
ReportPath="/ReportFolder/reportName" />
</rsweb:ReportViewer>
Someopne else might be able to help you on how in install and get the assembly working on your ISS Web Server.
Ok that makes sense... perhaps I can google it.
October 5, 2016 at 3:01 pm
You can use the report viewer control in two ways - Remote which renders a report hosted on reporting services and local which renders an RDLC file locally - in this case SSRS is not required.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply