Change report query

[DougKMiles]

Is there a way to change the query a report sources its data from?

I have a report I’ve created that will work well for another query, and rather than rebuilding the report from scratch in the report Wizard, I’d like to just duplicate the report and change the query it refers to. But I cannot find anyway to do that.

Thanks in advance for any tips!

DM

[DougKMiles]

I figured it out.

Open report in edit mode. Open Report navigator. Click to select “Report” – top level of the navigator. That opens the Properties window for the Report. Click on the Data tab. Then under Content there’s a drop down menu where you can select the Query.

dm