Can I set a report to use two different servers

[TonyScarpelli]

I am using the VB .NET development environment 2003.

I program at work and use my local SQL server.

I take the project home and use another local SQL server.

I created a report at home and it worked, but when I brought it to work it didn't work because somehow the fields were hooked to the home based server.

Not only that, but I'm pulling the data into a table from my VB .NET form, and passing the table to the report, it's not even supposed to be looking at tables on the server.

Is there a way to make the report generic to use any server or do I have to create two different reports?

Thanks.


Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102

 

[pgtek]

hi
create a systems dsn on your machine at work
then open the report and in the database tab click database set location and pick your new data source

cheers

pgtek