Use multiple DataSource data in one report table in SSRS

When we create SSRS reports we can drag n drop column to to table from data source.

But if we need to use two data sources and show both data in one table. 

Like sum,avg from one data source & cell values from another data source . 

Then we can add regular exp to relevant header (where sum and avg put)  column text box as below.

=First(Fields!flowRateTotal.Value,"dsTotAvgData")

In above expression "flowRateTotal" is the field name and "dsTotAvgData" DataSet name. All others are SSRS keywords.


Happy coding.

Comments

Popular Posts