sql deleted records

[pmgatwork]

Hi
Is there a setting in crystal that stops deleted records appearing in a report if sr_deleted is true (ie the record has been marked for deletion) or does this have to be done in the select expert

Thanks

 

[Turkbear]

Hi,
If the record is actually deleted, then it will not, of course, show up..
If it is only marked for deletion then, yes, use a Record Selection Formula like:

sr_deleted = True ( or what ever it actually is when a record is marked for deletion).





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[pmgatwork]

Thanks Turkbear

Peter