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.
In above expression "flowRateTotal" is the field name and "dsTotAvgData" DataSet name. All others are SSRS keywords.
Happy coding.
Comments
Post a Comment