Skip to Content
Former Member
Feb 27, 2012 at 05:53 PM

Records Not Showing Up On Report


I'm using Crystal XI

I can take the query from "Show SQL Query..." and paste it into a query screen in SQL Server 2008 management studio and retrieve the correct records. However, the report itself does not contain all the records the should have been returned.

To the best that I can figure, the records where a transaction date (date/time field) is null is not showing up on the report. I only display the field, do not do any calculations based on the field.

It is part of the record selection formula, where I test for the field to be between start/end parameters or is null (which produces the correct SQL query as I stated above)

So why are the records not showing up on the report, and more importantly, how do I get them to show up?