Reporting for MVC - How to Dynamically Generate a Report for a Table or Query

This example demonstrates how to use the Web Document Viewer to display the results of the SQL query in the form of a report. The data source query name is specified in the URL query string.

In this example the XRTable control in a report is created at runtime based on the query results. The query is created at runtime for the specified table. The user specifies the table name in the URL query string.

In the XtraReport code-behind, the SqlDataSource instance is created and populated with data retrieved from the SQL query. The XRTable control is created in code, with table cells bound to the data table columns.

The project uses the SQLite database with Northwind data.

Files to Review

• HomeController.cs (HomeController.vb)
• TestReport.cs (TestReport.vb)

Documentation

• Create Reports in Code
• Bind a Report to a Microsoft SQL Server Database at Runtime
• Standard .NET Providers
• ASP.NET MVC Reporting

More Examples

• How to Generate a Report at Runtime in an ASP.NET MVC Application

Does this example address your development requirements/objectives?

(you will be redirected to DevExpress.com to submit your response)