I have a standard set of data that I always want out of a report, however it could be based on a query of any of the values. Is it possible to set it up so I double click on a report and it would let me select the query I want to use. Or if not I could set up a template report, copy it and rename it for the most popular queries then change the query attached to that report. I’m open to any suggestions, books, tutorials, or better practices.
+1 for really good information. Some I knew but it is great to see it expanded and explained. Some I’m not sure I understand until I play around a little. It seems a little different that what I was asking, in other words I have 2 querries that run fine. I have a report that displays what I want however when I run the report it was set up to use querry A and I prefer that it use query B, Is there a way to force the report to use query B? Or is this a totally invalid question?