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?
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.
Thanks a lot.
Paolo
--
Paolo
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
