nitin.lokhande (5/14/2013)
HiI 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.