Building reports ?

The databases I have in the SQL Server 2000 and i need to use
reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i
want to just have connection to my databases in 2000 without restoring
the db's in the 2005. Can i build the reports using SSRS 2005? If yes
then what steps do i need to know to start building RS reports besides
connecting to SR2000 db?
Thanks.On Jun 20, 12:55 pm, GGill <G...@.discussions.microsoft.com> wrote:
> The databases I have in the SQL Server 2000 and i need to use
> reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i
> want to just have connection to my databases in 2000 without restoring
> the db's in the 2005. Can i build the reports using SSRS 2005? If yes
> then what steps do i need to know to start building RS reports besides
> connecting to SR2000 db?
> Thanks.
When you make the reports, link them to the SQL Server 2000 server.
I've never had any problem pulling data from the older servers. You
would add the connection string the same way you would with the 2005
version. You can even make shared datasources. I just tested it, yep
it works. Just make a shared datasource and use that for all your
reports. It will link to the specified server/database as needed.
Hope that helps.|||Thank you.
"Ayman" wrote:
> On Jun 20, 12:55 pm, GGill <G...@.discussions.microsoft.com> wrote:
> > The databases I have in the SQL Server 2000 and i need to use
> > reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i
> > want to just have connection to my databases in 2000 without restoring
> > the db's in the 2005. Can i build the reports using SSRS 2005? If yes
> > then what steps do i need to know to start building RS reports besides
> > connecting to SR2000 db?
> >
> > Thanks.
> When you make the reports, link them to the SQL Server 2000 server.
> I've never had any problem pulling data from the older servers. You
> would add the connection string the same way you would with the 2005
> version. You can even make shared datasources. I just tested it, yep
> it works. Just make a shared datasource and use that for all your
> reports. It will link to the specified server/database as needed.
> Hope that helps.
>|||When i linked from SSRS2005 to SS2000 .
Should i go first to the Reporting Services Configuration? If yes then
when i go to Reporting Services Configuration it is asking me to select from
drop-down box instance name but my instance name is disabled. How can i
enable that?
If i do not need to do that then after conecting to server should i just
start creating project and designing the new reports from Visual Studio 2005?
"GGill" wrote:
> Thank you.
> "Ayman" wrote:
> > On Jun 20, 12:55 pm, GGill <G...@.discussions.microsoft.com> wrote:
> > > The databases I have in the SQL Server 2000 and i need to use
> > > reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i
> > > want to just have connection to my databases in 2000 without restoring
> > > the db's in the 2005. Can i build the reports using SSRS 2005? If yes
> > > then what steps do i need to know to start building RS reports besides
> > > connecting to SR2000 db?
> > >
> > > Thanks.
> >
> > When you make the reports, link them to the SQL Server 2000 server.
> > I've never had any problem pulling data from the older servers. You
> > would add the connection string the same way you would with the 2005
> > version. You can even make shared datasources. I just tested it, yep
> > it works. Just make a shared datasource and use that for all your
> > reports. It will link to the specified server/database as needed.
> > Hope that helps.
> >
> >