Recently, a client asked us to add an additional filter field to the standard GL Trial Balance Summary SSRS report for Dynamics GP.
This tutorial contains the report and the custom SQL that you will need to implement this for yourself. The object is to add an additional filtering field (in our case the User Defined 1 in the Account card) to a report.
The script and report can be further altered without too much effort.