Skip to Content
0
Former Member
Mar 05, 2009 at 06:41 PM

Adding a Command to bring in summarized data

25 Views

My data is structured like this:

Transaction header (one)

Transaction details (many)

Tender details (many)

This, unfortunately, causes duplicates of the transaction details to appear any time that a customer pays with more than one tender type. (Like part on a credit card and part cash).

I wrote a command to summarize the tender information and sum up the total of payments but that still causes duplicates because I am not able to force server side grouping. Those options are all grayed out.

I have checked or unchecked the appropriate boxes for options which should allow me to check the box for server side grouping but that option continues to be grayed out.

Any help in this matter would be greatly appreciated. Thanks, Jean