| Example 1 - Concatenation
You have a report that contains a prompt. When you run this report, you want the Report Title to be updated with the value selected when using the prompt. This example will only work when the Prompt used contains ONLY ONE value (eg when the “Equal to” or “Different from” operands are used). Answer
This is done by combining text and an object in the Report Title cell (concatenation). Solution
We write a formula (using the Formula Editor button) to combine the text and the object.
- Click on the cell (in this example, the Report Title cell).
- Click on the Formula Editor button in the toolbar, which will open the Formula Editor window
- Insert the formula “Text”&Max[object]
- See the example below, where Permanent Country is the object used in the title
This will update the heading each time the query is run
Example 2 (easy) – Inserting a Special Field “Query Prompt”
You have a report that contains a prompt. When you run this report, you want the Report Title to be updated with the value, or values, selected when using the prompt. Answer
This can be done by inserting a new cell near to the Report Title cell. Solution
- Click on the cell (in this example, the Report Title cell). Change text as required.
- Insert a Special Field – Query Prompt next to, or underneath the Report Title cell.
- An example is shown below. With some formatting to remove the borders, this would work well
Example 3 (a bit more complex!) – Concatenation Inserting a Special Field “Query Prompt”
You have a report that contains a prompt. When you run this report, you want the Report Title to be updated with the value, or values, selected when using the prompt. Answer
This can be done by combining text and an object in the Report Title cell (concatenation). Solution
We write a formula (using the Formula Editor button) to combine the text and the object.
- Click on the cell (in this example, the Report Title cell).
- Insert a Special Field – Query Prompt
- Click on the Formula Editor button in the toolbar, which will open the Formula Editor window
- Insert the formula (utilising the Query Prompt as inserted) “Text”& ="Students from "&UserResponse ("Query 1 with example used" , "prompt used")
- This is how the title will look
|