I have Report Services 2008 running against an Oracle database. The problem occurs when I want to use SYSDATE in my SQL code - SSRS errors out with ORA-00904 "SYDATE": invalid identifier.
Last I checked, SYSDATE worked just fine, valid and all.
To prove this, I run the SQL code through *any* other interface (like Toad, for instance) and it works just fine. So SYSDATE is valid. Except for when you're using SSRS 2008, apparently.
So I look across the 'net, and get told "you have to build a parameter" for that. Fine. I do, and it's called THISDAY, and it's definition is (Fx) '=Today' <---literally that simple. Well, now it puts a text block at the top of the report form BEFORE the report runs, looking for a value (from the user, of course) for THISDAY, which has already been defined as being '=Today'.
Aaargh! Something this simple shouldn't be so flamin' complicated!
How do I use the equivalent of today's date within a SQL query in Microsoft's (Silly) Report Services 2008?