troubleshooting Question

Crystal Report Date Range

Avatar of purpleoak
purpleoakFlag for United Kingdom of Great Britain and Northern Ireland asked on
Crystal Reports
5 Comments1 Solution218 ViewsLast Modified:
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

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros