I am working on a project, i must provide reports via Reporting Services. 2008.
Problem is, it is for some reason almost always falsely declaring my query as a bad one (must declare something that IS declared, or wrong use of operator minus when its NOT wrong).
For example, i have a query with parameters @sd and @ed (start date and end date). I intend to let user set @ed to null, in that case, the month of @sd is used. So, first lines of query look like this:
IF (@ED IS NULL)
And then it fails to see that @sd is a parameter, instead it spits like 5 times "must declare @sd" and refuses to refresh list of rows.
Same happens with other queries. For example, i keep getting the "Operand data type nvarchar is invalid for minus operator" on a 100% correct query. And with others. Those are 100% legit, work in sql management studio as well as they work after i click "continue"
at error message and compile a report.
So far this seems like a major bug to me. Or am i doing something wrong?
View Complete Post