Print Page | Close Window

Crystal Reports - Adding a sum of a field per day

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22377
Printed Date: 04 May 2024 at 5:31am


Topic: Crystal Reports - Adding a sum of a field per day
Posted By: afatima
Subject: Crystal Reports - Adding a sum of a field per day
Date Posted: 03 Jul 2017 at 3:39am
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)



Replies:
Posted By: kevlray
Date Posted: 03 Jul 2017 at 3:59am
Please do not double post.



Print Page | Close Window