I'm trying to create a report that will always show yesterday's numbers but the SSRS documentation is weak on examples in this area. Yesterday is one of the relative date values for use as filter criteria - but where?
+1
A:
Use a hidden parameter on the report, which is given a default value of:
dateadd("d",-1,today())
Meff
2010-06-17 16:03:22
Worked like a charm - thanks Meff and Stack Overflow.
Ross Morrissey
2010-06-24 15:13:53