Often you might be able to build your performance Dashboard for SQL 2005 (A wonderful utility to monitor and Create reports using Reporting services) using RDL very easliy but at times a BIG in it creates problem in integration.
BASE URL FOR DOWNLOAD
http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en
STEPS
1. Run the Setup.sql file on each instance of SQL Server 2005 that you wish to monitor with the SQL Server 2005 Performance Dashboard Reports.
2. Open the performance_dashboard_main.rdl file with the Custom Reports functionality new to Management Studio in Service Pack 2.
But it is important to understand that you can import all the RDLs into your project and you will see some of the best possible reports on
- CPU bottlenecks (and what queries are consuming the most CPU)
- IO bottlenecks (and what queries are performing the most IO).
- Index recommendations generated by the query optimizer (missing indexes)
- Blocking
- Latch contention
Okay Back to BUG
When you create the report project and build it it wont show any error but try to preview the reports it may or may not show any error BUt there is a hidden value for "version_string" you might have to rename it at times as well if it conflicts.
Just uncheck the Hidden value because after deployment and during run time it gives error
VERSION_STRING is missing a parameter
Youc an jsut go to report :-> report parameters and uncheck the Hidden button..
And you will get the reports perfectly... Good luck with Performance Dashboard.. and THanks MICROSOFT for such a great utility..