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

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.

Previously this would not have been possible.

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)