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.
Thanks again
