Using prompt and promptmany macros in query subject

This recipe will show you that macros can be used with standard query subjects as well.

Getting ready

Create a simple list report based on GO Sales Data Warehouse (Query) package. Insert Product line, Product name, Product color, and Product size as the columns.

How to do it...

1. Go to Query Explorer and open the query used by list.

2. Add a detail filter with following definition:

   [Product line] = #prompt('ProductLine')#

3. Add another detail filter as follows:

   [Product name] in #promptmany('Product')#

4. Run the report to test it. You will see two mandatory prompts. The one for Product line will let you enter one value. Whereas the other one will be on product and it will allow you to enter multiple values.

How it works...

This is the same Prompt() macro which we used in prior recipes with native SQLs. As you can see, macros can be used in standard query subjects. You can utilize them in filters, data items, and slicers.

The strength of this feature is seen...