So, I am not sure if this is possible but I would like to be able to update the introductory message of a scheduled report to display a total count of records from that report. Example: a weekly report of incidents where active = true and and created_on > 5 days. So in the scheduled report, I would like to be able to have something like this:
Hello,
This is the weekly report for incidents open more than 5 days.
Total Incidents: _____ <---would like to add the total number of records here
My first thought was to try a business rule of the sys_email table but figured I should first ask the community.
