sql server reporting services: Building reports ? -- sql server reporting services

You're in the

sql server reporting services

group:

Building reports ?

GGill
6/20/2007 9:55:00 AM

sql server reporting services:

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?

Re: Building reports ?

Ayman
6/20/2007 10:56:11 AM

[quoted text, click to view]

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.

Re: Building reports ?

GGill
6/20/2007 11:07:01 AM

Thank you.

[quoted text, click to view]

Re: Building reports ?

GGill
6/20/2007 2:19:46 PM

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?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn