Deploying SQL Reports

I am new to SQL reports ..I have couple of questions.
I have created coupld of SQL reports using SQL server business intelligence
studio on my local box and deployed it in my local machine [datbase is also
local] .It works fine.
Then I tried to point to another database on another machine [ a DB in a
virtual server] using Report Service configuration settings. But nowthe
report is not showing up.
How do I point to another Database from my Reporting server...?
Is there any tool for deploying reports on a server other than the one it
created the report ?
Please let me know..
Thanks
RajeshYou should do it using data source only.
Amarnath, MCTS
"PEEYAR" wrote:
> I am new to SQL reports ..I have couple of questions.
> I have created coupld of SQL reports using SQL server business intelligence
> studio on my local box and deployed it in my local machine [datbase is also
> local] .It works fine.
> Then I tried to point to another database on another machine [ a DB in a
> virtual server] using Report Service configuration settings. But nowthe
> report is not showing up.
> How do I point to another Database from my Reporting server...?
> Is there any tool for deploying reports on a server other than the one it
> created the report ?
> Please let me know..
> Thanks
> Rajesh