maybe try creating a view in the local database that gets the data, then selecting from that in the report