Table of Contents | |
---|---|
|
Purpose
...
Table of Contents | |
---|---|
|
Purpose
Report designer allows you to create and design reports for custom configured Activity and Lab Test Forms. First you will need to create a Report Type. Once the Report Type is created, you can start designing your report.
...
Element | Description | |
---|---|---|
Label |
| |
Paragraph |
| |
Panel |
| |
Vertical Table |
| |
Horizontal Table |
| |
Checkbox List |
| |
Image |
| |
Line |
| |
Page Break |
|
...
Setting | Description | ||||
---|---|---|---|---|---|
Report Name |
| ||||
Report Code |
| ||||
Default Title |
| ||||
Alternate Field Title |
| ||||
Alternate QC Title |
| ||||
Allow Alternate Report Title At Run Time |
| ||||
Standard |
| ||||
Digital Signature Configuration |
| ||||
Send Field Reports To |
| ||||
Display File Uploads |
| ||||
Repeat Table Headers |
| ||||
Field Legal Text |
| ||||
QC Legal Text |
| ||||
Allow Field Signature Capture On Field Reports |
| ||||
Report Image |
| ||||
Report Text |
| ||||
Show Report Date In Header |
| ||||
File Name |
| ||||
Description | Format of the reportShow Report Time In Header |
| |||
File Name |
| ||||
Description |
| ||||
Include Description For Associated Reports |
| ||||
Apply Page Break On Every New Record |
| Show In Report Associations | Allows
| ||
Show In Report Associations |
| ||||
Show In QC Draft Report Filter |
| ||||
Show In Delivery Report Filter |
| ||||
Allow Emailing On Finalize |
| ||||
Allow Publishing On Finalize |
| ||||
Allow Override Digital Signature Configuration On Projects |
| ||||
Internal Report |
| ||||
Test List Report |
| ||||
Type |
| ||||
Header And Footer Type |
| ||||
Allow Distinct Header And Footer On Each Record |
| ||||
Custom Paging Placeholder |
| ||||
Include WBS / Cost Summary |
| ||||
Add WBS Fields |
| ||||
Number Of Elements |
|
Placeholders
Both the File Name and Report Description values have dynamic placeholder values that can be implemented. Hover over the information icon next to each field to see the available placeholders. The placeholders are case sensitive and must be placed within brackets {{ }}.
File Name
Dictates the name of the file if a report is downloaded or emailed. Customizing this value can make it easy for clients to better identify a report without having to open the file PDF file.
Placeholder | Description |
---|---|
Office Name | Inserts the office value that is selected when generating a report. |
Report Description | Inserts the 'Report Description' which is can also be configured within the Report Designer. See table below for more information regarding this field. |
Report ID | A number that serves as a unique identifier for a report. No two reports will have the same ID. |
Report Note | Inserts the text value entered in the 'Report Note' field which a user can enter before finalizing a report. |
Report Number | If report numbering is turned on, then the file name will include the report number. |
Report Title | Inserts the 'Default Title' value set within the report designer. |
Report Description
Placeholder | Description |
---|---|
ActlvityDate | For Activity records only, displays the date the activity date found in most activity forms. |
ActivityNumber | For Activity records only, displays the date the activity number identifier found in most activity forms. |
ClientName | The name of the client associated with the project. |
ClientProjectNumber | The ' |
CurrentUser | Display the name of the user generating the report. |
DensityTestDate | For Density tests only, displays the date the test was conducted. |
DensityTestNumber | For Density tests only, displays the test number associated with the density test record. |
FieldActivityDate | For Activity records only, displays the date the Field Activity Date found in some activity forms. |
LabTestDate | For Test records processed through the LIMS module. Displays the date the test was conducted. |
LabTestNumber | For Test records processed through the LIMS module. Displays the date test number for the test record. |
LargestTestAge | For Test records processed through the LIMS module. Displays the largest number found in a specimen set. |
LocationDetails | For Test records processed through the LIMS module. Displays the data entered in 'Location Details' field. |
Location | For Test records processed through the LIMS module. Displays the data entered in 'Location' field. |
ProjectName | Displays the current Project Name. |
ProjectNumber | Displays the current Project Number. |
ReportDate | Displays the date the report was generated. |
SampleDate | Displays the data a sample record was created. |
SetNumber | Displays the set number tied to a sample record |
SpecimenNumber | For Test records processed through the LIMS module. Displays the specimen number for a test record. |
Technician | Display the Techician who captured or processed the sample or test record. |
Warning | ||
---|---|---|
| ||
When PDF files are uploaded to Activity records you have the option to add these documents to the report or to not allow these to display. By default all PDF documents will be apended to the end of a report. If you would like to control which fields that contain file uploads are actually added to the report, change the "Display File Uploads" field found under Report Settings to "Added to Report Template". When this option is selected you must add the field to the report template in order for the uploaded PDF documents be added to your report. |
...
To allow for faster addition of Form Fields, several additional elements are preconfigured for you upon dropping a Field onto a form. For example text based field types (Number, Text Area, Multiple Choice, etc.) are dropped onto the report as two Labels (one for the field label and one to display the field value) wrapped inside Panel component. After a Field has been added, all of these components can be altered to fit your needs.
...
Step | Direction | Example | |
---|---|---|---|
1. | Right click on a selected cell in the table and click Select Table. | ||
2. | Select the properties tab. | ||
3. | Choose the Data set and source that you want to use to control sorting.
| ||
4. | Choose your primary sorting data element and if you would like to sort by ascending or descending. | ||
5. | (Optional) If you'd like to use a secondary sorting criteria, choose a data element from the Secondary Sort option and choose ascending or descending for the Secondary Sort Direction. |
...
Info |
---|
Sort Order can be applied to data grids or panel data elements that use a data source. |
How to Hide Duplicate Records
When Report Designer has Unique Row = “Yes” setting applied and if there are duplicate data entries for fields present in Multi Record Grid then for those entries Distinct Record is displayed. |
Using Main Level, Section and Report Resource Fields Inside a Table
...
Step | Description | Example (Click Image to Enlarge) | ||
---|---|---|---|---|
1. | Go to the elements tab and add a line component as the last element inside the Panel.
| |||
2. | Select the line and open the Properties tab. | |||
3. | Type last() inside the Hide Expression property to hide the line in the last row. |
Working with Images
How to fix stretched images
To keep the aspect ratio of your images, set a value only for one of the size properties: Width or Height.
...