In this section: |
To make your HTML, PDF, and PostScript reports more powerful, you can insert visual representations of selected data directly into the report output. These visual representations are in the form of vertical or horizontal bar graphs that make relationships and trends among data more obvious.
How to: Reference: |
You can apply data visualization bar graphs to columns in a report from Report Painter, and define triggering conditions that determine when those bar graphs will be displayed and how they will look.
Tip: If you set custom measurements or color and then decide you want the default values, you can reset them by clicking the Default Values button. If you wish to apply different colors to bar graphs to reflect different conditions, click the Conditional Styling button and click New to open the Edit Condition dialog box.
The report opens in the browser with bar graphs inserted.
Tip: To remove data visualization bar graphs from your report, turn off the check box next to Visualize in the Data Visualization dialog box.
You can assign a style (color) to data visualization bar graphs based on conditional statements you define. In this example, you use the DIFFERENCE column to highlight those bar graphs showing gains of $100,000 or more.
Your edited condition is added to the Condition list in the Condition List dialog box.
The new condition is added to the Condition list in the Data Visualization Conditional Styling dialog box.
When you run the report, your new condition takes effect, showing where the sales budget was exceeded by $100,000 or greater as a lime green bar graph, as shown in the following image. (If your report is in black and white, the lime green color appears as a lighter shade of gray.)
You use the dialog box shown in the following image to define the data visualization bar graphs that appear in your report.
If you are setting conditions to control the display of bar graphs, you use the Data Visualization Conditional Styling dialog box instead of this one, as shown in the following image.
The Data Visualization dialog box contains the following fields or options:
Initiates the Data Visualization feature.
Specifies the color of the bar graphs. Select a color from the drop-down list. Black is used as the default color.
The color option is the default for HTML, PDF, and PS formats.
Specifies the shading patterns for bar graphs. Select a shading pattern from the drop-down list.
This option is only available for PDF and PS formats to make graphs in black and white reports more readable. If the report format is HTML, the Pattern option button is inactive because the shading option is only available for PDF and PS formats.
Specifies how the graph looks. Select a look from the drop-down list.
Note: Graphlook Gauge or Quality do not support negative values. Use Bar Graphs instead.
Specifies the relative bar graph scaling for multiple report columns under a common Across sort field to which you have applied data visualization.
Note: This option only appears when applied to the entire report.
Choose one of the following options from the Scale drop-down list:
Specifies that each vertical bar graph be scaled based on the minimum and maximum values of the entire set of values compiled from each Across column to which you have applied data visualization bar graphs.
Specifies that each vertical bar graph be scaled based on the distinct minimum and maximum values for each Across column to which you have applied data visualization bar graphs.
Specifies the length of the longest bar graph.
Default. The default length of 60 pixels is used for a vertical bar graph and 80 pixels for a horizontal bar graph.
Custom. Sets the value for displaying the vertical or horizontal bar graph for the maximum data value in the associated report column. This value must be a positive number.
This value is initially expressed in the current windows measurement units (inches, centimeters), then converted into the corresponding number of pixels.
Specifies the width of the bar graphs in a report.
Default. This value is preset based on the current font size.
Custom. Sets the value for displaying the width of the bar graphs in a report. This value must be a positive number.
This value is initially expressed in the current windows measurement units (inches, centimeters), then converted into the corresponding number of pixels.
Resets all defaults.
Opens the Data Visualization Conditional Styling dialog box where you can define conditions and colors for bar graphs.
The following image shows the Data Visualization Conditional Styling dialog box, which you use to define the colors of bar graphs based on conditions you define.
Opens the Edit Condition dialog box. For instructions on how to define conditions, see Defining a Conditional Report Style.
Note: In Report Painter, when viewing conditions from the Data Visualization Conditional Styling dialog box, any existing conditions for the report components are not visible. The Data Visualization Conditional Styling dialog box only shows conditions for the data visualization.
Specifies the colors of the bar graphs. Select a color from the drop down list. Black is used as the default color. You can select as many colors as you need to show different conditions.
Specifies the shading patterns for bar graphs. Select a shading pattern from the drop-down list.
This option is only available for PDF and PS formats to make graphs in black and white reports more readable. If the report format is HTML, the Pattern option button is inactive because the shading option is only available for PDF and PS formats.
Specifies how the graph looks. Select a look from the drop-down list.
Specifies the length of the longest bar graph.
The default length of 60 pixels is used for a vertical bar graph and 80 pixels for a horizontal bar graph.
Sets the value for displaying the vertical or horizontal bar graph for the maximum data value in the associated report column. This value must be a positive number.
This value is initially expressed in the current Windows measurement units (inches, centimeters), then converted into the corresponding number of pixels.
Specifies the width of the bar graphs in a report.
This value is preset based on the current font size.
Sets the value for displaying the width of the bar graphs in a report. This value must be a positive number.
This value is initially expressed in the current Windows measurement units (inches, centimeters), then converted into the corresponding number of pixels.
Resets all defaults.
WebFOCUS |