Binding a report to DataTables with different schemas

Kamyar · Post by **Kamyar** » Sun Feb 27, 2011 12:07 am

I'd like to develop a generic reporting engine which would be able to simply various sorts of DataTables with different column names and schema.
The problem is that I don't have a predefined schema for that DataTable. In other words, the report should be able to list a table with column1,column2,column3 columns and also be able to list a DataTable with column4,column5 columns.
I have attached a screenshot for clarification.
Is this possible?
Thank you.

Post by **Alex K.** » Mon Feb 28, 2011 3:21 am

Hello,

You can place this DataSource twice on the page, and select the required fields for each one.

Thank you.

Kamyar · Post by **Kamyar** » Mon Feb 28, 2011 4:20 am

Aleksey,
Thank you for the reply. However, I think you misunderstood me.
The report don't have any knowledge about the data sources structure. Just like how a DataGridView can be bound to any DataTable without knowing its structure and AutoGenerate columns.
Actually, I want a report to work just like a GridView. Simply list all the rows and columns of a custom DataTable.
For example, suppose you want to have a report that can display Northwind's customers AND also can display a custom Datatable that you have just populated from another database.
In simple words, I want a report without any grouping, filtering, ... to just list any DataTable.
Thank you.

Post by **Alex K.** » Mon Feb 28, 2011 6:29 am

Hello,

Could you please clarify your task. Do you want to render a report from the report code without using the designer?

Thank you.

Kamyar · Post by **Kamyar** » Mon Feb 28, 2011 11:43 pm

Yes Aleksey,
I'd like to assign the db, render, and show the report from the report code. I'd appreciate it if you shed some light on this matter.

Post by **Alex K.** » Tue Mar 01, 2011 2:03 am

Hello,

Please see sample project in attachment.

Thank you.

Kamyar · Post by **Kamyar** » Tue Mar 01, 2011 3:20 am

Thank you Aleksey.
That was exactly what I was looking for.

Post by **Andrew** » Tue Mar 01, 2011 5:23 am

Hello,

Have a nice day!

Thank you.

Kamyar · Post by **Kamyar** » Wed Mar 09, 2011 3:31 am

Aleksey/Andrew,
Your code works great on winforms. Is there any limitations for using it on webforms? I just tried to use it in a web application project with no luck.
Thank you.
UPDATE:
Nevermind, I had forgotten to bind the report correctly. Thanks!

Post by **Alex K.** » Wed Mar 09, 2011 5:43 am

Hello,

Do I understand you correct that the issue is solved?

Thank you.