Creating Precision Reports
The Precision Report feature gives you an additional set of tools that make it easy to control the precise placement of objects and data in the report output. For example, with a precision report, you can quickly create a layout that is perfectly aligned for a preprinted form (such as a Bill of Sale or a tax form) and that automatically breaks out one record per report page.
You can access the Precision Report canvas by converting an existing report or by creating a new precision report.
Access the Precision Report Canvas By Converting an Existing Report
- Procedure
- Open the procedure (.fex file) for a
selected report. To do this, you may use one of the following methods:
- On the Home tab, in the Content group, click Report. The Report Wizard opens.
- In the Environments Tree panel, navigate to the desired folder and double-click the report.
- If the selected procedure was created with the Report
canvas, it will automatically open in the Report canvas.
If the selected procedure was not created with the Report canvas, it will automatically open in the Procedure Viewer. In this case, double-click a report component to open it in the Report canvas.
- On the Report tab, in the Report group, click Precision Report.
A style warning message appears, indicating that the report will be converted to a precision report.
- Click Yes to convert the report
and open it in the Precision Report canvas. The next time the report
is opened, the Precision Report canvas will automatically be active.
Similar to the Object Inspector in the Report canvas, the Precision Report canvas includes a window containing tabs used for creating and building Precision Reports. This window has the Fields, Sort Groups, Properties, and Columns tabs found in the Object Inspector, but also includes the Layers tab and Navigate tab, which are unique to the Precision Report canvas.
By default, the report output is PDF. To change the output format, on the Format tab, in the Output Types group, click Output Format. In the drop-down menu that appears, point to Styled report formats, and click the desired output.
You may edit the report by changing the alignment and position of the objects in the report.
Usage Notes for Converting Existing Reports to Precision Reports
The following conditions apply when converting existing reports to precision reports:
- If you are converting a report component that was created using
the Document canvas and the output format is not supported by the
precision reports feature, the following message displays:
Your report is using a locked format that is not supported by Precision Reports.
In this case, you may want to create a new precision report to replicate the original, using a supported output format.
- The existing report heading and report footing will not convert to the precision report. You can create them in the Precision Report canvas.
- The subheading and subfooting will convert to the precision report, including the alignment grid options set in the Report canvas. You can edit them in the Data Matrix layer of the Precision Report canvas.
- Reports with images, parameters, and drill downs will convert to the precision report, but you cannot edit them in the Precision Report canvas.
Access the Precision Report Canvas for a New Report
- Procedure
- To access the Precision Report canvas
for a new report, do one of the following:
- On the Home tab, in the Content group, click Report.
- In the Environments Tree panel, right-click the desired folder, point to New, and click Report.
The Report Wizard opens.
- Navigate to the desired folder, choose a data source,
and click Finish. For more information on
the Report Wizard, see Launching the Report Wizard.
The Report canvas opens.
- On the Report tab, in the Report group, click Precision Report.
A style warning message appears, indicating that the report will be converted to a precision report. Click Yes to close the message and open the Precision Report canvas.
Accessing Precision Report Components With the Precision Report Canvas Tools Tab
The Precision Report canvas Tools tab contains commands that provide quick access to commonly performed functions. This tab is only available when creating Precision Reports. The availability of the commands is context-sensitive to the object that is highlighted in the canvas.
The Tools tab contains the Objects and Default Style groups, as shown in the following image.
Selecting and Adding Objects in a Precision Report Using the Objects Group
The Objects group contains commands to select and add objects to precision reports, as shown in the following image.
The commands are:
Allows you to select (single-click) or edit (double-click) an object.
Allows you to add a box to the Precision Report canvas. When
this command is active, the pointer becomes an arrow with a box 
. Click the canvas to add a box.
You can also drag the pointer on the canvas to create a box in the
size that you want.
When you add a box, the Default Style group on the Tools tab becomes active with options to set the pen size, line style, fill color, and line color.
Allows you to add a line to the Precision Report canvas.
When this command is active, the pointer becomes an arrow over a
line segment 
. Drag the pointer on the canvas
to create a line and adjust it to the size that you want.
When you add a line, the Default Style group on the Tools tab becomes active with options to set the pen size, line style, fill color, and line color.
Allows you to add an image to the Precision Report canvas.
When this command is active, the pointer becomes an arrow over a
flower 
. Click the canvas or drag the
pointer on the canvas to create a box in the size that you want.
The Open File dialog box opens. Select the desired image and click OK.
Allows you to add text to the Precision Report canvas. When
this command is active, the pointer becomes an arrow over a letter
T 
. Click the canvas to add a text
box. You can also drag the pointer on the canvas to create a text
box in the size that you want.
When you add text, the Default Style group on the Tools tab becomes active with options to set the font, size, color, and formatting.
Customizing Objects in a Precision Report Using the Default Style Group
The Default Style group contains commands and options to customize the box, line, and text objects added to a precision report. The Default Style group is shown in the following image.
Sets the default pen size for box and line objects.
Sets the default line style for box and line objects. The options are Solid, Dotted, and Dashed.
Sets the default color for box, line, and text box objects.
Sets the default fill color for box and text box objects.
Sets the default font type for text boxes. This option is only available for a text box.
Sets the default font size for text boxes. This option is only available for a text box.
Sets bold font formatting as the default for text boxes. This option is only available for a text box.
Sets italic font formatting as the default for text boxes. This option is only available for a text box.
Sets underline font formatting as the default for text boxes. This option is only available for a text box.
Resets the style settings of the selected object to the default, original style.
Positioning Objects in a Precision Report With the Precision Report Canvas Positioning Tab
The alignment commands on the Positioning tab enable you to select multiple objects in the same layer and easily position them relative to one another.
The availability of the commands is context-sensitive to the objects that are selected in the canvas. You cannot select multiple objects in different layers.
The Positioning tab contains the Positioning, Distribution, Options and Composition groups, as shown in the following image.
Aligning Objects in a Precision Report Using the Positioning Group
The Positioning group contains commands to align the objects on the Precision Report canvas, as shown in the following image.
Aligns the selected object to the left of the last object selected.
Aligns the selected object to the right of the last object selected.
Aligns the selected object to the top edge of the last object selected.
Aligns the selected object to the bottom edge of the last object selected.
Makes two or more objects the same width.
Makes two or more objects the same height.
Makes two or more objects the same size.
Controlling Spacing Between Objects in a Precision Report Using the Distribution Group
The Distribution group contains commands to control the spacing on the Precision Report canvas, as shown in the following image.
Sets the horizontal spacing between three or more selected objects to be the same.
Sets the vertical spacing between three or more selected objects to be the same.
Setting Grid and Ruler Options for a Precision Report Using the Options Group
The Options group contains commands to set grid visibility and ruler options on the Precision Report canvas, as shown in the following image.
Sets grid visibility and snap option.
Sets guide visibility and snap option.
Adding or Removing Compositions in a Precision Report Using the Composition Group
The Composition group contains commands to name, add, or remove compositions on the Precision Report canvas, as shown in the following image.
Displays a drop-down list of available compositions. You can rename composition names.
Adds a composition. The name of the composition is derived by the system (COMP00).
Deletes a composition.
Working With Precision Report Tabs
The Precision Report canvas is characterized by a window containing multiple tabs. Each tab contains tools that enable you to design and create positioned elements for your precision report. The default tabs are:
- Layers. Consists of the Page, Report Heading, Page Header, Data Matrix, Page Footer, and Report Footing layers. For details, see Creating Precision Reports.
- Sort Groups. Displays the sorting method being applied to each column in the Data Matrix layer. For details, see Creating Precision Reports.
- Columns. View and modify the columns in the Data Matrix layer. For details, see Creating Precision Reports.
- Fields. View the fields used in the Data Matrix layer. For details, see Creating Precision Reports.
- Properties. Displays attributes and their editable values, grouped by category. For details, see Creating Precision Reports.
- Navigate. View the entire layout of the Precision Report. For details, see Creating Precision Reports.
These tabs are described in the following sections.
Precision Report Canvas Layers Tab
By default, the Layers tab consists of the Page, Report Heading, Page Header, Data Matrix, Page Footer, and Report Footing layers, as shown in the following image. You can add additional layers as needed.
The Data Matrix layer inserts a placeholder for the reporting data. You can snap objects (boxes, lines, images, text) to the layout.
The following commands are available on the Layers tab:
|
Command |
Definition |
|---|---|
|
|
Shows or hides the selected layer in the Precision Report canvas. |
|
|
Enables or disables styling changes. |
|
|
Enables or disables data changes. |
|
|
Enables or disables all changes. |
|
|
Creates a new layer for the precision report. |
|
|
Deletes the selected object or layer. If a layer is deleted, all objects within it are deleted as well. |
|
|
Moves the selected object up or down in the selected layer. |
Precision Report Canvas Sort Groups Tab
You can view and modify the sorting properties of fields in the Data Matrix from the Sort Groups tab in the Precision Report canvas, as shown in the following image.
The Sort Groups tab displays the sorting method being applied to each column in the Data Matrix layer. You can change the sorting method (for example, from By to Across or from Detail to Sum) by using the right-click context tab. The changes are reflected in the Columns and Sort Groups tabs and in the Data Matrix layer.
You can also use the Sort Groups tab to create multi-verb requests.
Sort Type Icons
The icons in the first column to the left of the field name display the type of sort field. The icons and their meanings are defined in the following table:
|
Icon |
Definition |
|---|---|
|
|
Across field. |
|
|
By field. |
|
|
Sum field. |
|
|
Detail field. |
|
|
For field. |
Precision Report Canvas Columns Tab
You can view and modify the columns in the Data Matrix layer from the Columns tab in the Precision Report canvas, as shown in the following image.
Right-click a column and select Options from the context tab to open the Field Properties dialog box, where you can format and style the column, as well as apply drill down capabilities. Any changes made to the column properties are reflected in the Data Matrix layer.
Precision Report Canvas Fields Tab
You can view the fields used in the Data Matrix layer as a:
- Tree separated by segments (the Field Tree).
- List of fields (the Field List).
- Tree separated by Dimensions (the Dimension Tree).
To change the view, right-click in the Fields tab and choose the view from the shortcut menu.
You can double-click or drag segments or fields from this tab to the Precision Report canvas, where they become report columns.
You can customize how you view the fields list and save your settings. Right-click in the Fields tab and select one of the Save Settings options from the shortcut menu.
You can also search for fields in the fields list. Right-click in the Fields tab and select Find Item from the shortcut menu.
Precision Report Canvas Properties Tab
The Properties tab displays attributes and their editable values, grouped by category, as shown in the following image.
Precision Report Canvas Navigate Tab
You may view the entire layout of the Precision Report in the Navigate tab.
- The slider bar enables you to increase or decrease the zoom percentage of the layout.
- Drag the red box in the Navigate tab to view different elements of the precision report in the layout, as shown in the following image.
Creating Precision Reports Using the Data Matrix Layer
Precision reports are created in the Precision Report canvas by using the Data Matrix layer as the reporting object, and by inserting objects in the other layers as fields.
Build a Report in the Data Matrix Layer
- Procedure
- To access the Precision Report canvas
for a new report, do one of the following:
- On the Home tab, in the Content group, click Report.
- In the Environments Tree panel, right-click the desired folder, point to New, and click Report.
The Report Wizard opens.
- Navigate to the desired folder, choose a data source,
and click Finish. For more information on
the Report Wizard, see Launching the Report Wizard.
The Report canvas opens.
- On the Report tab, in the Report group, click Precision Report.
A style warning message appears, indicating that the report will be converted to a precision report. Click Yes to close the message and open the Precision Report canvas.
- If it is not already highlighted, click REGION under the Data Matrix layer in the Layers tab. The REGION object is displayed as a highlighted placeholder in the Precision Report canvas.
- Double-click the REGION object in the Precision Report canvas. A hand icon displays, indicating that the region is in selection mode.
- Click the Fields tab. Select a field for the report, and drag it into the region. Repeat this for all of the desired fields. You may resize the region placeholder as needed.
- Click Save.
Design the Page Layout for Precision Reports
Once the precision report has been built in the Data Matrix layer, you may design the page layout using the Page layer. Objects you add to the page layer appear on each page of the report at run time. You may add a box, line, or image to the page layer.
You can begin this procedure by opening the report you saved from the previous procedure Creating Precision Reports.
- Procedure
- From the Layers tab, click the Page layer to toggle to edit mode.
- On the Tools tab, in the Objects group, click Add Line.
The pointer changes to an arrow over a line segment
. - Drag the pointer to create a line.
Change the line color and style on the Tools tab, in the Default Style group.
Tip: After the line object has been added to the page layer, you may use the Properties tab to change the appearance of the line. - On the Tools tab, in the Objects group, click Add Image.
The pointer changes to an arrow over a flower
. - Click the canvas or drag the pointer to create a box.
The Open File dialog appears.
- Select the desired image file, such as a company logo,
and click OK.
The image appears on the page. Resize it as needed.
Note: You can click Select Object to toggle off the Add Image.As objects are added to the page layout, they appear under the Page layers.
- Click Save.
When you run the report, the items added to the page layer appear on every page of the report output.
Add Heading or Footing Layers in the Precision Report Layout
Once the precision report has been built in the Data Matrix layer, you may add Heading and Footing objects as placeholders for fields on your form.
You can begin this procedure by opening the report you saved from the previous procedure Creating Precision Reports.
- Procedure
- From the Layers tab, click the Report Footing layer to toggle to edit mode to add an object to the report footing. Similarly, you could select the Report Heading, Page Header, or Page Footer layer.
- On the Tools tab, in the Objects group, click Add Box.
The pointer changes to an arrow over a box
. - Click the canvas or drag the pointer to create a box.
Note: Objects snap to the grid for perfect alignment.
Change the color and style of the box on the Tools tab, in the Default Style group.
Tip: After the box object has been added to the page layer, you may use the Properties tab to change the appearance of the box.As items are added, they appear under the Heading/Footing layers.
- Click Save.
Optionally, you can use the Layers tab to move or delete layer objects.
Add Embedded Fields in the Heading/Footing Text Objects
You may embed fields and variables in your Heading/Footing layers as text objects. The precision report retrieves the value for the field when the report is run.
You can begin this procedure by opening the report you saved from the previous procedure Creating Precision Reports.
- Procedure
- From the Layers tab, click the Report Heading layer to toggle to edit mode to add a text object to the report heading. Similarly, you could select the Page Header, Page Footer, or Report Footing layer.
- On the Tools tab, in the Objects group, click Add Text.
The pointer changes to as an arrow over a letter T
. - Click the canvas or drag your pointer to create a box, indicating where you want the text to appear in the canvas. Type the desired text. Place the cursor at the position in the text where you want to embed the value.
- Double-click a field from the Fields tab in the Precision
Report canvas.
This includes Report Variables, Computed, and Defined fields.
The field is added to the text object as <FIELDNAME.
- Optionally, you may also perform a calculation on a field
value in the text object:
- Highlight <FIELDNAME in the text object.
- Right-click and choose Prefix Operators and
the desired operator from the context tab.
Tip: The list of available operators adjusts to show those that are appropriate for the type of field you select.
Control Spacing Between Wrapped Lines
You can use the Wrap Gap option in a style sheet to control spacing between wrapped lines in PDF and PostScript report output. The Wrap Gap option is available only for an active object of type Data.
You can begin this procedure by opening the report you saved from the previous procedure Creating Precision Reports.
- Procedure
- On the Report tab, in the Style group, click the Report Width button.
- The Width Options dialog box opens.
- From the drop-down menu, click Wrap.
- Click the ON radio button to enable
the Wrap Gap option.
Type the number of inches to leave between wrapped lines and click OK.
- Click Save.
Run Different Compositions for the Precision Report
You may run the precision report with different composition templates. Composition templates enable you to run the same precision report with different attribute values.
This can be beneficial if you need to run a precision report with modifications for internal and external use. For example, you have an internal report that shows your trademark image in the Report Heading Layer. You can create a composition template that hides your trademark image for an external customer.
You can begin this procedure by opening the report you saved from the previous procedure Creating Precision Reports.
- Procedure
- On the Positioning tab, in the Composition group, note that DEFAULT is displayed as the Composition Name.
- To create an additional composition template, click Add Composition. Note the new composition name derived by the system is COMP00. You can rename the composition by typing over the old one in the Composition Name field.
- Select the Properties tab and expand the IMAGE section. For the Visible attribute, change the value to No.
- Click Save.
The composition template is added to the selection list. The template in this example hides the image in the precision report. When the report is run under the DEFAULT template, the image will appear. When it is run under the COMP00 template, the image will not appear.
To delete a composition template, select it from the Composition Name drop-down list and click the Remove Composition command.
Editing a Precision Report to Fit a Form
After you create a precision report, you may need to edit the formatting of it to fit perfectly on a preprinted form. The Properties tab of the Precision Report canvas makes it easy to fine-tune the output to match your form.
Matching Output to a Preprinted Form
The following example shows how to edit a precision report to match a preprinted form.
- Open the desired precision report. On the Format tab, Output Types group, click Output Format. Click DHTML, PDF, or PS (PostScript).
- On the Format tab, Output Types group, click Output Format Options. The Output Format Options dialog box appears.
- Select the option values that will best assist in matching your
form and click OK.
Note: Matching output to your preprinted form is an iterative process that will progress through trial and error.
Click Save.
- Put your preprinted form in your printer and print a single page of output from the precision report. View the results.
- Open the precision report. If you need to adjust the alignment
of data columns, Open the Properties tab and expand the REGION area.
The Position attribute shows four values.
- The first number (192 in the example above) controls the left side of the region box.
- The second number (132 in the example above) controls the top of the region box.
- The third number (588 in the example above) controls the right side of the region box.
- The fourth number (276 in the example above) controls the bottom of the region box.
You can edit the numbers to move the region with great accuracy in matching your form.
In addition to the REGION attribute, you can also fine tune the TEXT attribute as described above.
- Edit the precision report, save it, and print it on your form again until the alignment is correct.