Excel Report Enhancements: Running a report when there is no data for an event type
Previously, Excel Reports would not run if any of the Event Forms in the Report had no data enerted for the athlete. It would just return "No Data Found"
This was creating issues in Reports created using multiple Event Forms, especially of only one type of data was missing. Now users can edit their existing Reports, or create new Excel Reports and set them up to Run even if there is no data. This is done in the Event Selection section of the Excel Report
There is a new "Produce report when no data present" setting. If it is ticked the report will run even if there is no data.
The image in the step here shows that the report will be generated even if there is no data in the 20m Sprint and the Running Time Trial Forms.
You MUST select this setting for any event forms that are set up in the report. It is defaulted to unticked so all of your existing Excel Reports need to be edited and updated if you require this setting.
N.B. Excel Pivot tables cannot update to nothing (e.g. no data), so it you are using an event form to pull into a pivot table or chart it will not update correctly if there is no data entered for that event.This means you may not want to tick "produce report when no data present" if that event form data links to an excel pivot or chart because the pivot/chart will not display correctly. See the steps below for more details.
The image here shows that a report has been run, then opened from the sidebar. There is no data for Running Time Trial for that athlete
N.B. Excel Pivot tables/charts will NOT work correctly if no data exists to reference
The example in the image here shows a report that was run and there was no data for the Running Time Trial or the 20m Sprint that is referenced in the pivot table. This pop up box will appear as a warning that there is no data to reference.
Click on OK. However, when the pivot table displays it will not be able to refresh to show blank data (see the image in the step below)