simple way is that make the report using the dsn.. so where ur database the dsn automatically take the database...
batter way is that if you are using the server client method then use the database on the server.. and make the dsn for every pc...