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

  • Registered: 2020-10-26
  • Posts: 25

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.

  • Registered: 2015-11-13
  • Posts: 652

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.

  • From: Philippines
  • Registered: 2018-10-23
  • Posts: 430

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
  • Registered: 2020-10-26
  • Posts: 25

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

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

  • Registered: 2014-08-02
  • Posts: 954

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 Reply by bbrother (edited by bbrother 2020-10-31 08:06:26)

  • Registered: 2020-10-26
  • Posts: 25

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, 522 downloads since 2020-10-31 

  • Registered: 2020-10-26
  • Posts: 25

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

screen shot

Post's attachments

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

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

  • From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

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, 181 downloads since 2020-10-27 

  • Registered: 2020-10-26
  • Posts: 25

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

problem solved thanks all.