1. Jochen Peters
  2. Report Editor
  3. Friday, August 18 2017, 02:46 AM
  4.  Subscribe via email
Help any idea

this is my query but on the reports,
i try to sum() one column and no works
i use the grouping on the report

Select invoicehd.invnum,invoicehd.fdate,caja.paytype,caja.amountpay,caja.amountchange,caja.stationid,invoicehd.custid,caja.userid,invoicehd.total
From caja inner join invoicehd on caja.cntid=invoicehd.payid where sdate >= '08-01-2017' and sdate <= '08-30-2017' and caja.stationid='01'
Comment
There are no comments made yet.
Jochen Peters Accepted Answer
Report Example
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 1
Sergey Pashkov Accepted Answer
Hi Alexis,

So you put summary control for "total" field into the group footer, right?
What type of this field?
What kind of DB used (MySQL, MS SQL Server...)?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
Jochen Peters Accepted Answer
yes
price real
PostgresSQL v9.5
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 3
Sergey Pashkov Accepted Answer
Hmm, but the sum is correct.
So what is wrong? Formatting?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 4
Jochen Peters Accepted Answer
i use currency
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 5
Sergey Pashkov Accepted Answer
You set Currency formatting for the summary control
Sum value is correct but without the currency symbol:
7.16

Right?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 6
Jochen Peters Accepted Answer
yes
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 7
Sergey Pashkov Accepted Answer
Strange, in my example it works.

Please show the properties of the summary control.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 8
Jochen Peters Accepted Answer
ok
when i get home i check the propertis
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 9
Jochen Peters Accepted Answer
Sergey Pashkov
i remake the report and now works

Big Thanks :D
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 10
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories