CR XI - Crosstabs being Deleted when DB's chgd

[OrionStar]

Group:

Has anyone else experienced their crosstabs being deleted, when you change the location of the Database Tables? I had some tables copied/transferred from on server to another for reporting purposes and when I went into CR XI to redirect the DB tables from one location to another using the database set location prompt, when I did this, all of my crosstabs disappeared. I lost them all.

????



Thanks:

MV

"What would you attempt to do... if you knew ... you could not fail?

 

[Naith]

This will usually happen if the crosstab value for summary does not have an identically named field in the destination source.

You can get around this by switching the value to a field which has a consistent name between source and destination datasources before changing the datasources, and then mapping it to the correct field afterwards.

Naith