Capture print date and hide report

hi, I am displaying a crystal report that displays record for particular user.

Requirement is like 1. If Print of that report is taken out, then that user should not be visible that for 1 month (30 days to be precise). Hence if i print the report on Jan 1 2011 for user John Smith, that record for John Smith should not appear till Jan 30 2011, On Jan 31, that record should again come up in report.

I'm using

Visual Studio 2005 (C#)
Crystal Report (Crystal Report viewer to view reports)
My Query:

How to capture print date?
How should i proceed to fulfill my requirement?
Please guide me esp in the Logic department :-)
LVL 7
meispiscesAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
So you are saying if you run the report today and John appears for 28 Feb then no records for John should appear until the report is run again on 30 Mar?

Reports have no knowledge of previous runs so you will have to somehow capture what was printed then save that information to a database that can be checked when the report is run again.

mlmcc
0
 
meispiscesAuthor Commented:
no comments..??
0
 
mpeaden2Commented:
I don't fully understand the question. You want to capture the print date for a user, and display a report for everything that was printed for the previous month?

For starters, I would capture the print event and store the date/time in a db. Use the DateAdd() function to pull the previous months dates and display them in the report.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
John ClaesSenior .Net Consultant & Technical AnalistCommented:
meispisces:

I would suggest the folowing :

1) By calling the Print Event
* Create your report
* Send to printer
* Change Record.ReactiveAt => Record.ReactiveAt .AddDays(30);
* Save the Record

If your using a PrintPreview : you should also try to capture the PrintEvent so do this action Yourself.
The printEvent can be handled ;-)

regards
poor beggar
0
 
meispiscesAuthor Commented:
@poor_beggar: i guess u are referencing your answer wrt crystal reports..?
0
 
mlmccCommented:
Is this a report limited to 1-month at a time or are you loking at longer periods?

How often are you running the report?

mlmcc
0
 
meispiscesAuthor Commented:
Report could is limited to 1 month. by 1 month i mean that say on Mar 1 i run a report, printed on mar 1 only for user John.

Now user John's report should not appear when i click "View Report" until Apr 1.

Now on Apr 4 i again printed John Report (some data modifications, if any) then till May 4 i should not see him again... Hence the cycle goes on..

Hope thats clear.let me know if not.
0
 
mlmccCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.