You can get the closing balance of ledgers using the functions $$FromValue and $$Tovalue in SQL query.
For example:
Select $$FromValue:"01-04-2015": $$ToValue:"30-04-2015":$Closingbalance from LedgerColl.