I have a drill down report that returns several records from 2 tables. In the group footer after each section I want to query another table for one record for the same date.
Neither
IF {tsFinancial.CODE} = "2013" then {tsFinancial.AMOUNT}
OR
IF {tsFinancial.CODE} = "2013" AND {tsUsageVariance.BusinessDate} >= DATETIME(2001, 10, 8, 0, 0, 0) AND {tsUsageVariance.BusinessDate} < DATETIME(2001, 10, 15, 0, 0, 0) then {tsFinancial.AMOUNT}
Returns data. How can I extract the info from tsFinancial when the main guts of the data comes from tsUsageVariance?
Neither
IF {tsFinancial.CODE} = "2013" then {tsFinancial.AMOUNT}
OR
IF {tsFinancial.CODE} = "2013" AND {tsUsageVariance.BusinessDate} >= DATETIME(2001, 10, 8, 0, 0, 0) AND {tsUsageVariance.BusinessDate} < DATETIME(2001, 10, 15, 0, 0, 0) then {tsFinancial.AMOUNT}
Returns data. How can I extract the info from tsFinancial when the main guts of the data comes from tsUsageVariance?