Component Solution Services REC02F Uživatelský manuál stáhnout pdf (Strana 50)

Tips Recipes Brio 2002

Section Type: Pivot section

Tip Name: Adding symbolic annotations to a Pivot

Purpose / Use: Sometimes, you want your users to focus on an item by tagging it with a

marker or symbol.

Sample File: Pivot annotations.bqy

Steps to Produce: Use a combination of a simple Computed Item along with some creative

use of fonts.

1) Build your pivot as usual.

2) Add a new Computed Item named “Flag” using the following formula:

if ( ASP <= 100 ) { 'A' } else { '' }

You need the else clause to avoid seeing “N/A” displayed in the pivot where the

comparison doesn’t hold true.

3) Now, invoke the Character Map windows application (Start | Programs | Accessories |

Character Map). In the upper left, select an appropriate symbol font. In this example,

Wingdings 3 was used.

4) Find the symbolic character you want to appear in your pivot. Click on it and hit the

“Select” and “Copy” buttons to copy the symbol to your clipboard. Close the Character

Map application.

5) Back in your pivot, right-click on the “Flag” column and select “Modify” from the speed

menu. Highlight only the A in the formula and then press Ctrl-V to paste the selected

symbol into your formula. Close the formula box.

6) With the “Flag” column still selected, change the font to match the one you used in the

Character Map application. In this example, select Wingdings 3.

7) You can also use the Spotlighter on this strange character. With the “Flag” column still

selected, simply invoke the Spotlighter (Format | Spotlighter). Set the desired display

colors and use Ctrl-V to paste the selected symbol into the Value box.

1 2 ... 45 46 47 48 49 50 51 52 53 54 55 ... 77 78

Žádné komentáře

Component Solution Services REC02F Uživatelský manuál Strana 50