C# – Re-use business logic from MVC Application (DLL) in Reporting Services

asp.net-mvcbusiness-logicccode-reusereporting-services

I have a business object that compiles into a DLL that handles all calculations for my system for concepts such as eligibility, etc. The object also handles the connectivity to the DB via some wrappers around it.

Is there anyway to take this .NET DLL and use it as a datasource for a reporting services report (SSRS)? We don't want to have the logic in multiple places.

EDIT
What about exposing the functionality in a webservice in the web app itself and having the report connect to the web service? Anyone done this before? We are using asp.net MVC for our web app if that helps.

Best Answer

Your probably going to have to do this with the Report Viewer Control, as I have not ever seen an example using the reporting web service.

http://www.gotreportviewer.com/

Here is the section on using Object data sources:

http://www.gotreportviewer.com/objectdatasources/index.html

These can be conceptually similar to ViewModels in MVC, so you would have to build ReportViewModels™ to handle reporting requirements.

For MVC v5.1 use Html.EnumDropDownListFor

@Html.EnumDropDownListFor(
    x => x.YourEnumField,
    "Select My Type", 
    new { @class = "form-control" })

For MVC v5 use EnumHelper

@Html.DropDownList("MyType", 
   EnumHelper.GetSelectList(typeof(MyType)) , 
   "Select My Type", 
   new { @class = "form-control" })

For MVC 5 and lower

I rolled Rune's answer into an extension method:

namespace MyApp.Common
{
    public static class MyExtensions{
        public static SelectList ToSelectList<TEnum>(this TEnum enumObj)
            where TEnum : struct, IComparable, IFormattable, IConvertible
        {
            var values = from TEnum e in Enum.GetValues(typeof(TEnum))
                select new { Id = e, Name = e.ToString() };
            return new SelectList(values, "Id", "Name", enumObj);
        }
    }
}

This allows you to write:

ViewData["taskStatus"] = task.Status.ToSelectList();

by using MyApp.Common

R – What reporting tool do you suggest for an enterprise level ASP.Net MVC application

We use EasyQuery.NET (http://devtools.korzh.com/eq/dotnet) for ad-hoc reporting. EasyQuery is not a reporting solution but some kind of user-friendly query builder instead. For most cases it is enough: we just allow our users to query the data they want, then EasyQuery generates SQL, we execute it and show the result in some grid.

Best Answer

Related Solutions

C# – How to create a dropdownlist from an enum in ASP.NET MVC

For MVC v5.1 use Html.EnumDropDownListFor

For MVC v5 use EnumHelper

For MVC 5 and lower

R – What reporting tool do you suggest for an enterprise level ASP.Net MVC application

Related Topic