Fix your SP and not the report since it is your data which is missing the information. Using SQL Server BOL, search for CROSS TAB REPORTs .