Joined: 02 Nov 2016
Online Status: Offline
Posts: 6
Topic: Report for New/Modified Data a day old? Posted: 30 Jan 2017 at 10:48pm
Hello there,
I have a question in regards to creating a Crystal Report that will only show new data or modified data from the last 24hours.
At the moment I have a report that will create about 54000 records. I then have Visual Cut running the report every 5 minutes and dumping it on a server where it then gets picked up by other software and converted to XML then placed into a library of another piece of software.
I'd like the data being generated from Crystal to be only data that is either New or modified in the last 24 hours. It would greatly reduce the processing time at all stages.
Is it possible? If so can it can be done with a formula or what is best practice?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 31 Jan 2017 at 5:50am
You really need to deal with this in the data selection process. IF the data can't support the selection process Crystal has no additional way to do it.
Joined: 02 Nov 2016
Online Status: Offline
Posts: 6
Posted: 31 Jan 2017 at 5:53am
Originally posted by DBlank
You really need to deal with this in the data selection process. IF the data can't support the selection process Crystal has no additional way to do it.
Hi, Hmm was hoping that wouldn't be the case! Ok, I'll see what I can get out of the DB people.
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
