But i still have another problem.i want to just show the Sum of the data on the report.Am using check Boxes so have used the =-sum([Course]) to get sum of participants of the course.the thing is am having a line of blank pages before showing the last page which displays the sum.
Not sure what you are up to, but where a control might be empty, if you set the Can Shrink / Can Grow properties to Yes, they won't take up space if they are empty.