Missing last years detail records in Crystal Report
Posted on 2009-05-20
I have a report to show sales counts of items using scanned data from stores. I want to compare last years to current years. The only record selection I'm using is the store number. There is a parameter for starting date and ending date the user would enter. If the detail record is in this years date range, the count is added to a variable, CYitem. If the detail record date is in last year, for the same time period (say a month) then the count is added to another variable, lyitem. I never see detail records for last years sales, but the summary at the next level has a total in it. What could cause the records not to show up? The real difficulty is if there is 0 sales in current year of an item, but there are sales in last year. This makes the listed items not total down to the actual summary.