The following is my SQL query used in Crystal Reports. 

```
SELECT     
    sum_date, sum_accname, sum_description, credit, debit
FROM
    sum_balance
WHERE
    sum_accname = {?acc_name}
    AND sum_date >= {?fromDate}
    AND sum_date <= {?toDate}

```

It is working just fine, but I need to get another column using credit and debit as an accumulated balance column (a balance column like on a bank statement). And while my parameters are working and the data is being filtered based on the dates provided, I can't get the actual balance it's calculating only the data which is between those two dates. 

Is there any ways to solve this problem?