Reporting Services 2000 with Visual Studio 2005

Does anybody know if there is way to use Reporting Services 2000 with
Visual Studio 2005 (design reports for Reporting Services 2000)?
Regards,
SumardiNo. You cannot do this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sumardi" <sumardi.sm@.gmail.com> wrote in message
news:1144943881.019142.217550@.i39g2000cwa.googlegroups.com...
> Does anybody know if there is way to use Reporting Services 2000 with
> Visual Studio 2005 (design reports for Reporting Services 2000)?
> Regards,
> Sumardi
>|||Can't I have VS 2003 / VS 2005 Report Designers both side-by-side? I need
to design reports to target RS 2000 as well as RS 2005. I have both VS
products installed, but I need to somehow enable RS projects in my VS 2003
environment.. only my VS2005 environment has RS projects enabled.. aaah! I
have SQL 2005 on the box too..
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23O1a0$xXGHA.4988@.TK2MSFTNGP05.phx.gbl...
> No. You cannot do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Sumardi" <sumardi.sm@.gmail.com> wrote in message
> news:1144943881.019142.217550@.i39g2000cwa.googlegroups.com...
>> Does anybody know if there is way to use Reporting Services 2000 with
>> Visual Studio 2005 (design reports for Reporting Services 2000)?
>> Regards,
>> Sumardi
>

Reporting Service 2000 and VS2005

Dear all:

Can I design report using VS2005 and deploy them on Reporting service 2000?

Thanks.

Reports designed with BI Development Studio (Report Designer integrated into VS 2005), can only be directly published to a RS 2005 report server because RS 2005 has additional features (e.g. interactive sort) which required incremental changes and an update in the Report Definition Language (RDL) schema namespace.

However, in many cases you can manually convert RS 2005 RDLs so that they can be published to the RS 2000 report server by editing the RDL and:

1. Change the overall RDL namespace
Replace <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" ... >
With <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" ... >
2. Remove the following elements entirely if present in the RDL file:
<InteractiveWidth>21cm</InteractiveWidth>
<InteractiveHeight>29.7cm</InteractiveHeight>

3. Remove all occurences of interactive sort in the RDL file by removing all <UserSort> elements and its inner contents.

-- Robert

|||Thank you very much Robert! This is just what I needed.|||

I have several RS 2005 reports that I've converted as you suggested to use on SQL Server 2000. Everything was working fine, until now. I am having trouble printing reports. I don't know if this has to do with the conversion. I have the same report on my localhost but I'm running SQL 2005 and I have no problem printing this report. When I convert it and run it on SQL 2000 on another machine the empty reports print, but the ones with data get locked up and I can't even view the print preview. Any suggestions would be most appreciated.

Thanks, Janey

Reporting Service 2000 and VS2005

Dear all:

Can I design report using VS2005 and deploy them on Reporting service 2000?

Thanks.

Reports designed with BI Development Studio (Report Designer integrated into VS 2005), can only be directly published to a RS 2005 report server because RS 2005 has additional features (e.g. interactive sort) which required incremental changes and an update in the Report Definition Language (RDL) schema namespace.

However, in many cases you can manually convert RS 2005 RDLs so that they can be published to the RS 2000 report server by editing the RDL and:

1. Change the overall RDL namespace
Replace <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" ... >
With <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" ... >
2. Remove the following elements entirely if present in the RDL file:
<InteractiveWidth>21cm</InteractiveWidth>
<InteractiveHeight>29.7cm</InteractiveHeight>

3. Remove all occurences of interactive sort in the RDL file by removing all <UserSort> elements and its inner contents.

-- Robert

|||Thank you very much Robert! This is just what I needed.|||

I have several RS 2005 reports that I've converted as you suggested to use on SQL Server 2000. Everything was working fine, until now. I am having trouble printing reports. I don't know if this has to do with the conversion. I have the same report on my localhost but I'm running SQL 2005 and I have no problem printing this report. When I convert it and run it on SQL 2000 on another machine the empty reports print, but the ones with data get locked up and I can't even view the print preview. Any suggestions would be most appreciated.

Thanks, Janey