Build report in SSRS 2008 with Oracle 9i backend DB. I'd like to enable user to input the date. Here is what I did:
1. Create a parameter in the Parameter folder ---- date
2. Create a query as below:
Select * from myDB
Where myDB.myDate = :date
The err is --- ORA-01745 invaild host/bind varable name.
However below query works just fine:
Select * from myDB
Where myDB.myDate = '22-march-2011'
Then I changed to:
= ':Date"
and key in "22-march-2011"
Err---- ORA-01858 a non-numeric character was found where numeric was expected
Then change to
= to_date(:Date,'DD-Mon-YYYY')
The err as the first one ----ORA-01745 invaild host/bind varable name.
Please help!
Thanks a lot!!!