<e_man_online@hotmail.com> wrote in message
news:1152820637.475721.274710@p79g2000cwp.googlegroups.com...
> Hi Bruce,
>
> I have VS 2003 and VS 2005 installed in my computer (side by side).
> The RS 2000 is available from VS 2003, but not from VS 2005.
> The database I need to access is in SQL 2000.
> I think I need to install RS 2005 in order to create reports from VS
> 2005, is this correct?
> If that is correct, can I access a SQL 2000 database using RS 2005?
> Do I need to upgrade SQL 2000 client tools to SQL 2005 in order to
> install RS 2005?
>
> Thank you very much,
>
> Rick
>
> Bruce L-C [MVP] wrote:
>> RS 2000 is a dotnet 1.1 application. The report designer needs VS 2003 to
>> install. RS 2005 is a dotnet 2.0 application. The designer can either be
>> installed with VS 2005 or it can install a version of VS just for RS
>> Report
>> Designer.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> <e_man_online@hotmail.com> wrote in message
>> news:1152816953.372783.160330@m73g2000cwd.googlegroups.com...
>> > Hi,
>> >
>> > I'm a newbie to Reporting Services.
>> >
>> > I have VStudio 2005 and then installed SQL 2000 Reporting Services. On
>> > the Windows "Start" menu it only added the samples and the help. Is
>> > this ok?
>> >
>> > If I open VStudio 2005 and try to create a new project, I cannot see
>> > any project type that resembles Reporting Services project.
>> >
>> > What am I doing wrong?
>> >
>> > Thanks in advance,
>> >
>> > Rick
>> >
>

<e_man_online@hotmail.com> wrote in message
news:1152828278.375016.316270@75g2000cwc.googlegroups.com...
> Thank you, but I'm a little confused. What happens is that my
> application code is in VS 2005's .Net 2.0, and it accesses a database
> in SQL 2000. The application needs to start using Reporting Services,
> so this application in VS 2005 can generate reports fom the database in
> SQL 2000.
>
> Which Reporting Services Client tools do I need? 2000 or 2005 ?
> If I use RS 2005, can I still access the database data, which is in SQL
> 2000?
> If I use RS 2005, will I be able to store the reports in the database
> that is in
> SQL 2000?
>
> Thank you in advance,
>
> Rick
>
> Bruce L-C [MVP] wrote:
>> RS 2000 reports will run in RS 2005 but I had some small issues and
>> upgraded
>> all my reports to 2005.
>>
>> The question you need to ask is what version of RS do you want to run.
>> Although the database can stay as 2000 you have to purchase a SQL Server
>> 2005 license to be running RS 2005. RS 2005 have a lot of improvements
>> and
>> I suggest running it if you are just starting out. The RS 2005 report
>> designer comes with the SQL Server 2005 media.
>>
>> Note that what you are reporting off of is different from where the
>> object/metadata for RS is stored. You can report off of data from almost
>> anything.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <e_man_online@hotmail.com> wrote in message
>> news:1152820637.475721.274710@p79g2000cwp.googlegroups.com...
>> > Hi Bruce,
>> >
>> > I have VS 2003 and VS 2005 installed in my computer (side by side).
>> > The RS 2000 is available from VS 2003, but not from VS 2005.
>> > The database I need to access is in SQL 2000.
>> > I think I need to install RS 2005 in order to create reports from VS
>> > 2005, is this correct?
>> > If that is correct, can I access a SQL 2000 database using RS 2005?
>> > Do I need to upgrade SQL 2000 client tools to SQL 2005 in order to
>> > install RS 2005?
>> >
>> > Thank you very much,
>> >
>> > Rick
>> >
>> > Bruce L-C [MVP] wrote:
>> >> RS 2000 is a dotnet 1.1 application. The report designer needs VS 2003
>> >> to
>> >> install. RS 2005 is a dotnet 2.0 application. The designer can either
>> >> be
>> >> installed with VS 2005 or it can install a version of VS just for RS
>> >> Report
>> >> Designer.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> <e_man_online@hotmail.com> wrote in message
>> >> news:1152816953.372783.160330@m73g2000cwd.googlegroups.com...
>> >> > Hi,
>> >> >
>> >> > I'm a newbie to Reporting Services.
>> >> >
>> >> > I have VStudio 2005 and then installed SQL 2000 Reporting Services.
>> >> > On
>> >> > the Windows "Start" menu it only added the samples and the help. Is
>> >> > this ok?
>> >> >
>> >> > If I open VStudio 2005 and try to create a new project, I cannot see
>> >> > any project type that resembles Reporting Services project.
>> >> >
>> >> > What am I doing wrong?
>> >> >
>> >> > Thanks in advance,
>> >> >
>> >> > Rick
>> >> >
>> >
>

"Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
news:ecqBkn4pGHA.4932@TK2MSFTNGP05.phx.gbl...
> The ideal way to do this is the following:
> 1. Use RS 2005. RS 2005 can be installed to use SQL Server 2000 as its
> object/metadata store but you do need a 2005 license.
> 2. Use the new controls found in VS 2005 to integrate in viewing the
> reports in your application. (these new controls only work with RS 2005
> reports)
> 3. Use the RS 2005 report designer (which when installed will integrate
> with your VS 2005 environment).
>
> If you cannot have RS 2005 server for whatever reason then investigate
> using the new controls in local mode. In local mode you give the control a
> report and a tableset and it renders the report. No server is necessary.
>
> The data you are reporting on can come from any backend database (within
> reason): Sybase, SQL Server, Oracle, etc.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> <e_man_online@hotmail.com> wrote in message
> news:1152828278.375016.316270@75g2000cwc.googlegroups.com...
>> Thank you, but I'm a little confused. What happens is that my
>> application code is in VS 2005's .Net 2.0, and it accesses a database
>> in SQL 2000. The application needs to start using Reporting Services,
>> so this application in VS 2005 can generate reports fom the database in
>> SQL 2000.
>>
>> Which Reporting Services Client tools do I need? 2000 or 2005 ?
>> If I use RS 2005, can I still access the database data, which is in SQL
>> 2000?
>> If I use RS 2005, will I be able to store the reports in the database
>> that is in
>> SQL 2000?
>>
>> Thank you in advance,
>>
>> Rick
>>
>> Bruce L-C [MVP] wrote:
>>> RS 2000 reports will run in RS 2005 but I had some small issues and
>>> upgraded
>>> all my reports to 2005.
>>>
>>> The question you need to ask is what version of RS do you want to run.
>>> Although the database can stay as 2000 you have to purchase a SQL Server
>>> 2005 license to be running RS 2005. RS 2005 have a lot of improvements
>>> and
>>> I suggest running it if you are just starting out. The RS 2005 report
>>> designer comes with the SQL Server 2005 media.
>>>
>>> Note that what you are reporting off of is different from where the
>>> object/metadata for RS is stored. You can report off of data from almost
>>> anything.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>> <e_man_online@hotmail.com> wrote in message
>>> news:1152820637.475721.274710@p79g2000cwp.googlegroups.com...
>>> > Hi Bruce,
>>> >
>>> > I have VS 2003 and VS 2005 installed in my computer (side by side).
>>> > The RS 2000 is available from VS 2003, but not from VS 2005.
>>> > The database I need to access is in SQL 2000.
>>> > I think I need to install RS 2005 in order to create reports from VS
>>> > 2005, is this correct?
>>> > If that is correct, can I access a SQL 2000 database using RS 2005?
>>> > Do I need to upgrade SQL 2000 client tools to SQL 2005 in order to
>>> > install RS 2005?
>>> >
>>> > Thank you very much,
>>> >
>>> > Rick
>>> >
>>> > Bruce L-C [MVP] wrote:
>>> >> RS 2000 is a dotnet 1.1 application. The report designer needs VS
>>> >> 2003 to
>>> >> install. RS 2005 is a dotnet 2.0 application. The designer can either
>>> >> be
>>> >> installed with VS 2005 or it can install a version of VS just for RS
>>> >> Report
>>> >> Designer.
>>> >>
>>> >>
>>> >> --
>>> >> Bruce Loehle-Conger
>>> >> MVP SQL Server Reporting Services
>>> >>
>>> >> <e_man_online@hotmail.com> wrote in message
>>> >> news:1152816953.372783.160330@m73g2000cwd.googlegroups.com...
>>> >> > Hi,
>>> >> >
>>> >> > I'm a newbie to Reporting Services.
>>> >> >
>>> >> > I have VStudio 2005 and then installed SQL 2000 Reporting Services.
>>> >> > On
>>> >> > the Windows "Start" menu it only added the samples and the help. Is
>>> >> > this ok?
>>> >> >
>>> >> > If I open VStudio 2005 and try to create a new project, I cannot
>>> >> > see
>>> >> > any project type that resembles Reporting Services project.
>>> >> >
>>> >> > What am I doing wrong?
>>> >> >
>>> >> > Thanks in advance,
>>> >> >
>>> >> > Rick
>>> >> >
>>> >
>>
>
>

