Showing results for 
Search instead for 
Did you mean: 

Opening Balance and closing Balance - Crystal Report

Former Member
0 Kudos


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.


NumberVar CBal;

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



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.



Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.