I am creating a report to do some basic calculation from BMC ARS 7.1
The query should have about 30,000 records, but Crystal Reports (with the same selection criteria) only brings about 20,000 records.
I'm pulling 4 fields in from the Remedy form (which has a total of about 500,000 records) Department, Assigned Group, Closed Date and a large character field (1000 bytes). And I created two Formula fields to populated based if there is data in the large character field.
I then have a cross-tab to do summary information on the formula fields and grouping it by month vs. Department & Assigned Group.
What I don't understand is why I'm not getting all the records returned.
When I limit the selection to come from only a couple of the Departments (bringing the total records that should be pulled to less than 10,000), I get the expected records in the report.