If we have SQL Server 2000 and SQL Server Reporting Services already installed is it possible to design reports in VS.NET 2005 or is VS.NET 2005 tied to the SQL Server 2005 Reporting Services
Steve Miller
SQL Server 2000 Reporting Services and VS.NET 2005
Hot Topic
- DSV and Cube do not match - generates Key Errors
- SELECT INTO using a data-flow
- Package still referencing old parameters from an old connection
- Transactions in Data Flow
- GetValue on a DTSProperty Object
- design of the classes of data access layer
- SQL Server 2005 Management Studio can't be found
- A question about group structure?
- Linked Server to Sybase 11 problem
- Sykmetric keys
SQL Server
- Downloading from AS 400
- Parameter for Breaking at start of Group
- TOP 100 ordering of Data Question
- How do you determine the size difference of transaction log per million INSERTs?
- Uninstall .Net Framework
- Keep getting Virtual Memory errors
- sql server express does not start
- Using calendar datepicker parameters with MDX into RS2005
- calculate weekendings for a date range
- Report Properties -> CODE issue
SQL Server 2000 Reporting Services and VS.NET 2005
ssalter
Sort of.
When you create your SSRS 2000 report (with VS2003), you can then upload/deploy it directly to SSRS 2005, or open it with VS 2005.
If you upload/deploy it, the report will work, and you can even export it back OUT of SSRS 2005 as a SSRS 2000 report (I learned this only recenlty myself). If you open the report with VS 2005, the schema of the report is automatically upgraded to 2005, and it will only work inside SSRS 2005 and VS 2005.
I've started a list of questions and answers around this topic, which you can read here:
http://blogs.msdn.com/bimusings/archive/2005/12/13/503110.aspx
Steve Schmidt
Terrell Plotzki
So basically we could create our reports using VS.NET 2003 and SQL Server 2000 Reporting Services and consume them using VS.NET 2005 and .NET 2.0
sm