CrossTab hanging onto data from previous run

[StevenK]

We have a crystal report working against a SQL server 7.0 database. We have three tables used in the report. The body of the report is made up with groupings of departments and the payment types (i.e. OverTime Rate 1, Basic Rate 2, etc.) with appropriate totals. We also have a 'CrossTab' in the report footer that shows a summary of the results. The body of the report seems to follow the data that we are pointing to but the 'CrossTab' element is hanging onto data from the previous run. Note : The tables used in the 'CrossTab' are the same tables as used in the body of the report. We are accessing the report through a Delphi 5 application setting the Log-on info. for each of the tables accordingly (using Tables.SetLogOnInfo(ODBCName, DatabaseName, UserName, Password)). The report object itself is not set to be saved with data and prior to setting up the report we are issuing the command CRReport.DiscardSavedData - this does not appear to be doing the task as required. Can anyone suggest what we are doing wrong ?
Thanks in advance,
Steve

 

[kenhamady]

Any chance that the cross-tab is in a subreport? If so it will have its own data set that has to be managed separately from the container. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[StevenK]

Thanks Ken - we hadn't stepped through the process of re-pointing the tables as used in the 'Cross-tab'.
Thanks again.
Steve