Hi, I have a main report and a subreport. In my subreport I have name, test name and grades. For example: Dave Quiz 1 5 10 15 20 25 30 35 55 55 77 86 Dave Quiz 2 5 10 20 25 35 86 90 I dont want the second set of grades to have spaces when data is missing like they do? I'm using VS 2005 to create these reports. Any suggesstions? Thanks

Hi Damia10, Thanks for your question. According to your description, my understanding is that you display the name, test name and grades in one matrix of the sub report, and there are many NULL values of the grades field, you don’t want the NULL values represented as spaces in the matrix, right? If I misunderstand your question, please let me know. Generally speaking, in order to achieve this requirement, the easiest way is adding a check in the field of grades, if the value is NULL, we replace the NULL value with 0, else, we display the grades’ value directly. Please apply this expression in the textbox of the grades, =Iif(IsNothing(Fields!grades.Value),"0",Fields!grades.Value) Hope it helps you. If your issue still exists, please feel free to let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Thanks! That solution worked after a few changes were made to my report. I really appreciate your help!