Data staying in SQL 2000 is no problem. Embedding the report in your 1.1 has
several options. Since you cannot go to 2.0 it will be more effort/not as
clean.
VS 2005 comes with new controls (win and webform controls). These are 2.0
framework so you cannot use them.
What you can do is use url integration (see RS help on this). Or you can use
web services.
One issue you will have is the double hop security issue since your app is
on a different machine than RS. I haven't had to deal with this. Just wanted
to raise a red flag for you.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
[quoted text, click to view] "Arjun Prabhu" <techarj@gmail.com> wrote in message
news:1161625291.401181.35130@i42g2000cwa.googlegroups.com...
> Our team is kind of new to SQL Server Reporting Services, and we are
> very keen on using Reporting Services in our Application due to the
> feature set it offers.
>
> We have the following setup....
> 1. Application data - in SQL Server 2000 (say in Machine X)
> 2. Web Application(ASP.NET) - .NET 1.1 based (Say on Macine Y)
>
> Our current setup would not allow use to move the data the application
> data to SQL Server 2005.
> The Application too can't be moved to .NET 2.0 framework.
>
> We would like to use the features of MS SQL Reporting services 2005 in
> our Application.
>
> We have :
> Machine Z - With SQL Server 2005 + SQL Reporting Services 2005
> installed. - data source for the reports is data on Machine X.
>
> My question :
> Is it possible to embed the reports designed and generated on Machine Z
> using Visual Studio .NET 2005 (report designer) into our ASP.NET (1.1)
> based application (VS 2003)?
>
> If so, what do we need to do ?
> Any pointers would be of great help!
>
> thanks in advance
>
> regards,
> Arjun
>
