When trying to export a smartlist created with Designer to Excel I get the following errors. If I click YES - everything seems to come across properly except for the Address 1 field is cutting off after the House #.
I am looking for any suggestions on how to remedy this situation as the smartlist is pretty useless without the whole address data coming across.
Thanks in Advance
*This post is locked for comments
I was able to resolve the issue by enabling the setting SmartlistEnhancedExcelExport=TRUE in the Dex.ini file for the installation. It is discussed in this blog post, though not directly related to this error.
dynamicsgpblogster.blogspot.com/.../gp-2013-why-are-my-smartlists-not.html
Do you have a hidden special character in that column somewhere? It looks like a space to the naked eye but SQL knows it's something else.
Wondering if there was a solution for this issue? I have the same thing coming up on my system with the Address1 field being cut off.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (