Topic: Storing Results for next run Posted: 26 Jan 2012 at 7:04am
Good Day,
I need to be able to keep a history of records that have been previously displayed so that the next time I process the crystal report they are not displayed again.
I can do this by manually adding the records to a seperate table and excluding those records. This is time consuming and I am hoping there is a more efficient method. Is there a way in crystal reports for the report to populate a table automatically?
Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Posted: 26 Jan 2012 at 10:10am
if there is a difference between the records you could create an ID# of some sort like table.firstname + table.lastname + table.dateofbirth then just remove records with same ID#
Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Posted: 26 Jan 2012 at 12:14pm
i cant think of any non manual way.
the way i would do it
first create a parameter(records to exclude)
set allow multiple values to true
in selection expert put
table.record <> parameter(records to exclude)
then create a text file records to exclude
(after ran the report put record numbers into that text file)
then in parameter under valued fields click on Actions select import
then choose that text file
then just edit that file every run.
Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 99
Posted: 29 Jan 2012 at 9:26am
At least one of the Crystal Reports UFLs (User Function Libraries) listed at http://kenhamady.com/bookmarks.html allows you to create Crystal formulas that update a database table or write to an ini file. So that would be one type of solution.
If your process includes exporting, printing, or emailing, at least one of the 3rd-party Crystal Reports Schedulers (also listed at the link above) has built-in functionality to skip records that were already processed.
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
www.MilletSoftware.com
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
