reports 6i

[chochoo]

hi everyone!
i've a report similar to a ledger report that displays the transactions of any particular record according to the given dates. i-e start date and end date, and the report is running well. but i've a problem in that. suppose i've started entrying the transanctions from 01-Jan-2004 to 31-Jan-2004. and if i display the reports by giving these 2 dates, the sum and other functions are working right. but if i give the start date as 15-Jan-2004and end date as 31-jan-2004 , the end balance is not right becuase it can't calculate the transanctions before 15-jan-2004 and the sum is only of remain days. now i need to calculate the sum as openeing balance of first 14 days (before 15th january or whichever the start date entered) and then display the transactions from 15 to 31 as the report is already displaying and then show the balance at the end by summing the opening balance and the transactions' amount.

 

[nagornyi]

Create calculated field like this:
if :transtaction_date < _start_date then return ' BEFORE';
else return 'AFTER';
end if;
Create a group by this field. The group will separate the report into two parts: 'BEFORE' and 'AFTER'. For each part you can list transactions and calculate totals. Then hide the transactions for the ' BEFORE' part and leave only totals that would serve as entering balance.