How to reference 2 datasets within a table in a Reporting services
in [Reports]
|
Prev: How to reference 2 datasets within a table in a Reporting services report
Next: SSRS 2008 64bit Oracle Datasource
From: Mick on 10 May 2010 12:11 How can i calculate within my report the movements of two columns coming from 2 different datasets within a table in a Reporting services report. The 2 different datasets are MDX queries with exactly the same number of rows but running over 2 different periods. I just want to calculate within the report the different between the two columns data i.e col A - Col B. I am only able to reference one dataset within the table and for the second dataset, I can only reference the Sum of this column measure or the First/Last record of this column measure, but not each data rows of this column measure. Thanks
From: epdAaronK on 19 May 2010 20:13
first / last is really all you got.. are you sure you can't filter for a single row for what you're looking for On May 10, 9:11 am, Mick <M...(a)discussions.microsoft.com> wrote: > How can i calculate within my report the movements of two columns > coming from 2 different datasets within a table in a Reporting > services report. The 2 different datasets are MDX queries with exactly > the same number of rows but running over 2 different periods. I just > want to calculate within the report the different between the two > columns data i.e col A - Col B. I am only able to reference one > dataset within the table and for the second dataset, I can only > reference the Sum of this column measure or the First/Last record of > this column measure, but not each data rows of this column measure. > Thanks |