Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 12 Apr 2010 at 8:27am
There are a couple of ways you can do this.
1. Group by customer. Sort by Order Date descending. Put all of your data in the Customer group header. This is the easiest to set up but if you want order details, you may have to use a subreport to display them.
2. Use a command instead of tables to provide data for your report. Write the SQL so that you only pull the most recent for each customer. You have to know SQL to do this one, although there should be no need for a subreport here.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
