Opening Balance and closing Balance - Crystal Report

[Former Member]

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

[Former Member]

The easiest way to do this is NOT use variables.

Sort the data in date order ascending.

Then simple place the date field in Group header, details and footer.

Header will now show first date and Footer last date.

Ian