In the above example of a ssrs report grouped on date and amt, is there a way on the footer line that i can sum up the Amt column but only sum the amts with todays date.
Lets say 03/23/2010 is todays date. I only want the sum total on the footer line to be 300.00.
Problem is that user can create report with only todays records or todays records and all history records with various dates. If user selects only to show records with todays date then the sum of that column is correct. But if they choose todays and history records then I stll want the final amt (for amt column) to only show a total of todays records only. I dont want history record amts included in final total.