It destroys time!
If you are connecting to an Oracle database :
In your query, get rid of the quotes for the parameter names. Next, replace the '@' with a ':' and preview the report. It should work.
The reason is that Oracle does not understand that parameters begin with '@' . For Oracle, parameters are prepended with a ':' while SSRS understands it the other way round.
So when you try and run the query through the SSRS Query Designer by hitting the '!' in the toolbar, you should probably expect an error message from SSRS. But your report with work fine nevertheless. I haven't found a way around this i.e. keeping both, the database and SSRS from whining, but if you do, please comment on this post since I'm very new at this!
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment