I am using Crystal report 2008 and connect using Oracle Server connection to Oracle 11g.

 

I wanted to change the source table to a synonym. When I go to set datasource location and when I add name of the synonym in "Overridden Qualified Table Name", it goes blank for some synonyms. But it work for most of the synonyms. Does any body know why does it blanks out? Does not give any error message, so no way for me to to track it.

 

Thanks in advance.