Paginated change datasource through environment pipelines

Hi all  , I am wanting to have a paginated report in a workspace read data from a dataset in another workspace.

So

Report Workspace Dev read from  Dataset Workspace  Dev

I then wish to pass it through pipelines to other environments

Report Workspace UAT read from  Dataset Workspace UAT

Report Workspace PROD read from  Dataset Workspace PROD

How do I automatically point teh report at the correct workspace as it moves environment?

I can parametrize my dataset as it moves across enviroments so that the server and db it looks at changes with pipeline rules. How Can I change what the paginated reports look at? Especially as the report is in a differant workspace to the dataset?

(I am assuming the auto bind would work if the report and dataset where in the same workspace)

Thanks