Hello,
2007/10/8, Ocke Janssen <[EMAIL PROTECTED]>:
> Hi Paolo,
>
> Paolo wrote:
> > Hello everybody,
> > I've been folowing the list for a few weeks and I must admit most of the
> > discussion is above my level of understanding. I have little or no
> > programming background and a rather basic understanding of databases.
> >
> > I'd like to ask a question about OO 2.3 and Report Builder: is it possible
> > to
> > get calculated fields in a report?
> >
> Yes. :-)
> > Basic example: I create a report to print data from my job's activities; all
> > of the activities are nicely grouped by client's name, and I can also print
> > activities fulfilled for different clients on different pages. Every
> > activity
> > has a fee ("cost") field related to it. The report gets the data from a
> > query, collecting different tables.
> >
> > The report looks nice but doesn't provide the main information, that is I
> > cannot get it to sum the "cost" column for each client.
> >
> > Can I calculate how much every single client owes to me and append the
> > information at the end of that client's list of activities?
> >
> > I've been able to get calculated fields in queries, but that doesn'help, as
> > it
> > only provides the ability to sum different values from the same record
> > ("line") of the query itself, while I need the ability to sum values across
> > a
> > range of records.
> >
> > Hopefully I've posted this to the correct list; I'll provide any further
> > detail if needed.
> >
> Open the report navigator. Open the Groups entry and the group where you
> want to calculate the cost.
> The group has an sub entry called functions. Open the context menu
> (right mouse) on that entry and choose to create a new function and
> select it. In the property browser on the right side you see the
> function. Change the name to e.g CostCalc and the formula to [CostCalc]
> + [Enter your cost column name]
> In the initial value enter 0
> Now you can insert a text field and bind it to your [CostCalc] (appears
> in the data field list box)
> That should be all.
I've been following this very useful thread.
Trying to do the same than Paolo (getting the sum of an integer field
in a group header), I do as mentionned above for the function
creation.
if I use 0 as initial value : the function returns 0
if I use [theFieldToSum] as initial value, the fonction returns the
value of the first record in the group
Sample .odb file available on request.
I'm using the extension with OOo 2.3.0 / Mac OS PPC X.4.10 X11
>
> Best regards,
>
> Ocke
>
Thanks,
Manuel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
