Best way for creating reports in ASP.NET MVC

Question

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...

Answer 1

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.

Answer 2

Microsoft Reporting Services?