I just installed SSRS 2005 and I have experience with SQL.
How come this function does not work
SELECT SUBSTRING(YEAR_MONTH, 1, 2) AS Expr1
I get a message which states that this command is not supported by the provider
It works fine with other SQL tools like winsql