When I run the report for Source Journal SO and with a date, the report seems to query all the data for SO and doesn't pass the date filter to SQL. Is this the normal way that the reports are setup? Retrieve all data and then apply a filter in Crystal?  I would expect to see an additional clause. AND PostingDate = '2024-06-28'  If that is the data I picked.

 This is the captured SQL.
SELECT * FROM [GL_DetailPosting] (NOLOCK)
WHERE [SourceJournal] = 'SO'
ORDER BY [SourceJournal],[JournalRegisterNo],[PostingDate],[SequenceNo]'

Thanks