This thread seems to be out of control with numerous suggestions for something that should be very simple. I hate to see you create some type of "hack" for something that can be done natively in the report writer.
If you would like, you may zip up the report along with some sample data and email it to me. I will look at it and see if I can figure out where the mistake is. I'd rather have you learn the right way for future reports instead of a "work-around".