Working with several queries
When working with several queries, it is recommended to work with conventions.
First of all, we would like to give a meaningful name to each query. This is important for several reasons, as follows:
When the report consumes several queries, it is easier to know which query should be edited.
Reports travel through time and users. They are changed over time and can lose track of their initial purpose. Working with conventions will keep the report as clear as possible.
Theoretically, when running a report that is a combination of several queries, one or more queries can fail to retrieve results. By giving each query a name, it would be easier to identify which query is the problematic one. This is why it is recommended to not give generic names such as
query 1,query 2, and so on.
How to do it...
We will be able to edit the query by right-clicking on the Query tab, as shown in the following screenshot:
The Rename query pane will pop up and we will be able to give the query...
