Wesly
Wesly

Reputation: 679

Best way for creating reports in ASP.NET MVC

After building my application in ASP.NET MVC and MS sql server, I would now like to display some statistics regarding my data.

What would be the easiest way to create HTML reports which are built of data crossing several tables? (Once the fields are picked they'll be static, meanning a single view is required)

I though their ought to be something in the lines of a wizard letting you drag fields from your tables to a form and generates the logic behind...

Upvotes: 7

Views: 8626

Answers (4)

Ian Mercer
Ian Mercer

Reputation: 39277

You could take a look at Dynamic Data .... http://www.asp.net/dynamicdata

Upvotes: 0

Jarrett Meyer
Jarrett Meyer

Reputation: 19573

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

Upvotes: 2

Adam Ralph
Adam Ralph

Reputation: 29956

"I though their ought to be something in the lines of a wizard letting you drag fields from your tables to a form and generates the logic behind..." - this is the basic idea behind ASP.NET WebForms. But, please do not abandon MVC in favour of WebForms.

One way to achieve what you want is to create a class representing your stats, e.g.

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

Your Model code could populate an IList<Statistic> instance which is passed to your View, which renders the stats accordingly.

Upvotes: 0

Justin Niessner
Justin Niessner

Reputation: 245419

Microsoft Reporting Services?

Upvotes: 1

Related Questions