Make Better Decisions

QMetrix provides enterprise budgeting & forecasting, analytics and data management services.
By leveraging proven technology through fixed price engagements, QMetrix removes the risk, whilst your business reaps the reward.

Your journey to better insights, starts here

CONTACT US

By default when you create a list report or graph in Report Studio it calls the query ‘Query 1’. Whilst this is not confusing when you have only the one query, it can become difficult to find what you are looking for when there are multiple queries and/or prompt queries.

So a good habit to get into is to give each of the queries a name that has some meaning.

For example if you have a report that has the following:

  • List Report – for Quantity
  • Graph – for Revenue
  • Prompts for Region and Sales Person

You might name your queries as follows:

You will notice that the prompt queries have ‘p_’ at the beginning. Not only does this distinguish the prompt queries from the queries that are being used in lists or charts, but it allows you to call another query say ‘Region’ if you are reporting on this separately.

So how do you rename the Query?

In Report Studio, click on the Query Explorer window

And a Query Explorer pane will appear. Click on the Queries folder


Then single click on the Query that you want to rename. You will notice that the ‘Properties – Query’ pane now appears:

Scroll down, and you will see the name of the Query is ‘Query 1’.

Click on the Query 1, and type in the new name and hit Enter for it to accept the new name. Repeat steps for all queries.