Using Reporting Services 2000 with Visual Studios 2005
in [Reports]
|
From: Steve on 29 Jan 2006 08:31 We are using SQL2000 with Reporting Services 2000. I would like to be able to use Visual Studios 2005 to create my reports. After creating the reports and uploading the report to Reporting Services2000 we get the following error: The report definition is not valid. Please verify that the report definition uses the current report definition namespace (i.e. ?http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition?). (rsNotACurrentReportDefinition) When I look at my rdl I can see that my namespace is: <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> When I try to change the /2005/01/ to /2003/10/ I get an different error. Is there a way of telling VS2005 to create the rdl for use with RP2000? Thanks...
From: Bruce L-C [MVP] on 29 Jan 2006 09:56 No. You have to use the RS 2000 report designer, which requires VS 2003.You can run VS 2003 and VS 2005 side by side (I do). Also, keep in mind, that if you want to upgrade RS to 2005 you can leave SQL Server DB at 2000 (however you do need a 2005 license). This is how I am currently running. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "Steve" <Steve(a)discussions.microsoft.com> wrote in message news:01AF147A-41BD-4726-B522-914F47AA95CC(a)microsoft.com... > We are using SQL2000 with Reporting Services 2000. I would like to be > able > to use Visual Studios 2005 to create my reports. After creating the > reports > and uploading the report to Reporting Services2000 we get the following > error: > > > > > The report definition is not valid. Please verify that the report > definition > uses the current report definition namespace (i.e. > 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition'). > (rsNotACurrentReportDefinition) > > > When I look at my rdl I can see that my namespace is: > <Report > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" > xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> > > When I try to change the /2005/01/ to /2003/10/ I get an different error. > > Is there a way of telling VS2005 to create the rdl for use with RP2000? > > Thanks... >
From: Steve on 29 Jan 2006 12:59 I think i know the answer to this, but just on the off chance I will ask. The 2005 license you mentioned that we would need if we wanted to use RS2005 is for SQL and not VS2005. Is that correct? My client is not willing to pay for the SQL2005 license at this point so this option is not available to me. From your message I am pretty sure you were talking about the SQL license, but thought I would double check. Thanks for your help on this. "Bruce L-C [MVP]" wrote: > No. You have to use the RS 2000 report designer, which requires VS 2003.You > can run VS 2003 and VS 2005 side by side (I do). > > Also, keep in mind, that if you want to upgrade RS to 2005 you can leave SQL > Server DB at 2000 (however you do need a 2005 license). This is how I am > currently running. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > > "Steve" <Steve(a)discussions.microsoft.com> wrote in message > news:01AF147A-41BD-4726-B522-914F47AA95CC(a)microsoft.com... > > We are using SQL2000 with Reporting Services 2000. I would like to be > > able > > to use Visual Studios 2005 to create my reports. After creating the > > reports > > and uploading the report to Reporting Services2000 we get the following > > error: > > > > > > > > > > The report definition is not valid. Please verify that the report > > definition > > uses the current report definition namespace (i.e. > > 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition'). > > (rsNotACurrentReportDefinition) > > > > > > When I look at my rdl I can see that my namespace is: > > <Report > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" > > xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> > > > > When I try to change the /2005/01/ to /2003/10/ I get an different error. > > > > Is there a way of telling VS2005 to create the rdl for use with RP2000? > > > > Thanks... > > > > >
From: Bruce L-C [MVP] on 29 Jan 2006 20:41 RS 2005 comes with a version of VS 2005 just for the designer. No extra purchase is needed. Yes, the license if for SQL Server 2005. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "Steve" <Steve(a)discussions.microsoft.com> wrote in message news:EC78353A-1262-4237-91C4-72085566D109(a)microsoft.com... >I think i know the answer to this, but just on the off chance I will ask. > The 2005 license you mentioned that we would need if we wanted to use > RS2005 > is for SQL and not VS2005. Is that correct? My client is not willing to > pay > for the SQL2005 license at this point so this option is not available to > me. > From your message I am pretty sure you were talking about the SQL license, > but thought I would double check. > > Thanks for your help on this. > > "Bruce L-C [MVP]" wrote: > >> No. You have to use the RS 2000 report designer, which requires VS >> 2003.You >> can run VS 2003 and VS 2005 side by side (I do). >> >> Also, keep in mind, that if you want to upgrade RS to 2005 you can leave >> SQL >> Server DB at 2000 (however you do need a 2005 license). This is how I am >> currently running. >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> >> >> "Steve" <Steve(a)discussions.microsoft.com> wrote in message >> news:01AF147A-41BD-4726-B522-914F47AA95CC(a)microsoft.com... >> > We are using SQL2000 with Reporting Services 2000. I would like to be >> > able >> > to use Visual Studios 2005 to create my reports. After creating the >> > reports >> > and uploading the report to Reporting Services2000 we get the following >> > error: >> > >> > >> > >> > >> > The report definition is not valid. Please verify that the report >> > definition >> > uses the current report definition namespace (i.e. >> > 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition'). >> > (rsNotACurrentReportDefinition) >> > >> > >> > When I look at my rdl I can see that my namespace is: >> > <Report >> > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" >> > xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> >> > >> > When I try to change the /2005/01/ to /2003/10/ I get an different >> > error. >> > >> > Is there a way of telling VS2005 to create the rdl for use with RP2000? >> > >> > Thanks... >> > >> >> >>
From: Steve on 29 Jan 2006 22:17 Bruce, Thanks for the info. I was real excited when I first saw your message but then as I thought about it some more I figured there was something that I was not clear of in my prior message that may be important here. My client does not have Visual Studio ? I have that on my machine and I develop for them on my machine and then move it to their machine. They are licensed for SQL2000. Would then need to have a license for VS2005 if I were to use RS2005 on their server? Thanks again. "Bruce L-C [MVP]" wrote: > RS 2005 comes with a version of VS 2005 just for the designer. No extra > purchase is needed. Yes, the license if for SQL Server 2005. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Steve" <Steve(a)discussions.microsoft.com> wrote in message > news:EC78353A-1262-4237-91C4-72085566D109(a)microsoft.com... > >I think i know the answer to this, but just on the off chance I will ask. > > The 2005 license you mentioned that we would need if we wanted to use > > RS2005 > > is for SQL and not VS2005. Is that correct? My client is not willing to > > pay > > for the SQL2005 license at this point so this option is not available to > > me. > > From your message I am pretty sure you were talking about the SQL license, > > but thought I would double check. > > > > Thanks for your help on this. > > > > "Bruce L-C [MVP]" wrote: > > > >> No. You have to use the RS 2000 report designer, which requires VS > >> 2003.You > >> can run VS 2003 and VS 2005 side by side (I do). > >> > >> Also, keep in mind, that if you want to upgrade RS to 2005 you can leave > >> SQL > >> Server DB at 2000 (however you do need a 2005 license). This is how I am > >> currently running. > >> > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> > >> > >> "Steve" <Steve(a)discussions.microsoft.com> wrote in message > >> news:01AF147A-41BD-4726-B522-914F47AA95CC(a)microsoft.com... > >> > We are using SQL2000 with Reporting Services 2000. I would like to be > >> > able > >> > to use Visual Studios 2005 to create my reports. After creating the > >> > reports > >> > and uploading the report to Reporting Services2000 we get the following > >> > error: > >> > > >> > > >> > > >> > > >> > The report definition is not valid. Please verify that the report > >> > definition > >> > uses the current report definition namespace (i.e. > >> > 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition'). > >> > (rsNotACurrentReportDefinition) > >> > > >> > > >> > When I look at my rdl I can see that my namespace is: > >> > <Report > >> > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" > >> > xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> > >> > > >> > When I try to change the /2005/01/ to /2003/10/ I get an different > >> > error. > >> > > >> > Is there a way of telling VS2005 to create the rdl for use with RP2000? > >> > > >> > Thanks... > >> > > >> > >> > >> > > >
|
Next
|
Last
Pages: 1 2 Prev: How to suppress a field if it is null Next: Trying to Initialize Reporting Services |