im Running crystal Reports XI, i have a report wich connects to a mumps database and exports a load of data. The data it exports is the customer Id, Order number dispatch number and dispatch date. Now when i run the report it exports all orders ever placed, so it exports around 800,000 records. What i want is to export data that has the dispatch date within the last 7 days? the name of the table for dispatch date is;
i have looked around and am unsure where to start, as much detail as possible please.