Skip to Content
0
Former Member
Nov 21, 2011 at 10:22 PM

Synonym table has no fields (Crystal Reports 2011 OLE DB sql server)

186 Views

I am running Crystal Reports 2011. I'm using OLE DB to connect to a sql server database that has tables and synonyms. I choose the table (cust_ord) and the synonym table (customers) and then I go to the next screen. At the next screen it says "Link together the tables". It shows the cust_ord table with its fields, and it also shows the customers synonym table, but the customers synonym table is just a blank box with no fields in it. Therefore I am not able to link together the tables. Please advise. Thank you.