Sue,

Thanks for that but surely that just refresh's the whole report with new data whereas I want a multi page report to automatically cycle through the pages without...

Here's an example of one of the current queries if that helps

SELECT

TestRuns.AlternateTestRunId

,[HDCW.553.STARS.Report].StepName

,[HDCW.553.STARS.Report].DynoSpeed

,[HDCW.553.STARS.Report].DynoTorque

,[HDCW.553.STARS.Report].EngPower

,[HDCW.553.STARS.Report].rFuelEngIn

,[HDCW.553.STARS.Report].tCoolHeadOut

,[HDCW.553.STARS.Report].tCoolEngOut

,[HDCW.553.STARS.Report].tOilEngSump

...

Thanks for the response.

Didn't realise you could use Case like that and I can see that working but that's a lot of Case statements for the large number of columns...