connection

Hi All,
I have two DB's with same store procedures but different data on the tables,
and base on a condition I want to be able to select a different DB.
Can I change database connection in dynamic way from Reporting Services for
sql2000?
How?
Tks in advance...
JFByou can use this...
exec server_name.db_name.dbo<owner>.proc_name pram1,pram2
JFB wrote:
> Hi All,
> I have two DB's with same store procedures but different data on the tables,
> and base on a condition I want to be able to select a different DB.
> Can I change database connection in dynamic way from Reporting Services for
> sql2000?
> How?
> Tks in advance...
> JFB