Skip to Content
0
Former Member
May 03, 2016 at 02:45 AM

Overridden Qualified Table Name – what for?

724 Views

Hi,

I have seen a few posts on issues with Overridden Qualified Table Name property of Crystal Reports (Database -> Set Datasource Location -> upper pane -> connection Properties).

I do not have an issue with it: it does remove DB name and the owner / schema name fromSQL Query.

I am wondering what are scenarios when this property is needed?

I guess this property is intended to improve report’s portability, when it is moved between servers and databases.

However, my understanding is that I have to update the datasource location anyway (using Update button in the Set Datasource Location window). So what is the point of having the overridden table name functionality?

Thanks