Avoid reprinting same data CR-XI

I have a report which consists of filtered Parametric data on certain Date... now i want to change the field value of the data from 0 to 1 once i have taken the prints of these data in order to avoid reprinting the same data again.

How can i change the data in the database from the Crystal Reports? If it is not possible through Crystal Reports then how do i pass the Parameter query from a DataTimePicker control in the VB2005 form ?

Please help me !

Always a bit dangerous to follow this path. There are going to be requests for re-prints and stuff is going to get lost etc. Might be better to use a date (or some other requirement) as a parameter to determine what needs to be printed

I have to do this no matter what, as this is my client's instructions which i have to follow. Moreover, the situation demands this provision. Can you tell me how can i change the field value in the database once i have taken the prints ?

Does this mean that if your user only views the report but DOES NOT print the report that you do not want to update the database?

I cannot understand your last post. Here is what i want... It is only after taking Prints, i want to update the database. I dont want to update the database on viewing the report.

Crystal Reports only reads data, never update it.
I would follow the next steps in my application
1.- Select data (saving it in a tmp if you want)
2.- Print selected data
3.- Ask user if printed ok and accept to mark the selected data as already
printed
4.- Update the original data as printed reading the selected data

Quote:

---

Originally Posted by jggtz

Crystal Reports only reads data, never update it.
I would follow the next steps in my application
1.- Select data (saving it in a tmp if you want)
2.- Print selected data
3.- Ask user if printed ok and accept to mark the selected data as already
printed
4.- Update the original data as printed reading the selected data

---

Good thinking on this one - must admit i been racking my brains and couldnt think of anything. :cool: :thumb:

How do i select the data from the database from a dynamic parameter assigned to the report ?

How to perform step no: 3 ? How would my application know that the data has been printed ?

Considering the information provided1.-You can select the data applying to some data extraction query, the same dynamic parameter assigned to the report
3.-The user would know that the data has been printed ok