I have a report built based on a query to show a list of sorted transactions. This works very well.
One of the values I'm showing in the detail section is a numeric price amount.
Is there some way to totalize this value in the footer section of the report?

Yup there is!
now to remember how!.......

(5 minutes later)

create a field in the footer
set its source to:
=field.sum("field name");

you can also use
.avg
.min
.max
.count

Let me know if you have trouble

Adam

Hmmm. I just get a zero.

I have a data field called amount that I use in the report detail. In the footer I added a field box and in the Data Source property typed

Code: Select all

=field.sum("amount");

I tried count and that gives zero as well though there are at least ten detail lines produced by the query I'm reporting on.
I'm not sure what I'm missing.

Is there a manual or help file explaining how to build reports and what things can be used in the Data Source?

Thanks!

@Adam Same here for count() (Kexi 2.9.11-pre):





Ideas?

Seems ok for me on Kexi 2.9.10, see example, actor_id is a number 1 to 200 ... 200 records in total, footer contains sum and count.

Design: http://imgur.com/bfUR1BZ
View: http://imgur.com/hxlLr9W

@nelsonhoover Update. If you use table as data source it works. If you use query, there's a bug to fix. To be released in Kexi 2.9.11 I hope.

Ok, this works with tables but not queries .... but, I may be able to make it also work for queries.

@nelsonhoover The fix (and some more other related) is almost done. To be released with 2.9.11.