Have a few reports that I need to keep in Crystal. For some reason I don’t see any tables under ICE just the standard ERP tables. What needs to be done for them to show up?
Are these ODBC reports?
If you log into SQL Server Management Studio with the credientials you’re using to connect from Crystal to SQL, are you able to see the Ice tables?
Yes. Using SQL authentication
I ended up using OLE instead of ODBC in crystal and all the UD tables are available under ICE.