Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Daily Last Time Stamp Post Reply Post New Topic
Author Message
Dr4ke
Senior Member
Senior Member


Joined: 09 May 2014
Online Status: Offline
Posts: 209
Quote Dr4ke Replybullet Topic: Daily Last Time Stamp
    Posted: 09 Sep 2014 at 5:42am
Afternoon all,

I am currently trying to capture the last time stamp from two days (Yesterday and Today) so the Disk usage can be compared on a rolling day basis. The problems I am experiencing are:

1) The 'Maximum' date/time of each system is different. This isn't too much of a problem as I can obtain the maximum by system by using Groups (System_Name then DateTime).

2) I cannot figure out how to get the last date/time stamp of two days and the data that corresponds to it! I can get data for just two days but it seems to be picking a random figure from each of the days...

Would appreciate any help.
IP IP Logged
Dr4ke
Senior Member
Senior Member


Joined: 09 May 2014
Online Status: Offline
Posts: 209
Quote Dr4ke Replybullet Posted: 09 Sep 2014 at 6:33am
I think I managed to figure this out... this is what I did:

1) Create a group based on the System Name

2) Create a group based on the Date/Time field (by day)

3) Add a Record Sort Expert for Date/Time (Desc) and add the Disk usage field in to the second group field; which will put the last figure from that date in Details (which will of course be the last for that day as it has been sorted in step 2).
IP IP Logged
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.