Hi Andrew,
Andrew Jensen wrote:
On 5/21/07, Ocke Janssen <[EMAIL PROTECTED]> wrote:
Hi Andrew,
Andrew Jensen wrote:
>
> I then tried changing the function to
> SUMPRODUCT( [Weight] )
>
> This however generates the output
"LibFormulaErrorValue{errorCode=505}"
I just wrote an email to the developer of the report engine and asked
him if this functionality will be included. So we have to wait for his
answer. For those who are interested I looked at wiki.pentaho.org
Yes, I have read those entries, but the differences between that UI
and this
one leaves me somewhat lost.
I did for example try using the function ItemSumFunction in Report
Designer.
When used as ItemSumFunction( [ID] ) I get
"LibFormulaErrorValue{errorCode=505}"
If I change that to ItemSumFunction( [ID], [GROUP_ID] ) where GROUP_ID is
the name of the group I get a NULL String.
This raises another question. The Pentaho document states that
ItemSumFunction takes two parameters the field name and the group
name. It
also states earlier in the document that one should give your groups
meaningful names. In Report Designer there is no way to change the
name of
the group, it is just named for the column it is based on. So, perhaps
the
problem is that there is therefore no way to pass that second
parameter, it
is interpreting [GROUP_ID] in my example as the field name, not the group
name?
Anyway, I will just wait on this to hear from you, when you hear from the
Pentaho developer.
Now I have the answer. The summary calculations coming from the old
engine. Currently there exists no replacement other than to write the
function by hand. But there will be one in the near future. If it is not
possible to write such a function by hand it's an issue which you should
submit :-)
Thanks again
- OJ
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1,
D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Marcel Schneider, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
