Recently I got a task of Displaying SSRS report in ASP.NET MVC application.
Initially I thought this might not be possible in MVC
application(Since web forms have ReportViewer control which is server side control
requiring view state and which is not possible in MVC) and I would have to do
some work around of mixing MVC and ASP.NET Web Forms pages to view report.
Later on I searched some more and found this solution. So
let us start with it.
I created a
BI solution and created a simple report(named EmpReport) as shown below.
I deployed
this solution to my local SSRS server. Now my requirement is to display this
deployed report in my MVC application.
I Created a MVC project(named Mvc_SSRS_Demo) where I would like to integrate this report.
We would install "MvcReportViewer" package from
NuGet.
To install it open 'Package Manager Console' from Visual Studio Tools --> Library Package
Manager --> Package Manager Console
and Run following command in 'Package Manager Console'
Install-Package MvcReportViewer
This will add packages for MvcReportViewer library and will
add some default configurations in web.config
We will have to update following entries in web.config
<add key="MvcReportViewer.AspxViewer" value="/MvcReportViewer.aspx" />
=> This points to aspx page which
is installed by NuGet package which will be used to display our report in
iframe. If you move this page to some other location or rename it then you will
have to update that change here.
<add key="MvcReportViewer.ReportServerUrl" value="http://naren-pc/Reportserver" />
=> This points to
SSRS server where our report is deployed. Change this value to point it to your
report server.
<add key="MvcReportViewer.Username" value="" />
<add key="MvcReportViewer.Password"
value="" />
=> Provide
credentials if required to connect to your report server.
Now to use
this Report Viewer in your view Reference it as follows
@using MvcReportViewer
Now use following
HTML helper method to load required report
@Html.MvcReportViewer(
"/MvcSSRS_Integration/EmpReport",
new { EmpID = 1 },
new { Height = 600,
Width = 600, style = "border:
none" })
This helper
method has following parameters
1. Relative
path of SSRS report on server
2. Required Parameters
for report execution
3. Styling
and other settings for report viewer
Now Run your application and navigate to this View and it
will render your SSRS report in your MVC application. Pretty cool :)
Hope this makes it clear and helps you.
