I am not expert but hard coding is not a good idea, tomorrw the coder leave and some new dept. to be included then what ??
Copying the same report to multiple folders isn't really a great idea either. And if the coder leaves, who's going to set up the report for a new department anyway? To be clear, I'm suggesting hard-coding at the report level, not within the SQL itself.
The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.