You can probably do it with your sql statement, but need a lot more info on how you designed the report.