We help IT Professionals succeed at work.

Crystal Report Date Range

purpleoak
purpleoak asked
on
214 Views
Last Modified: 2010-04-21
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.
Comment
Watch Question

CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Another way would be to use the built in date range

{MAIN_DESP0.DSPDTE} IN Last7Days

mlmcc

Author

Commented:
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?
CERTIFIED EXPERT

Commented:
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.

Author

Commented:
Worked exactly how i needed it to work thank you for your help
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.