I am using SmartSheet and linking the tables to Crystal Reports in VS2015. When I do this I can see the fields in a Sheet to drag and drop onto the report but they do not show up in the list to link the report together.
How can this be so?
Asked
Active
Viewed 75 times
0
-
How are you connecting to Smartsheet data from VS2015? i.e., are you using CDATA's [ODBC driver for Smartsheet](https://www.cdata.com/kb/tech/smartsheet-odbc-crystalreports.rst), their [ADO.NET provider for Smartsheet](https://www.cdata.com/kb/tech/smartsheet-ado-crystalreports.rst), or something else? – Kim Brandl Nov 21 '18 at 23:39
-
ODBC connection. I would prefer an API but its not supported in VS2015 Crystal add on – Andrew Little Nov 21 '18 at 23:46
-
Are you using the [Smartsheet Live Data Connector](https://www.smartsheet.com/apps/smartsheet-odbc) to establish the ODBC connection? I don't see Crystal Reports (VS) in its list of [supported products](http://smartsheet-platform.github.io/odbc-docs/#requirements). – Kim Brandl Nov 21 '18 at 23:56
-
I was using the ODBC connector but after some research i am trailing with some successes this connector. https://www.cdata.com/drivers/smartsheet/ado/ – Andrew Little Nov 23 '18 at 10:16