in rows. To simplify this discussion, assume that there are two tables:
PurchasedItems
Customer
Item #
Qty
Items
Item #
Name
Is there a way to create a report that would look like this:
Customer Name 1 Item #1 Item #2 Item #3 ...
Customer Name 2 Item #1 Item #2 Item #3 ...
....
It is easy to create one that looks like this:
Customer1 Item #1
Customer1 Item #2
Customer1 ....
Customer2 Item #1
Customer2 Item #2
Customer2 ....
Customer Name Item #1
...
Andy
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
