ASP.Net - MVC C#| Report : Microsoft Reporting
- Implement RDLC in MVC
Here, I have demonstrate, how to implement Microsoft reporting in MVC web application. Please follow below steps to achieve reporting.
Step1 : Create web application with blank and select code reference "MVC". I have created project name with "DemoReport".
Step 2: Add empty controller name what you want. I have create "Home" and "Country".
Step 3: Add Entity Data Model follow screenshots.
Step 4: Add below code in Index action of Country controller
public ActionResult Index()
{
List<Country> countryList = null;
using (DemoReportEntities db = new DemoReportEntities())
{
countryList = db.Countries.OrderBy(o=>o.CountryName).Take(10).ToList();
}
return View(countryList);
}
fda
Step 5: Add below html code in Index view of Country
@model IEnumerable<DemoReport.Models.Country>
@{
ViewBag.Title = "Country";
}
<div class="box">
<div class="box-header with-border">
<h3 class="box-title">Country List</h3>
</div>
<div class="row">
<div class="col-md-6">
<div class="box-body">
<table class="table table-bordered">
<tbody>
<tr>
<th>Country Name</th>
<th>Country Code</th>
</tr>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(m => item.CountryName)</td>
<td>
@Html.DisplayFor(m => item.CountryCode)
</td>
</tr>
}
</tbody>
</table>
</div>
</div>
<div class="col-md-6">
<div><a href="@Url.Action("GenerateReport",new {id= "PDF"})" class="btn btn-primary btn-Report"> Get Report PDF</a></div>
<div><a href="@Url.Action("GenerateReport",new {id= "Excel"})" class="btn btn-primary btn-Report"> Get Report Excel</a></div>
<div><a href="@Url.Action("GenerateReport",new {id= "Word"})" class="btn btn-primary btn-Report"> Get Report Word</a></div>
<div><a href="@Url.Action("GenerateReport",new {id= "Image"})" class="btn btn-primary btn-Report"> Get Report Image</a></div>
</div>
</div>
</div>
Step 6: Add css class in site.css or your stylesheet.
.btn.btn-primary.btn-Report {width:150px !important; margin:3px}
Step 7: Add below html code in _Layout.cshtml for menu option
<div class="navbar-collapse collapse">
<ul class="nav navbar-nav">
<li>
@Html.ActionLink("Country List", "Index", "Country", new { area = "" }, new { @class = "navbar-brand" })
</li>
</ul>
</div>
Step 8: Run application and it will give output as below,
Step 9: Add new folder in project for report, I added "Reports", then follow below steps
Step 10: Add new folder in project for report data sets, I added "ReportDataSet", then follow below steps
Step 11: Add data set to Report,
Step 12: Add header and footer in report
Step 13: Add report assembly reference in project.
Step 14: Lastly write code to generate report file in pdf, word, excel or image. create new action method in country controller and write below code.
public ActionResult GenerateReport(string id)
{
List<Country> data = null;
using (DemoReportEntities db = new DemoReportEntities()){
data = db.Countries.OrderBy(o => o.CountryName).Take(10).ToList();
}
LocalReport lr = new LocalReport();
string path = Path.Combine(Server.MapPath("~/Reports"), "CountryReport.rdlc");
if (System.IO.File.Exists(path)){
lr.ReportPath = path;
}
else{
return View("Index", data);
}
ReportDataSource rd = new ReportDataSource("ReportCountryDataSet", data);
lr.DataSources.Add(rd);
string reportType = id;
string mimeType, encoding, fileNameExtension;
string deviceInfo = "<DeviceInfo> <OutputFormat>" + id + "</OutputFormat>" +
" <PageWidth>8.5in</PageWidth> <PageHeight>11in</PageHeight>" +
" <MarginTop>0.5in</MarginTop> <MarginLeft>1in</MarginLeft>" +
" <MarginRight>1in</MarginRight> <MarginBottom>0.5in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streams;
byte[] renderedBytes;
renderedBytes = lr.Render( reportType, deviceInfo, out mimeType, out encoding,
out fileNameExtension, out streams, out warnings);
return File(renderedBytes, mimeType);
}
Step 15: Finally run the project and click on Generate Report button. See generated pdf.
