We have an issue where the canned reports in a Web Assets Database site throw the following error:
Report viewer failed to set the report parameter defaults for this report. Select new default parameter values from the tool pane.
The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition)
Actually all web databases (assets, projects, contacts) throw the same error for the canned reports however report services runs without issue on the server. The Web Assets database seems fine outside of the reports and when opened locally in access
2010 the reports run fine.
We have one Sharepoint 2010 server with SQL 2008 r2 back end configured in sharepoint integration mode.
Thanks for any assistance you can offer. Cheers!
View Complete Post