This article provides troubleshooting steps for when a custom report filter in the Custom Report Writer shows 'No Rows To Show'. It advises checking the applied filters to ensure they match existing student data and ensuring that multiple filters do not contradict each other.
If you've applied filters that yield no results to a report in the Custom Report Writer, you'll get this message: "No Rows To Show"
Follow the instructions below if you've applied a filter to a report in the Custom Report Writer but it hasn't given you any results. You'll need to edit your report.
Step 1 - Check your filter
You may have added a filter where no students match the criteria.
For example, I have no Gypsy / Roma / Traveller students, so if I add a filter for this, my report won't show any students.
Have a look at the student group. For example, I went to Students > Demographics > Derived Indicators, selected Background and selected Gypsy / Roma / Traveller in the filters.
Important note on language filters on Welsh Arbor sites
In March 2026, we made a change to how languages are selected in Custom Report Writer filters on Welsh Arbor sites.
Previously, English and/or Welsh/Cymraeg could be selected as a single combined option. Since then, we have separated English and Welsh into two different options in the Report Writer.
Any custom Report Writer reports that previously filtered on “English and/or Welsh/Cymraeg” may no longer return the same group of students.
Those reports would need to include English and Welsh/Cymraeg in the filter separately to match the same students in the report output. To replace the old filter:
- Find and open your Custom Report (School > Custom Report Writer)
- Click the Edit button
- Scroll to the Filters section and click the Pencil next to the Language filter
- On the slide-over, in the filter conditions, make sure this is set to Is one of... and include English and Welsh/Cymraeg as two separate options, as well as the combined option.
- Click Save Changes
Step 2 - Check if you've applied more than one filter
Your filters might be contradicting each other. Here are the filters I've set - I wanted my report to only show students who were in the registration forms 1MJ or 1TP.
However, my report is actually showing students who are part of both 1MJ and 1TP. This would be none of my students, because students are only in one registration form today.
You can click the bin icons next to these filters to delete them. Then, add a new filter for Registration form (not for the name of the student group with a question mark ? at the end).
In the slide over, select the groups of students you want to be included under Is one of, then click Save.
When you Save and view your report, it will show only students in 1MJ or 1TP.
More help
This guide will give you some handy hints when using filters in a student-based custom report: Using AND and OR filters in the Custom Report Writer
Comments
Article is closed for comments.