Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Records submitted during specific time frames Post Reply Post New Topic
<< Prev Page  of 2
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Jul 2014 at 6:35am
is your data source a table or a stored proc?
If you were comparing table data but your report source is a stored proc (or view) the stored proc may be running a date add onto a field, or something akin to that.
IP IP Logged
SSLead
Newbie
Newbie


Joined: 15 Jul 2014
Online Status: Offline
Posts: 18
Quote SSLead Replybullet Posted: 16 Jul 2014 at 8:14am
That was the issue. The table I was using must have been adding something to it. I was able to locate the correct table and the report is running as desired. I was able to create a chart for the number of records that were submitted for each day.   I displayed a distinct count of the number of records returned in the report but would also like to display the number for the average number of records submitted per day. How do I do a formula for the average per day?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Jul 2014 at 8:54am
maybe this?
formula1=date(datimefield)
average:
distinctcount(record_ID) / distinctcount(formula1)
IP IP Logged
SSLead
Newbie
Newbie


Joined: 15 Jul 2014
Online Status: Offline
Posts: 18
Quote SSLead Replybullet Posted: 16 Jul 2014 at 10:28am
That worked! I think I have everything I need for now. Thanks!
IP IP Logged
<< Prev Page  of 2
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.