i am using crystal 8.5 with VB front end. report is joined with front using ADO recordsets, which are retriving data for the reports. then retrived data is added to report using following syntax
Set fld = m_Report.Section3.AddFieldObject("{ado." & valarr(0) & "}", 400, 0)
Now Problem is,
when report is run for first time it produces expected results but if its re-runned/re-executed new data overlaps older data.
in short, i want report to refresh and delete old data when new execution takes place.
any input will be appreciated.