question

So, 1st of all: the reports are all working fine when executing against a SQL Srv 2012. What I tried was to run the reports against a SQL 2008 and a SQL 2008 R2 (and yes, I've executed the setup.sql first against these servers....) The performance_dashboard_main.rdl worked fine but when I called the report Recen CPU Consumption then the above mentioned error occured. So first thing I did was t trace my session and catched following statement exec sp_executesql @stmt=N'exec msdb.MS_PerfDashboard.usp_QueryStatsRecentActivity @WithActivitySince',@params=N'@WithActivitySince NVarChar(max)',@WithActivitySince=N'27.07.2012 19:52:17' right before getting a conversion error (cannot convert nvarchar to datetime) So I picked the recent_cpu.rdl, opened it in BIDS and checked the parameters. The parameter 'WithActivitySince' is declared as string. So my easy solution in that case (and not to mess up the different xml schemas since the reports still have the 2005 definition and I used BIDS 2008) was to change the data type in the report from String true WithActivitySince to the following DateTime true WithActivitySince Afterwards I double-checked my change against a SQL 2012 and the report can stll be opened. That's it Regards Dirk