Reporting Services 2005 installs something called SQL Server Business
Intelligence Development Studio which is built on top of Visual Studio 2005.
Visual Studio 2005 will handle conversion from the 2003 solution format to
the 2005 solution format. Individual reports must be double-clicked on to be
converted into the new format. Once a solution or report is converted to the
new format, it cannot be opened in Visual Studio 2003. So the answer to your
first question is that you cannot create reports that are backwards
compatible but you can upgrade existing reports. The answer to your second
question is that you cannot create or maintain reports from RS 2005 in VS
2003.
[quoted text, click to view] "Asher_N" wrote:
> "J Smith" <rs-nntp@jascentral.com> wrote in
> news:O8AuEhA1FHA.2880@TK2MSFTNGP12.phx.gbl:
>
> > My company uses Reporting Services and is looking at future upgrades
> > of our development and server software. What we need to know is how
> > backwards and forwards compatible the new VS dev environment and SQL
> > Server are expected to be.
> >
> > Will it be possible to create/maintain Reporting Services 2000 SP2
> > reports from Visual Studio 2005?
>
> I would assume so.
>
>
>
> > Will it be possible to create/maintain Reporting Services 2005 reports
> > from Visual Studio 2003?
> >
>
> No
>
> > Thanks,
> > J Smith
> >
> >
> >
>
In addition, RS 2005 uses the 2.0 framework instead of 1.1. This means IIS
gets upgraded to support 2.0. RS 2005 can use a SQL Server 2000 database for
its object/metadata store but you still need a 2005 license.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
[quoted text, click to view] "nas_dev" <nasdev@discussions.microsoft.com> wrote in message
news:85EA1B03-2CA0-44DF-81EB-1E95D3CC9D5F@microsoft.com...
> Reporting Services 2005 installs something called SQL Server Business
> Intelligence Development Studio which is built on top of Visual Studio
> 2005.
> Visual Studio 2005 will handle conversion from the 2003 solution format to
> the 2005 solution format. Individual reports must be double-clicked on to
> be
> converted into the new format. Once a solution or report is converted to
> the
> new format, it cannot be opened in Visual Studio 2003. So the answer to
> your
> first question is that you cannot create reports that are backwards
> compatible but you can upgrade existing reports. The answer to your second
> question is that you cannot create or maintain reports from RS 2005 in VS
> 2003.
>
>
>
> "Asher_N" wrote:
>
>> "J Smith" <rs-nntp@jascentral.com> wrote in
>> news:O8AuEhA1FHA.2880@TK2MSFTNGP12.phx.gbl:
>>
>> > My company uses Reporting Services and is looking at future upgrades
>> > of our development and server software. What we need to know is how
>> > backwards and forwards compatible the new VS dev environment and SQL
>> > Server are expected to be.
>> >
>> > Will it be possible to create/maintain Reporting Services 2000 SP2
>> > reports from Visual Studio 2005?
>>
>> I would assume so.
>>
>>
>>
>> > Will it be possible to create/maintain Reporting Services 2005 reports
>> > from Visual Studio 2003?
>> >
>>
>> No
>>
>> > Thanks,
>> > J Smith
>> >
>> >
>> >
>>
>>