"frankie lo" <frankiecblo@hotmail.com> wrote in message
news:%23c06wn7pGHA.4988@TK2MSFTNGP04.phx.gbl...
> Hi Bruce,
>
> I have same problem. My question is can I use SR2005 & RS Reports (in web
> server machine) to access SQL2000's AS or cube data in db server machine?
> Do you know any issue?
>
> Thanks for your help
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
> news:ecqBkn4pGHA.4932@TK2MSFTNGP05.phx.gbl...
>> The ideal way to do this is the following:
>> 1. Use RS 2005. RS 2005 can be installed to use SQL Server 2000 as its
>> object/metadata store but you do need a 2005 license.
>> 2. Use the new controls found in VS 2005 to integrate in viewing the
>> reports in your application. (these new controls only work with RS 2005
>> reports)
>> 3. Use the RS 2005 report designer (which when installed will integrate
>> with your VS 2005 environment).
>>
>> If you cannot have RS 2005 server for whatever reason then investigate
>> using the new controls in local mode. In local mode you give the control
>> a report and a tableset and it renders the report. No server is
>> necessary.
>>
>> The data you are reporting on can come from any backend database (within
>> reason): Sybase, SQL Server, Oracle, etc.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> <e_man_online@hotmail.com> wrote in message
>> news:1152828278.375016.316270@75g2000cwc.googlegroups.com...
>>> Thank you, but I'm a little confused. What happens is that my
>>> application code is in VS 2005's .Net 2.0, and it accesses a database
>>> in SQL 2000. The application needs to start using Reporting Services,
>>> so this application in VS 2005 can generate reports fom the database in
>>> SQL 2000.
>>>
>>> Which Reporting Services Client tools do I need? 2000 or 2005 ?
>>> If I use RS 2005, can I still access the database data, which is in SQL
>>> 2000?
>>> If I use RS 2005, will I be able to store the reports in the database
>>> that is in
>>> SQL 2000?
>>>
>>> Thank you in advance,
>>>
>>> Rick
>>>
>>> Bruce L-C [MVP] wrote:
>>>> RS 2000 reports will run in RS 2005 but I had some small issues and
>>>> upgraded
>>>> all my reports to 2005.
>>>>
>>>> The question you need to ask is what version of RS do you want to run.
>>>> Although the database can stay as 2000 you have to purchase a SQL
>>>> Server
>>>> 2005 license to be running RS 2005. RS 2005 have a lot of improvements
>>>> and
>>>> I suggest running it if you are just starting out. The RS 2005 report
>>>> designer comes with the SQL Server 2005 media.
>>>>
>>>> Note that what you are reporting off of is different from where the
>>>> object/metadata for RS is stored. You can report off of data from
>>>> almost
>>>> anything.
>>>>
>>>>
>>>> --
>>>> Bruce Loehle-Conger
>>>> MVP SQL Server Reporting Services
>>>> <e_man_online@hotmail.com> wrote in message
>>>> news:1152820637.475721.274710@p79g2000cwp.googlegroups.com...
>>>> > Hi Bruce,
>>>> >
>>>> > I have VS 2003 and VS 2005 installed in my computer (side by side).
>>>> > The RS 2000 is available from VS 2003, but not from VS 2005.
>>>> > The database I need to access is in SQL 2000.
>>>> > I think I need to install RS 2005 in order to create reports from VS
>>>> > 2005, is this correct?
>>>> > If that is correct, can I access a SQL 2000 database using RS 2005?
>>>> > Do I need to upgrade SQL 2000 client tools to SQL 2005 in order to
>>>> > install RS 2005?
>>>> >
>>>> > Thank you very much,
>>>> >
>>>> > Rick
>>>> >
>>>> > Bruce L-C [MVP] wrote:
>>>> >> RS 2000 is a dotnet 1.1 application. The report designer needs VS
>>>> >> 2003 to
>>>> >> install. RS 2005 is a dotnet 2.0 application. The designer can
>>>> >> either be
>>>> >> installed with VS 2005 or it can install a version of VS just for RS
>>>> >> Report
>>>> >> Designer.
>>>> >>
>>>> >>
>>>> >> --
>>>> >> Bruce Loehle-Conger
>>>> >> MVP SQL Server Reporting Services
>>>> >>
>>>> >> <e_man_online@hotmail.com> wrote in message
>>>> >> news:1152816953.372783.160330@m73g2000cwd.googlegroups.com...
>>>> >> > Hi,
>>>> >> >
>>>> >> > I'm a newbie to Reporting Services.
>>>> >> >
>>>> >> > I have VStudio 2005 and then installed SQL 2000 Reporting
>>>> >> > Services. On
>>>> >> > the Windows "Start" menu it only added the samples and the help.
>>>> >> > Is
>>>> >> > this ok?
>>>> >> >
>>>> >> > If I open VStudio 2005 and try to create a new project, I cannot
>>>> >> > see
>>>> >> > any project type that resembles Reporting Services project.
>>>> >> >
>>>> >> > What am I doing wrong?
>>>> >> >
>>>> >> > Thanks in advance,
>>>> >> >
>>>> >> > Rick
>>>> >> >
>>>> >
>>>
>>
>>
>
>