Using PrintDate to Select Records 1

[starflt1701]

I want to create a report which selects only those records from the database which are after the date the report was last printed. I have tried using PrintDate as a criteria in my record selection formula, but turn up no data. And there is data to extract. What am I doing wrong?

Thanks

 

[MikeTom]

can you post youe selection formula.

 

[starflt1701]

{GOODS_RECEIVED_HEADERS.SYSTEM_DATE} > PrintDate

I have also tried it with DataDate in place of PrintDate with similar (no) results.

Thanks,

 

[MikeTom]

this formula should work. i suggest you remove all the formula and re-add it using the select expert

 

[starflt1701]

I don't know. It appears the PrintDate is changing to the current date when the report is refreshed, whether the report is printed or not. I think this is why it is failing to pick up data. Any ideas?

 

[kenhamady]

Because CR is WYSIWYG, preview counts as a "print".
What date were you looking for? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[starflt1701]

That would make sense. I'm just trying to find a way to get the report to pick up all data since the last time it was refreshed and printed. Any ideas?

 

[kenhamady]

The RPT file has now way of knowing the last time that it was run. And since Crystal is a read-only tool, your only option is to launch it from an application you have written, and have the application store the date. Then the date could be passed to the report next time. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[starflt1701]

Never done that before. Do you have any examples?

 

[kenhamady]

Have you ever done any programming in VB? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[starflt1701]

Very minimal. Mostly macros in Excel. Do you have any simple models I might study?

Thanks,

 

[kenhamady]

The only code I have is part of my "Quick Reference". It is described on my web site. There are sample VB applications on Crystal's web site, but you would need the developer's edition of Crystal. That also comes with some sample applications. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com