I have a report made that is scheduled and sent at month end to one person. But now I need almost the same report sent to more people. Basically the only thing that changes is the SQL query’s WHERE clause for that specific person and obviously the recipients email.
Instead of making a bunch of different reports for each person is there some sort of template I could make? I’m hoping to avoid making 100 reports and then have to make a change to all of them eventually.
Or maybe there’s some alternative way?