Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
ODBC Text Area Field
We just recently purchased the ODBC driver to enable us to print out a more complicated Sales Order. However, I have had some problems getting things to work.
I started using MS Access to create the report, but when linking the tables, we have a custom field in our inventory items of type Text Area, but Access defines it as a Text field with a limit of 255 characters, and line feeds do not seem to get interpreted properly. Any ideas on how to get the data out?
As a second option, I downloaded the newest Crystal Reports and tried to create the same report, but none of the fields get populated into Crystal. For example, I created a new report, selected the Netsuite.com connection, selected the ITEMS table, but when going to the next screen to grab the fields, clicking on the + sign to expand the table does nothing (almost seems as thought the ODBC driver is failing).