Thus I am trying to determine why some of the records are not selected whe running the ssrs report.In the table called 'transactionfile', the fields that I am trying to determine where there is a problem is the following: SchoolNumber (varchar(50),null), and TransactionPaymentDate (varchar(50),null).Examples of data are SchoolNumber = '121' and TransactionPaymentDate = '04162014'In the SSRS report