I need to be able to review invoice line history for specific customers for a period in time(AR INIVOICEC HISTORY) Detail and Header).  From that data I want to exclude specific items sold during specific date ranges(Sale items).  Once I have gotten the data so I only see the sales for a customer during specific time period for only approved products.  I will create a summary report in which my users will be able to review.

I tried to use the suppress feature in Crystal report but in totaling up the sales it did not exclude the items even though they were not showing on the report, they were only suppressed from the report not from the subtotal of dollars sold.

In Access I could return data back to a table and then run a report against that table, can Crystal report do anything like this?