Oct 24, 2011 at 07:39 AM
Display Report Totals
Good day!
First off, I'm so sorry for the formatting of my message.
I'm using Crystal Reports 2008 and SAP B1 8.81. I wanted to get the totals only of all transactions made using the Incoming Payments module filtered by date. I was able to list all Incoming payments transactions (another report) by just getting details from the Incoming Payments module. Here are sample results:
September 2, 2011 Transactions September 3, 2011 Transactions
--------------------------------------------------------- -------------------------------------------------------------
OR # Name Cash Payment OR# Name Cash Payment
--------------------------------------------------------- -------------------------------------------------------------
1234 John Doe 300.00 9876 Mark One 500.00
4567 Jane Doe 420.00 5432 John Doe 10.00
8901 User Name 20.00 -------------------------------------------------------------
--------------------------------------------------------- Total: 510.00
Total: 740.00
What should I do to my report so I'll only get the Totals. Here's what I wanted to happen:
September 2, 2011 - September 3, 2011 Transactions
-----------------------------------------------------------------
Date Total Cash
-----------------------------------------------------------------
September 2, 2011 740.00
September 3, 2011 510.00
-----------------------------------------------------------------
Total: 1250.00
Thank you so much.