This is a migrated thread and some comments may be shown as answers.

Different datasources for calculation in same report.

1 Answer 172 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Zeya Bakhtyar
Top achievements
Rank 1
Zeya Bakhtyar asked on 21 Jul 2010, 02:15 AM
Scenario:
I have to build a report where there are two different data sources and some calculations have to be performed in the report.

Problem:
I see only one datasource in one report.

Question:
Am I missing something or this is a short coming in the reporting tool? How can I add two datasources and computed fields in the report?

Thank you.

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 23 Jul 2010, 05:28 PM
Hi Zeya Bakhtyar,

A report can be bound to a single data source only. In order to use 2 or more data sources in a single report you can take advantage of the SubReport  item and place as many of them as is the number of the data sources. Each report used as a sub report will correspond to one data source. Another way of utilizing multiple data sources is to use a data item: Table/Crosstab/List. Each data item corresponds a separate data region. The last approach is to use a ReportBook by adding different reports to it.

How to create and use calculated fields is explained in the Calculated Fields help article.

Regards,
Peter
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
General Discussions
Asked by
Zeya Bakhtyar
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or