This is a really silly question and I think I know the answer to it. I installed Reporting Services on our SQL Server 2000. It worked really well. I then read the article by Mike Gunderloy about Report Builder and that’s just what I wanted for our <smart> end users to design their own reports. I watched the presentation from http://www.microsoft.com/sql/2005/bi/BIn_Ad-HocReporting500k.wvx and was impressed. I typed http://localhost/Reports into my browser to see what would happen. It redirected me to http://localhost/Reports/Pages/Folder.aspx and all looks great. The article by Mike said I had to set up a Data Model for the end users to use. I need to click on SQL Server Business Intelligence Development Studio to set up the Data Model. Oops. No such thing in my SQL Server 2000.
The bottom line: We need to upgrade to SQL Server 2005, right I was hoping Microsoft wrote some sort of retrofit for SQL Server 2000.
Can you use Report Builder with SQL Server 2000 and Visual Studio 2003?
Bastian
Gener
You are right, Report Builder only works with SQL Server 2005 Reporting Services.
-- Robert