In Form Reports can now be set to pull through data between two Date Fields in an Event Form
Inform Reports pull data from one Event Form and display these results as a "Mini-Report" in a different Event Form. You can specify how many records you want to display, as well as what date ranges you want the data to display between. Now, you can use date fields in the report to only pull through records entered between two date fields. This is very important for inform reports in injury or illness records, or even screening forms.
You then select the Form and the fields from that Event Form that you want to display. This Report example will be set up to display Rehab Training Load in an Injury Record
In the Advanced Properties Section for the Report, there are now two additional fields. These are called Dynamic Start Date and Dynamic Finish Date
Dynamic Start Date is the date that you want the data to pull from. This is the date that you FIRST want the data to be pulled through from. The example here is using the Date of First Symptoms of the Injury
Dynamic Finish Date is the date that you want the data to pull from. This is the last date that you want any to data to be pulled through from. The example here will be using the Date Fully Resolved for the Injury
When you view the inform report in the Event Form (that it appears on in the actual application) only the Inform Report Data that has been entered between the Dynamic Start Date and the Dynamic Finish Date (e.g. the Training Load data that has been entered on the system between the Date of first symptoms and the Date fully resolved) will appear.
You can set none, one, or both of these Dynamic Date fields for an Inform Report. They can limit the Event data that is pulled through from the dates after the start date, or before the Finish Date. Set both of these limits or just use one depending on your Event Form and the data you need to display in the InForm Report.
You can just set the Dynamic Start Date so that only data after the date you select will be shown in the Inform Report.
You can just set the Dynamic Finish Date, then only data entered before the date you select will be shown in the Inform Report.
These Dynamic ranges can be used in conjunction with the Properties of the Report, e.g. show on the Last 5 records.
Any questions, ask your Distributor.