Component Solution Services REC02F Manual de usuario descargar pdf (Pagina 66)

Tips Recipes Brio 2002

Section Type: Report section

Tip Name: Full-Row Spotlighting

Purpose / Use: To highlight an entire row of data when a particular field item is out of

scope.

Sample File: Full row spotlighting.bqy

Steps to Produce: Build a field-object based report that is formatted to look like a table

report, add a second copy of the spotlighting field and set it as a full-row

background. (Requires Brio Intelligence v6.1.0 or higher.)

1. Build your query as normal and process it to fetch a representative data sample.

2. Insert a new Report section, select the default table object and delete it. For ease of design,

you may want to display the report’s section boundaries in the report by selecting the

Report | Section Boundaries menu selection.

3. Add any grouping fields you want to use into the Report Groups area of the Outliner.

4. In your Results section, add a computed item named “One” using a formula of 1. Add this

field as the lowest report group (so far), and then delete the display of this field from the

report group’s header.

5. Select a field to be the “group-controlling field”. This is usually the left-most field in your

report “table”. In this example, the controlling field is the “Product Category”. Add this

field into the Report Groups area of the Outliner as the last group field. Delete the display

of this group-controlling field from the report group header.

6. Drag each “table” field into the group-controlling field’s report group header and format as

desired. Your report should look like this so far:

1 2 ... 61 62 63 64 65 66 67 68 69 70 71 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 66