Hi Regina,
You have count and sum working? You are way ahead of me then.
I can use sum but it never gives me anything but the value of the last
record ( or current record ).
Count on the other hand gives me either " LibFormulaErrorValue{errorCode=505}"
if I use it in a function at the report level, or nothing if I use it at the
group level.
I am using a function definition of the type COUNT( [ID] ) where ID is the
PK field of the table.
On 5/20/07, Regina Henschel <[EMAIL PROTECTED]> wrote:
Hi Andrew,
Andrew Jensen schrieb:
> Hi Regina, et al
>
> I am working on a database for testing the functions listed in the OASIS
> document, amongst other things.
>
> Darned if I know why I actually started with the function MOD..but I
did.
>
>
http://www.paintedfrogceramics.com/OpenOffice/QA/ReportDesigner/func_tests.odb
OK, you show me, how to write functions, which can be used like
additional columns generated with a query.
[..]
Also, the point that Regina made is very valid
>
> - assuming that what is intended here is that one created a function at
the
> group level [ I don;t know that, but since it is there in the nav tree ]
In the meantime I got that work, doing it exact the way Ocke has
described.
>
> and then bind that to a formatted field in the group footer ( or header
) [
> again I am extrapolating from what I see ]
> to get an aggregate is still going to be a pain.
It is in no way a solution for "normal" user. How should they know, they
had to define their own SUM and COUNT? There must be another way.
> [cut out interesting proposals to solve the upper mentioned problem]
Now I have got a report with two groups. In the outer group I want to
count how many subgroups I get for each outer group value. A simple
counting does not work, because it counts all the rows in the detail
sections together. Does someone has an idea how to get it?
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
