Report Header from a different table

[JaiGanesh]

Hi ,

While creating a report, for Purchase order specifically, i want the header part of the report (company particulars) from a different table, how do i link this to a data source created for the company details to the header, when trying to add fields from the DATA EXPLORER to a textbox, it is showing error that the report is linked to another data source( which is my primary data source which has the purchase order no, date etc.,)

Regards,
Jai

[Ivan Hristov]

Hi Jai,

Currently only one DataSource per report item is allowed. Although to accomplish your goal you have several options:

• Use report items that can be databound - you can put your detail content in a Table, Crosstab or List, bound to a property of your primary data source. In this case the contents of your report header will also be properties in the DataSource
• Add the header content (company particulars) to your primary dataset and use data filtering to split the data you need for the details and for the header.
• Use SubReport to show your header content - that means you will need another report just to hold a relatively small amount of data. 

I hope that helps.

Regards,
Ivan Hristov
Telerik

[JaiGanesh]

Hi,

Thanks for the reply. Have solved it by using a list control and binding it to a different data source.

Regards,
Jai