DIY Report Designer Practice

Table of Contents

This page is meant to provide a step by step instruction, on how to create a report template within Report Designer. The example report template created for the screen shots below were built off a Daily Observation form with general discrepancy tracking (used in the Form Designer Practice). A form must be created first, prior to creating the report design. Which form fields are added to the report template and where they are positioned is completely configurable.

Additionally, this practice will give step by step instruction on how to create the Activity Discrepancy report template if Discrepancy Tracking is being leveraged.

Creating a Report Template

Step	Instruction	Screenshot
1	Navigate to the Form you wish to create your report template against. Select the Group name the form is associated with. Select the form Name to open up the for in Form Designer.
2	Select Report Designer.
3	Select Add New Report.
4	Provide a Name, Code, and Default Title. Select Create.

A blank report template will be created. The following sections of this practice will provide instruction on populating a report template with report elements and configuring element properties.

We recommend that you save updates to the report template often. Very complex logic and or data sourcing can be built into a report design. If the logic or sourcing does not pass validation, MetaField will throw an error and not allow the report template to be saved. Saving in between changes will ensure that if validation is thrown, you will know the last update you made and correct it.

It is also recommended that after every couple of updates that are made to your report design, navigate to the QC module using a separate tab or window to preview the report. Note that you will need to have the form record entered into the system. This becomes more critical when you apply hide expressions and various properties to fields on your report template..

Adding Elements to a Report Template

Step	Description	Instruction
1	Create the Sections of the Report with section headings	A. In the right hand panel, select the Elements tab. Select Panel (click and hold) and drag the panel element to the body of the report template. B. Repeat step A so there is a panel within a panel. Select Label (click and hold) and drag the label element inside the two panel elements. C. Select the label element that you just moved onto the report template. The outline of the element should be highlighted in blue when it is selected. Select the Properties tab. The text field will default in the text "Content". Delete this text and update it with "General Information". Highlight the text and select the "B" icon in the text editor to make the text bold. Update the font size to "12" and the Text Align to "Center". D. Repeat steps A - C to create sections for "Observation Information", "Remarks" and "Attachments" Remember to select the Save icon often when making updates.
2	create two columns on within general information and add general information form fields within the two column design.	A. Drag a Panel element into the General Information section of the report template, below the panel with the general information label within it. Make sure the panel element you just added is selected (outline highlighted in blue). Select the Properties tab and update the Width property to "50". Keep the units as "%". You will notice that the panel should take up 50% of the space within the panel it was dragged into. B. Repeat step A so there are two columns created in the General Information section of the report.
3	Add form fields into the left column using the drag and drop Method.	A. In the right hand panel, select the Datasets tab. Select a form field (click and hold) and drag the field to the left column of the report template within the General Information section.Note that you can update the order the form fields display in the Datasets tab (alphabetically or form order) in order to make the design process easier. B. Repeat step A for all the form fields you would like to appear in the left column of this section of the report. Note when dragging picklist, multiple choice, or yes/no fields You will be presented with three display options to choose from. Select one of the options and select Create. Note when using the drag and drop method, The panel that gets inserted will have a hide expression added to the properties by default. The hide expression will hide the panel from the report if there is now value for the field on the form record. If you would like the panel to always appear on the report, this hide expression will need to be removed.
4	Add form fields into the right column using the data sourcing Method..