asked on

Crystal Report Date Range

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;

{MAIN_DESP0.DSPDTE}

i have looked around and am unsure where to start, as much detail as possible please.

ASKER CERTIFIED SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike McCracken

Another way would be to use the built in date range

{MAIN_DESP0.DSPDTE} IN Last7Days

mlmcc

purpleoak

ASKER

thanks peter57r that worked a treat, however it only works if i export all 800,000 entries then run the selection. Ultimately what im trying to achieve is export this data daily, hence i only the the most recent data, if i could get a way of exporting all the data automatically then run another report on that data to do the record selection?

peter57r

I'm afraid I don't understand your last post.

You cannot export more records than exist in the report and if you use a record selection rule fpr your report then those are the only records you have in your report.

purpleoak

ASKER

Worked exactly how i needed it to work thank you for your help