Best way to create reports in ASP.NET MVC

Question

After creating my application in ASP.NET MVC and MS SQL Server, I would now like to display some statistics about my data.

What would be the easiest way to create HTML reports that are built from data that intersects multiple tables? (After the fields are selected, they will be static, since one view is required)

I, although there should be something in the lines of the wizard, allowing you to drag and drop fields from your tables into the form and generate logic ...

Answer 1

I wrote a blog post about this in September . This is a way to render a type of PDF content using an RPT file in an application. It covers everything except creating an RDLC file, including how to write unit tests for a controller.

Answer 2

Microsoft Reporting Services ?

Answer 3

"I believe that they should be something in the lines of the wizard, allowing you to drag and drop fields from your tables into the form and generate logic ..." is the main idea of ​​ASP.NET WebForms. But please do not leave MVC in favor of WebForms.

One way to achieve what you want is to create a class that represents your statistics, for example.

public class Statistic { public string TableName { get; set; } public int RowCount { get; set; } } 

The model code can populate an instance of IList<Statistic> , which is passed to your view, which accordingly displays statistics.

Answer 4

You can take a look at dynamic data .... http://www.asp.net/dynamicdata