Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Balance sheet using array fields

Status
Not open for further replies.

mbDutch

MIS
Nov 13, 2007
39
US
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
 
I don't understand what this is: $100;$120;$115 etc

Is this one instance of a field {table.Balance}? If it is a formula, please show the contents of the formula. Also provide the {table.field} name.

-LB
 
Hi LB -

Yes it's one instance of a field. The field is called "Cur-Balance" which is basically 12 balances (arrayed) in one field.
 
So they are arrayed in the field in descending order from Period 12 to Period 1? And to identify a particular array component, you would have to use the following?

split({table.cur-balance},";")[1]

If this is the case, then is the issue how to relate this to the parameters?

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top