1 (edited by bbrother 2020-10-26 04:41:11)

Topic: Sum Function ........

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.

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

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 ........

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.

brian

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

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

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

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.

JB

6 (edited by bbrother 2020-10-31 08:06:26)

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

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.

Post's attachments

Attachment icon sssss.rar 296.04 kb, 8 downloads since 2020-10-31 

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

screen shot

Post's attachments

Attachment icon Capture.PNG 10.97 kb, 4 downloads since 2020-10-27 

8 (edited by blackpearl8534 2020-10-27 14:07:32)

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

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)

Post's attachments

Attachment icon untitled.JPG 49.42 kb, 3 downloads since 2020-10-27 

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

problem solved thanks all.