devexpress-examples / reporting-generate-report-dynamically-for-specified-query

Generate a report at runtime for the specified data table and query in the ASP.NET Web Forms app.

Reporting for ASP.NET Web Forms - 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