My Visual Database — Sum Function ........

Re: Sum Function ........

null@example.com (bbrother) — Thu, 29 Oct 2020 14:27:44 +0000

problem solved thanks all.

Re: Sum Function ........

null@example.com (blackpearl8534) — Tue, 27 Oct 2020 13:46:39 +0000

hello... you have to assign column type as "Real"
Data Types for Database Columns
"Real" (for decimal Numbers)
"Integer" (for Simple numbers)
"Text" (for Name,Address etc)
"Currency" (for Currency Value)

Re: Sum Function ........

null@example.com (bbrother) — Tue, 27 Oct 2020 13:27:40 +0000

screen shot

Re: Sum Function ........

null@example.com (bbrother) — Tue, 27 Oct 2020 13:25:36 +0000

ehwagner wrote:

bbrother,
Welcome to MVD. There is a sum function in Fast Report to sum various columns in the detail bands of a report. If you could upload your project, it would be easier for people on this forum to provide solutions for you.

Re: Sum Function ........

null@example.com (jean.brezhonek) — Tue, 27 Oct 2020 07:21:02 +0000

Hello bbrother

Enter in Search module of MVD the word 'Derek' and you will have many samples of caculated fields. About this, he has many good ideas.

Re: Sum Function ........

null@example.com (bbrother) — Tue, 27 Oct 2020 04:18:57 +0000

thanks but an example should better for understanding. And i will upload today my project.

Re: Sum Function ........

null@example.com (brian.zaballa) — Tue, 27 Oct 2020 04:03:35 +0000

You can also check on the Calculated Fields. You can easily get the sum you want there. It's like a temporary field that works like a sub-query.

Re: Sum Function ........

null@example.com (ehwagner) — Mon, 26 Oct 2020 21:41:53 +0000

bbrother,
Welcome to MVD. There is a sum function in Fast Report to sum various columns in the detail bands of a report. If you could upload your project, it would be easier for people on this forum to provide solutions for you.

Sum Function ........

null@example.com (bbrother) — Mon, 26 Oct 2020 03:37:47 +0000

M.V.D.B .in the report
i have question in two ways
1.how can we make total sum from many fields in 1 table
2.how can we make total sum form many field from many tables
thanks in advance.