Set Location command fails. 1

[ddamsgaard]

I have this problem concerning the Set Location command in Crystal Reports:

I created a report based on an Access MDB file.

I created a new Access MDB file with revised information.

I used the Set Location command to change the location and the name of the MDB file that Crystal Reports is looking at.

The (Crystal Reports) report produces correct information based on the new MDB file.

But, the individual fields in the report show the old file location when you hover the cursor over the field (example: 0531ARData.1 Openamt instead of ARData.1 Openamt).

And, the Set Location dialog box shows the incorrect MDB in the upper list box of the Set Location dialog box. (The dialog box does show the correct MDB in the Location/File: textbox.)

While I’m getting the correct information, there is something I’m missing/doing wrong and I’d like to get it resolved before I spend more time on this project.

When I attempt to redo the Set Location command, I do not get any prompt to "propagate data across tables..."

This is my first real report in Crystal so thanks in advance for your help.

 

[Naith]

Your report is still using the old alias for the new datasource. You need to Set Alias from the database menu.

Naith

 

[virk0009]

U should delete the old data from ur report.
then u will know what is wrong and what is right.