matrix report [message #388501] |
Wed, 25 February 2009 00:55 |
privs
Messages: 11 Registered: February 2009 Location: South Africa
|
Junior Member |
|
|
Hi
I developed a matrix report in 6i and it works wonderfully well . now i have to create the very same report in 2.5 version. I tried using the same sql query but it didnt work because as i suspect the left join is not recognised so the query was rewritten to not use it so i had to break up the query into different parts. the problem with 2.5 is that its so hard to produce a matrix report according to what i want and there is no wix\zard (only a rudimentary layout wizard thingie. I'm outputting two rows of data and am using the sum field to total 2 values from each of the two rows but it returns the sum value of the row value even though the field references the sum field and it shows twice. Can any one help?
|
|
|