I need to write a balance sheet type of report that shows by tax year and period, the account number and the balance for that account number. However, let’s say that whoever runs the report selects tax year 2008 and period 5, they will want to see that period, as well as the previous 12 periods (2008 – period 4, 2008 - period 3 etc).
However, the period is determined by the array number of the field. So for instance
“Cur-balance[4]” shows the balance for period 4. So the detail lines look somewhere along the lines of:
Account # Tax Year# Balance (12 array field)
45000 2007 $100;$120;$115 etc
45000 2008 $90;$160;$100 etc
47000 2007 $1000;$1050;$1100 etc
47000 2008 $900;$1200;$1150 etc
And what we would like the end result to be is:
Someone selects the Parameters: Tax Year= 2008, Period = 5 then the report will display:
Period 5 / 2008 Period 4 /2008 Period 3 / 2008
45000 $90 45000 $160 45000 $100
47000 $900 47000 $1200 47000 $1150
Etc.
Assuming this would be possible, I am looking for some advice on how to best approach this?
Thanks in advance.
Marco
However, the period is determined by the array number of the field. So for instance
“Cur-balance[4]” shows the balance for period 4. So the detail lines look somewhere along the lines of:
Account # Tax Year# Balance (12 array field)
45000 2007 $100;$120;$115 etc
45000 2008 $90;$160;$100 etc
47000 2007 $1000;$1050;$1100 etc
47000 2008 $900;$1200;$1150 etc
And what we would like the end result to be is:
Someone selects the Parameters: Tax Year= 2008, Period = 5 then the report will display:
Period 5 / 2008 Period 4 /2008 Period 3 / 2008
45000 $90 45000 $160 45000 $100
47000 $900 47000 $1200 47000 $1150
Etc.
Assuming this would be possible, I am looking for some advice on how to best approach this?
Thanks in advance.
Marco