How do I copy a Report and point it to its Copied Query

[Russellh]

So I have this killer report that took me hours to set up. I run it daily and it is great.
I now need to filter it slightly for 1 specific user. So what I did was I copied the query and renamed it. I added the filter I needed. But I don't want to have to re-create the report. Even though I know what I need it will take quite a bit of time to recreate it.



Is there a better way? Can I copy the report (using the same query) but add the filter on the report side?

[June7]

Manage the filter with info from a form. Many ways to accomplish. Do you have a login procedure? Do you have a table of Users? Even if you don't have a login procedure, can have a table of users with info specific for each user. The user can be identified by their network login then look up the user on the table to determine specific requirement. Use VBA code to build filter criteria.

If {condition based on UserID or some other parameter from users table} Then
strFilter = "this criteria"
Else
strFilter = "this other criteria"
End If
DoCmd.OpenReport "report name", , , strFilter

[Russellh]

It isn't a real necessity to have user controls and such. I'm going to copy the query and give it to the user to run at his will.
I have a query that pulls all service orders that didn't auto process.
I built a report off this query that makes it all pretty for users to look at and process the SO's manually.
I copied that query and in design view I added "*shastap*" under the FSR Criteria so that the same query would now just pull SO's for that user.
I need to now copy the report so that I don't have to rebuild the thing from scratch. But simply copying the Report points to the original query which I can't modify. If I do modify it has to be modified everytime it is ran for all open orders and then again to show his open orders.
I was hoping there was a process to accomplish this without rebuilding a report off of the new copied query.

[Russellh]

I was able to just change the Record Source of the new report to the name of the new query. Since everything was identical (except I added criteria to one of the columns) it worked like a charm!!

I still think there is a better "best practice" for doing this as this method could be a maintenance nightmare if you did it alot.

[June7]

I already described alternative that did not require copying the query or the report.