Hi,

I am writing a report with 2 datasets that pull data from an Oracle database, the problem is, I cannot make paramaters for this report. I hard coded the dates in the sql and it works, but if I try to put parameters in the report, it always errors out. I have tried both the :Startdate type and the @Startdate parameter syntax with no luck.

Any help would be greatly appreciated.

Chuck

i could use some help folks

Well I haven't worked with Reporting Services and Oracle but RS uses ADO.NET under the covers. Can you create a parameterised call to the Oracle procedure, in C# for instance? Take a look at the second post in this thread: http://p2p.wrox.com/topic.asp?TOPIC_ID=18096 and there's something here on using Oracle http://msdn2.microsoft.com/en-us/library/ms365174.aspx.

--

Joe (Microsoft MVP - XML)