It sounds like a Cross-tab would be the easiest solution to your problem. Since you don't specify what you're counting transactions for, I'm going to assume it's per Customer for this example. You'll need a separate record for each date/customer combination. Place the cross-tab on the report, right-click and select Cross-Tab Expert and do something like the following:
On the Cross-Tab tab
Rows: Select the field that identifies your customer.
Columns: Select the date field. Click on the "Group Options" button under the Columns box and make sure that it's set to print for every day.
Summarized Fields:
1. Select a field to be counted for the number of transactions. Click on Change Summary and change the summary function to either "Count" or "Distinct Count".
2. Select your Amount field. The default summary function for numbers is Sum, so you shouldn't have to make any changes.
Customize Style Tab
The default configuration for a Cross-Tab is to put the Column Totals on the top and the Row Totals on the left. I prefer to have them on the bottom and right, so I uncheck those boxes. You also have a number of options on this tab for setting up other aspects of the cross-tab.
Based on the requirements you've outlined, your initial query will limit the results to three days. If you need to expand that, the cross-tab will automatically grow as you add dates.
-Dell
Edited by hilfy - 02 Jun 2010 at 6:55am
IP Logged
