Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: How to exclude previously qualified records Post Reply Post New Topic
Author Message
TC Tran
Newbie
Newbie


Joined: 24 Oct 2011
Online Status: Offline
Posts: 19
Quote TC Tran Replybullet Topic: How to exclude previously qualified records
    Posted: 12 Apr 2017 at 9:49am
Hello,

I've created a report to extract the data to then import into a third party application daily. I have been manually adding the previously qualified records to exclude prior to re-generating the report. Is there a function or formula in Crystal Reports that can identified what previously qualified records and exclude from re-qualifying for the report?

The data qualify for the report based on a certain field being valued the previous day. As an example: today file 1, 2, and 3 qualify for the report, tomorrow when I re-generate the report I don't want file 1, 2, and 3 to re-qualify. Is there a way to do this systematically without having to manually exclude the records?

Thank you for your help in advance!

Thanh
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 13 Apr 2017 at 6:18am
Is there something like a "last change date" field you can use to filter out the data that's already been reported?

-Dell
IP IP Logged
TC Tran
Newbie
Newbie


Joined: 24 Oct 2011
Online Status: Offline
Posts: 19
Quote TC Tran Replybullet Posted: 14 Apr 2017 at 6:18am
Hello Dell,

Thank you for your response and suggestion! I was actually thinking of using the last change date field too. I think this is the only possible solutions.

Thanks again!

Thanh
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.031 seconds.