Two ways most likely - one for sure.
One is you could base the report on a query. I mean an actual Query object in the Base file, not a query embedded in the report specification.
You can change the query then before you run the report.
The second way is that you would need to open the report definition, via a macro, in edit mode. Change the settings in the data source property, via the script and execute the report you do not need to save the report before you run it.
hmm- then again you can adjust the record set by using named parameters in the query, a saved query or an embedded query, and OO.o will prompt for new values each time it is run.
Tell you what though since this is about the Report Builder and the original thread is about report wizard how about we start a new thread if you want to continue talking about it?
The Document Foundation member
Apache OpenOffice Incubator podling PPMC member
LibreOffice & OpenOffice.org on Ubuntu 11.04 + Windows XP - 7