Hi Karl.

I tried that one too, and that's where I got the error from. If i leave out the convert(varchar(10)....,013) then it works fine. If I run the SP it...

Hmm, thanks Mark.. i'm getting somewhere (I think!). The report however won't even compile now with these changes. The new error is: "The conversion of a char type to a...

ex Cevas Data Systems Renato?

Got it. Thanks Mark. Works really well now

David

Hi Mark.

Thanks for that article! Helps a lot, and would probably sort out some of my issues too. One thing though: when creating the FUNCTION on page two of that...

I used this as the Default Non-Quried Value:

=DateAdd("d", -(WeekDay(Today()))+1, Today())

Then in the query itself, I just reference the parameter as: to_date('&Parametername','MM/DD/YYYY')

(I'm querying an Oracle DB, so you will need to...

Sorry, to add this...

The problem seems to be that the code is not picking up the date selected at all.

In: WHERE LOG_DATE BETWEEN to_date('&Value1','MM/DD/YYYY') AND to_date('&Value2','MM/DD/YYYY') if '&Value1' is...

Found it on another forum.... I just disabled the Execution Account from Reporting Services Configuration and it all worked fine.

Thanks for your help anyway.

David

Hi. I've checked the Execution Account from within Report Services Configuration, and the username and password matches the UID in Active Directory.

Also, the reports are being run against an Oracle...