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
--
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: Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
