I have a SQL Db. I am running crystal 9.
I want a simple report like this
Period : 1/1/2007 to 31/1/2007
Group #1 : Warehouse
Group #2 : Product Code
Opening: Qty Value
Details: Doc. No. Details. In Quanitity Value Out Qty Value
Group #2 : fotter: Closing : Qty Value
I have got the report formatted, sorted accordinly. The details part is not a proble. The opening and closing balances i have problems. Not getting results. I have used formulas and various tricks. I have got parameters as input for the date from to. But i am beaten. Need Help urgently.