Skip to Content
0
Former Member
Dec 19, 2011 at 03:56 PM

Opening Balance and closing Balance - Crystal Report

510 Views

Hi,

We have a report with account number, date , opening balance , closing balance and transaction amount. we had grouped the report by account. User will run the report with set of date range and we need to find the minimum date to find the opening balance and maximum date to find the closing balance and display them in the account group header for each account.

WhilePrintingRecords;

NumberVar CBal;

If {Command.VALUEDATE}= Maximum({Command.VALUEDATE}) then

CBal= {Command.CLOSINGBALANCE};

+CBal;

It is showing the closing balance and opening balance in the account group footer. but we could not able to show in the account group header.

Regards,

Sreeni