Joined: 30 Jun 2017
Location: United States
Online Status: Offline
Posts: 2
Topic: Crystal Reports - Adding a sum of a field per day Posted: 03 Jul 2017 at 3:36am
Crystal Reports - Adding a sum of a field per day
I am trying to get solution for the sum of per day but i am not able calculate per day, per month is working when i am adding the number, please help me how to fix this issue
(SELECT (Sum("ShoretelPhone"."NACD_EXternal_OUT"))
from "ShoretelPhone"
where "ShoretelPhone"."a_number" = 4888 and month("ShoretelPhone"."a_date") = 5)
How the data is stored in a table ? I think, it is storing everyday data. If that is the case use below
(SELECT (Sum("ShoretelPhone"."NACD_EXternal_OUT"))
from "ShoretelPhone"
where "ShoretelPhone"."a_number" = 4888 and month("ShoretelPhone"."a_date") = 5
Group by "ShoretelPhone"."a_date")
If the above is not working, let me know how the data is storing in your table. Are you trying to create the above in SQL Expression ?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
