Update sql command in a subreport is slowing the report drastically

[crystaldev1]

Hello, I'm using CR 2008.
I have an update sql command in a separate subreport to update a field everytime the report is generated. This is slowing down the performance of a report. The update command is as follows:

Select * from ABC
Update ABC
Set ABC.Check = 'Yes'
where ABC.Batch = {?Batch} and ABC.Seq = {?Seq} and
month ({?Mth}) = month(ABC.Mth) and year ({?Mth})= Year(ABC.Mth)

Can this be achieved without using command subreport? Perhaps sql expression? Thanks.

 

[Turkbear]

Hi,
Using CR to update a database field ( especially doing it in a subreport) will be very inefficient as the program was never intended to do that. Why is it nesessary to update this way..How is the updated data being used?






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

 

[crystaldev1]

We need a way to check and see if the record has been printed. If so, it needs to indicate as a 'REPRINT' on the report next it is ran. We have a check for that to distinguish between non-printed reports and printed reports.