Wooo hooo!
it worked!
At least at 66,667%... so far I've tried and create three different calculated
report fields, and only two of them work... They appear exactly identical to
me, but one of them only outputs "LibFormulaErrorValue{errorCode=522}"
Now I'm trying to guess why the third one doesn't cooperate.
Anyway: really thanks a lot for your precious help! It saved me lots of
(useless) hours and sleepless nights! Above all, now I can finally charge my
clients what they owe to me! ;-)
Paolo
On Monday 08 October 2007 07:47:16 Ocke Janssen wrote:
> 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.
>
> Best regards,
>
> Ocke
>
> http://wiki.services.openoffice.org/wiki/SUN_Report_Builder
>
> > Thanks a lot.
> > Paolo
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
