Reply to topic

How do I add a Total to a Report footer?

User avatar nelsonhoover
Registered Member
Posts
2
Karma
0
OS
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?
piggz
Moderator
Posts
13
Karma
0
OS
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
User avatar nelsonhoover
Registered Member
Posts
2
Karma
0
OS
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!
User avatar jstaniek
Moderator
Posts
927
Karma
2
OS
@Adam Same here for count() (Kexi 2.9.11-pre):

Image

Image

Ideas?


Best regards,
Jarosław Staniek
Image

KEXI - Open Source Visual DB Apps Builder
• Request feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
piggz
Moderator
Posts
13
Karma
0
OS
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
User avatar jstaniek
Moderator
Posts
927
Karma
2
OS
@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.


Best regards,
Jarosław Staniek
Image

KEXI - Open Source Visual DB Apps Builder
• Request feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
piggz
Moderator
Posts
13
Karma
0
OS
Ok, this works with tables but not queries .... but, I may be able to make it also work for queries.
User avatar jstaniek
Moderator
Posts
927
Karma
2
OS
@nelsonhoover The fix (and some more other related) is almost done. To be released with 2.9.11.


Best regards,
Jarosław Staniek
Image

KEXI - Open Source Visual DB Apps Builder
• Request feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help

 
Reply to topic

Bookmarks



Who is online

Registered users: Baidu [Spider], bartoloni, Bing [Bot], Bladeforce, boudewijn, claydoh, Gallaecio, googie, Google [Bot], kamathraghavendra, Mace68, Mamarok, mauromol, rblackwell, Sogou [Bot], TheraHedwig, wind_rose_2, Yahoo [Bot]