Post Author: hsforum
CA Forum: Crystal Reports
I'm new to Crystal and fairly new to SQL. I'm working with a Solomon 7 database and need to create a report to show only the next scheduled billing record. Data basically looks like this, and is grouped by customer in the report:1 cust1 $100 5/10/082 cust1 $100 6/10/083 cust1 $120 7/10/084 cust2 $180 5/10/085 cust2 $180 6/10/086 cust2 $190 7/10/08I need to show only the first and fourth lines, representing the next scheduled billing record for each customer. I have everything else figured out, I just can't get it narrowed down to only the next chronological record, without some unacceptable kludge. Any help would be greatly appreciated!