Report Problem only for geniuses

[chevyimpala]

Heres the delima:

I have a report called Performance, and this is what it gives me:

Currency Current Pos Net Amount Unreal Rate
CHF -2,584,524 0 351,525 1.26
EUR 2,485,200 0 25,125 1.1
GBP -1,744,000 0 398,083 1.2567

And what it is doing is taking the sum of each currency and displaying unreal if [Current Pos]<>0, And Net Amount if [Current Pos]=0. Now this is the format in which i need to see it.

However in the table there is a column called account and this is what that data looks like:

Currency CurrentPos Net Unreal Rate Account
CHF -856,500 254,260 1,525 1.26 Sys1
CHF 3,800,500 65,000 525 1.26 Sys1
-----------------------------------------------------
Sub total 0 355,215 0
-----------------------------------------------------
CHF -400,584, 95,800 35,525 1.26 Descr
CHF -40,584, 95,800 35,525 1.26 Descr
-----------------------------------------------------
Sub total -460,226 0 256,265
-----------------------------------------------------
EUR -856,500 25,420 1,525 1.26 Sys1
EUR 1,806,520 65,060 525 1.26 Sys1
-----------------------------------------------------
Sub total 356,444 0 355,215
-----------------------------------------------------
EUR -300,584, 95,800 55,525 1.26 Descr
EUR -40,584, 95,800 25,525 1.26 Descr
-----------------------------------------------------
Sub total -360,522 0 5,215
-----------------------------------------------------
GBP -856,500 254,260 14,525 1.26 Sys1
GBP 3,700,500 65,000 525 1.26 Sys1
-----------------------------------------------------
Sub total 0 355,215 0
-----------------------------------------------------
GBP -230,584, 9,500 3,525 1.26 Descr
GBP -40,584, 95,300 35,525 1.26 Descr
-----------------------------------------------------
Sub total 3,215,525 0 355,215
-----------------------------------------------------
The problem is that it is taking the full sum of each currency no matter what account they are in and sending it to the report where it does its sorting for each currency.

What i need it to do is give me a sum in the report based on currency and account so that even if GBP has a 0 balance for sys1 but has a $25 balance for descr it still gives me the numbers for net and unreal.

If anyone can figure this out I bow down to your access abilities.

Ivan

 

[MichaelRed]

see sorting and grouping. It is well described under the ubiquitous {F1} (a.k.a. Help)




MichaelRed
m.red@att.net

Searching for employment in all the wrong places