Query Studio

You can define conditional styles to highlight key information in a report. You can use conditional styles with numeric data, text data, and date values.

For example, use conditional styles to highlight all revenue greater than five million in green and all revenue less than one million in red.

To Highlight Key Information:

1. Open the Reports application.
2. On the Tab Toolbar, click Open Query Studio.
   The Query Studio page opens. The query items you can use are listed in the left pane.
   Note:The link is visible only if you are licensed as a Query Studio or Report Studio Author.
3. Click the report item for which you want to define conditional styles.
4. From the Change Layout menu, click Define Conditional Styles.
5. If the report item is a measure or date, do the following:
6. For a measure, in the New value box, type the value that you want and click Insert.
   The value appears under the Range column, and two ranges  are created.
7. For a date, click Select a date and time and specify the date and time you want.
   The date appears under the Range column, and two ranges are created.
8. For each range, under Style, click one of the predefined styles that you want to apply to the range, or click the edit style button  and create your own style.
   Tip: You can modify the predefined styles.
9. Repeat to add other values.
   Tip: Under Style, pause the pointer over each bracket to see the condition produced for each range.
10. If you want to move a value above or below a threshold, click the arrow button  next to the value.
    For example, if the highest value you insert is five million, and the next highest value is one million, the condition created for the five million value is Greater than one million and less than or equal to five million. Moving the five million value above the threshold will produce the condition Greater than or equal to five million.

5. If the report item is text, do the following:
6. If you want to select individual values, click Select values and click the values you want.
7. If you want to define a range, click Define a range, and in the From and To boxes, type the values you want to use in the range.
8. For each value or range, under Style, click one of the predefined styles that you want to apply, or click the edit style button  and create your own style.
9. Specify the style to apply to remaining values by clicking one of the predefined styles beside Remaining values (include future values).

6. Click OK.

Related Topics:

• Changing the Appearance of Query Studio Reports—Ways to change report appearance in Query Studio.
• Changing the Title—Changing the title in Query Studio.
• Formatting Borders—Formatting borders in Query Studio.
• Formatting Text and Data—Formatting text and data in Query Studio.
• Swapping Rows and Columns—How to swap the rows and columns in a crosstab report.

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved