Using Power Painter Components

Procedure: How to Insert a Report Component in Power Painter

Select the Report button from the Toolbox palette and drag it onto the canvas.
or

Select Report from the Insert menu. The component is automatically inserted into the canvas.

The report appears on the canvas.
From the Data Sources palette, select fields and drag them to the report object.
As fields are dragged over the report, sorting folders are available which enable you to sort the fields as a By, Across, Sum, or Coordinated report field.

Note: Coordinated fields contain a common sort field for multiple reports and graphs and are burst into separate page layouts. Each value for the coordinated sort field displays on a separate page.
To edit or delete these field selections, open the Query palette or the Query Popup.
- From the View menu, select Query from the Palettes submenu.
- Select a report, right-click and select Query Popup from the context menu.
  Double-click the report to bring up the Query Popup.
The sort folders appear with the selected fields in the report. You may drag and drop the fields to different sort folders, delete fields, and add and edit compute fields from this dialog box. You may also select Print to display all the values of the selected fields found in the data source and Sum to sum the values of a numeric field.
You may select a field from the Query palette to further customize the field properties in the report.
You may select the report to view or edit the properties for the report in the Report properties palette.
Select Save from the File menu to save the report.

Reference: Report Properties

When a report object is selected, the following properties are available from the Report properties palette.

Column data styling

Click the browse (...) button to open the font dialog box. Select the font, style, size, text and multiple background colors for the data in the report.

Column title styling

Click the browse (...) button to open the font dialog box. Select the font, style, size, text and background color for the column titles in the report.

Column totals

Shows columns totals in the report. No is selected by default. To show column totals, use the drop-down list to select Yes.

Font

Shows the default global font for the report.

Footing

Adds a footing to the report. Click the browse (...) button to open the Footing dialog box.

You may use the Footings toolbar to customize and modify the font, style, size, text color, background color, and so on.
You may use the Data Sources area to add fields from the Master File as your footing.

Heading

Adds a heading to the report. Click the browse (...) button to open the Heading dialog box.

You may use the Headings toolbar to customize and modify the font, style, size, text color, background color, and so on.
You may use the Data Sources area to add fields from the Master File as your heading.

Height

Indicates the height of the report object. You may type in a different value to change the height or manually drag the report object on the canvas.

Minimize Column Width

Shrinks the column width to fit the widest value in the report. Yes is selected by default. Select No from the drop-down list to expand the all the columns.

Position: Left

Indicates the starting position for the left edge of the report. You may type in a different value to change the position or manually drag the report on the canvas.

Position: Top

Indicates the starting position for the top edge of the report. You may type in a different value to change the position or manually drag the report on the canvas.

Record Limit

Limits the number of records used to retrieve data at run time.

Row totals

Shows row totals in the report. No is selected by default. To show row totals, use the drop-down list to select Yes.

Sizing and Overflow

Determines the vertical sizing of the report by setting fixed or flowing overflow. For more information about sizing and overflow, see Setting Overflow Options in Power Painter.

Stylesheet: reference

Click the browse (...) button to select an external stylesheet. The report references the selected stylesheet which controls the global level styling of the report. You can choose from a predefined set of stylesheets, or a stylesheet from the Import directory.

Width

Indicates the width of the report object. You may type in a different value to change the width or manually drag the report object on the canvas.

Top of page

Reference: Right-click on Report Properties

When you right-click a report object, the following options are available from the dialog box that appears:

Query: Opens the query dialog box.
Size to Fit: Resizes the report as fields are added and deleted.
Delete: Deletes the report.
Properties: Displays the Report properties dialog box.

Top of page

Reference: Field Properties

When a report is selected, the following properties are available from the Field properties palette.

Note: The field properties available vary depending on the type of sort field selected.

Visible

Controls whether a field appears in the report graph, or is hidden. If Visible is set to No, the column is hidden, but is still used in calculations.

Title

Enables you to enter a title for the field in the report graph.

Sorting

Sorts the column data in ascending or descending order.

Page break

Start a new page when the value of a selected sort field changes.

Subtotal

Enables you to display subtotals for numeric data whenever the value of the selected sort (By) field changes. By default, numeric field values are summed and displayed as subtotals. Additionally, you can display other summary values by applying prefix operators to numeric fields, including computed fields, by clicking the browse (...) button to open the Sub Total Options dialog box. For more information, see How to Display Subtotals and Other Summary Values Using Prefix Operators.

Underline

Includes a horizontal line across the width of a report after the value of the selected sort field changes.

Include missing instances

Displays missing instances of data for related fields in the report.

Drill down

Enables you to supply information to another report by using a hyperlink, procedure, or parameter.

Conditional Styling

Enables you to assign a conditional style to a report element. Conditional styling enables you to define conditions that determine when to apply particular fonts, text style, and so on. For more information about conditional styling, see How to Create Conditional Styling Rules.

Subheading

Adds a subheading to the report at sort breaks. Click the browse (...) button to open the subheading dialog box.

You may use the subheadings toolbar to customize and modify the font, style, size, text color, background color, and so on.
You may use the Data Sources area to add fields from the Master File as your subheading.

Subfooting

Adds a subfooting to the report at sort breaks. Click the browse (...) button to open the subfooting dialog box.

You may use the Footings toolbar to customize and modify the font, style, size, text color, background color, and so on.
You may use the Data Sources area to add fields from the Master File as your footing.

Ranking

Includes a column with a numeric rank for each row in a vertically sorted report.

Ranking limit

If specified, this value limits the number of ranked values to be retrieved.

Ranking title

Displays a default column title as RANK with the sort field. You may type in a unique title name for the ranked field.

Ranking title font

Click the browse (...) button to open the font dialog box. Select the font, style, and size for the ranking title.

Ranking data font

Click the browse (...) button to open the font dialog box. Select the font, style, and size for the ranking data.

Title font

Click the browse (...) button to open the font dialog box. Select the font, style, size, text and multiple background colors for the column title.

Data font

Click the browse (...) button to open the font dialog box. Select the font, style, size, text and multiple background colors for the data column.

Table of Contents

You may generate a Table of Contents (TOC) page which shows a summary of the document's contents, along with page numbers, and can be printed with the document. The entries in the Table of Contents enable you to easily navigate to a particular section while viewing the document.

Note: The Table of Contents only appears as a field option if you are using a coordinated report.

Top of page

Procedure: How to Insert a Graph Component in Power Painter

Select the Graph button from the Toolbox palette and drag it onto the canvas.
or

Select Graph from the Insert menu.

The New Chart dialog box appears.
Select a chart type and click Finish.
The graph appears on the canvas.

Tip: To view the New Chart dialog box after the graph has been added to the canvas, select Show Chart Types from the right-click context menu of the graph.
From the Data Sources palette, select fields and drag them to the graph object.
As fields are dragged over the graph, sorting folders are available which enable you to sort the fields as a X and Y axis fields.

Note: Coordinated fields contain a common sort field for multiple reports and graphs and are burst into separate page layouts. Each value for the coordinated sort field displays on a separate page.
To edit or delete these field selections, open the Query palette or the Query Popup.
- From the View menu, select Query from the Palettes submenu.
- Select a graph, right-click and select Query Popup from the context menu.
  or
  
  Double-click the graph to bring up the Query Popup.
The sort folders appear with the selected fields in the graph. You may drag and drop the fields to different sort folders, delete fields, or add and edit compute fields from this dialog box. You may also select Print to display all the values of the selected fields found in the data source and Sum to sum the values of a numeric field.
You may select a field from the Query palette to further customize the field properties in the graph.
You may select the graph to view or edit the properties for the graph in the Chart properties palette.
From the View menu, select Chart Editor from the Palettes submenu to further customize the chart titles, legends, axis, and so on.
Select Save from the File menu to save the graph.

Top of page

Reference: Chart Properties

For most chart types, when a graph object is selected, the following properties are available from the Chart properties palette. Note: Some chart types with unique properties, such as pie and three dimensional charts, have specialized properties not shown below.

Apply template: Select from any of the available templates to apply a predefined color scheme to change the appearance of your chart.
Chart footnote: Type the desired footnote text.
Chart subtitle: Type the desired subtitle text.
Chart title: Type the desired title text.
Crosstab Mode: Select from Yes or No. Displays the Series-legend icon and enables secondary X-axis functionality.
Fit to Chart area: Select from Yes or No to turn auto placement on or off.
Height: Indicates the height of the graph object. You may type in a different value to change the height or manually drag the graph object on the canvas.
Left: Indicates the starting position for the left edge of the graph. You may type in a different value to change the position or manually drag the graph on the canvas.
Legend position: Select the desired option for positioning the chart’s legend.
Record limit: Type a number to edit the record limit value.
Show data values: Select from Yes or No to display or not display data values on the graph.
Top: Indicates the starting position for the top edge of the graph. You may type in a different value to change the position or manually drag the graph on the canvas.
Use 3D effect: Select from Yes or No to apply or not apply a three dimensional effect on the graph.
Width: Indicates the width of the graph object. You may type in a different value to change the width or manually drag the graph object on the canvas.
X-axis Major grid: Select from Yes or No to display or not display X-axis major gridlines on the graph.
Y-axis Major grid: Select from Yes or No to display or not display Y-axis major gridlines on the graph.

Top of page

Reference: Chart Editor Dialog Box

When the Chart Editor dialog box is open in Power Painter, properties are available for each object in the chart editor. The following image is an example of the Chart Editor and the properties palette in Power Painter.

For details about the chart editor and its object properties, see the Creating Graphs With Advanced Graph Assistant chapter in the WebFOCUS Managed Reporting Developer's Manual.

Top of page

Procedure: How to Insert a Text Component in Power Painter

Select the Text button from the Toolbox palette and drag it onto the canvas.
or

Select Text from the Insert menu.

The Text Component dialog box appears on the canvas.
Manually type text into the text box area to use the default font.
Click the Font Properties button to open the Font dialog box.

You may customize the font, style, size, and text color of the text.
Click OK to close the Font dialog box.
Click OK to close the Text component dialog box.
The text is inserted into the canvas.
You may select the text component to view or edit the properties for the text in the Text properties palette.
Select Save from the File menu to save the text.

Top of page

Reference: Text Properties

When a text object is selected, the following properties are available from the Text properties palette.

Height: Indicates the height of the text object. You may type in a different value to change the height or manually drag the text object on the canvas.
Position: Left: Indicates the starting position for the left edge of the text.
Position: Top: Indicates the starting position for the top edge of the text.
Width: Indicates the width of the text object. You may type in a different value to change the width or manually drag the text object on the canvas.

Top of page

Procedure: How to Insert an Image Component in Power Painter

Select the Image button from the Toolbox palette and drag it onto the canvas.
or

Select Image from the Insert menu.

The Open dialog box appears on the canvas.
Select from the list of image files available.
Note: The Reporting Server is the default location for all stored images.
Click OK to insert the image. The image is added to the canvas, and the size defaults to the size of the image.
You may select the image component to view or edit the properties for the image in the Image properties palette.
Select Save from the File menu to save the image.

Top of page

Reference: Right-click Image Properties

When you right-click an image, the following options are available from the dialog box that appears:

Reset to original size: Resets the image to the original size.
Deletes: Deletes the image.
Properties: Opens the Image properties dialog box.

Note: Hover over an image to view the file name.

Top of page

Reference: Image Properties

When an image object is selected, the following properties are available from the Image properties palette.

Height: Indicates the height of the image object. You may type in a different value to change the height or manually drag the image object on the canvas.
Position: Left: Indicates the starting position for the left edge of the image.
Position: Top: Indicates the starting position for the top edge of the image.
Width: Indicates the width of the image object. You may type in a different value to change the width or manually drag the image object on the canvas.

Top of page

Procedure: How to Insert a Line Component in Power Painter

Select the Line button from the Toolbox palette and drag it onto the canvas.
or

Select Line from the Insert menu.

The line object is added to the canvas as a positioned horizontal line.

Note: To insert a vertical line, use the properties palette to change the orientation to vertical.
You may select the line component to view or edit the properties for the line in the Line properties palette.
Select Save from the File menu to save the line.

Top of page

Reference: Line Properties

When a line object is selected, the following properties are available from the Line properties palette.

Color: Sets the color of the line. Click in the color value field to open the color dialog box.
Height: Indicates the height of the line object. You may type in a different value to change the height or manually drag the line object on the canvas.
Orientation: Indicates the horizontal or vertical orientation of the line on the canvas.
Position: Left: Indicates the starting position for the left edge of the line.
Style: Sets the style of the line. Use the drop-down list to solid, dotted, dashed, and so on.
Weight: Sets the thickness of the line to light, medium, or heavy.
Width: Indicates the width of the line object. You may type in a different value to change the width or manually drag the line object on the canvas.

Top of page

Procedure: How to Display Subtotals and Other Summary Values Using Prefix Operators

The Subtotal property in the Field Properties palette enables you to display subtotals, and other summary values using prefix operators, for any or all of the numeric fields, including computed fields, in a report query. From the Field Properties dialog, when you click the browse (...) button to the right of the Subtotals property, the Sub Total Options dialog box opens.

Select the Sub Totals option to replace the default setting of None.
If you are using computed fields, select the Recomputed Sub Totals option instead.

Numeric field values are summed and displayed as subtotals in the report by default. To display summary values other than the default subtotals, select prefix operators using the drop-down lists in the Prefix area that are adjacent to each of the selections in the Columns area. Note that the Sum prefix produces the same subtotal results as not selecting a prefix operator.

All of the available prefix operators are listed and described in the following table:

Prefix	Description	Displayed in Prefix List
SUM.	Compute the sum of values	Sum
ASQ.	Compute the average sum of squares	Average Square
AVE.	Compute the average value	Average
CNT.	Count the items	Count
FST.	Select the first value only	Show first in group
LST.	Select the last value only	Show last in group
MAX.	Select the maximum value only	Maximum
MIN.	Select the minimum value only	Minimum

To display all numeric field values as subtotals or other summary values in the report, select the Apply totals to all columns check box in the Columns area.
To display subtotals or other summary values for a subset of the numeric fields in the report, make sure the Apply totals to all columns check box is de-selected, then select check boxes for the individual numeric fields in the Columns area of the Subtotal tab.
When Apply totals to all columns is selected, options for all individual fields in the Columns area are inactive by default.
To modify the default subtotal title, which is set to *TOTAL, type the desired text you want to display as the title for all subtotals and any other selected summary values in the Current Subtotal Text field.
To hide subtotals for sort fields that have only a single value, select the Suppress for single lines check box.

The following image shows the Sub Total Options dialog box: