Smartlist error on export to excel and where is smartlist designer in 2016r2?

(0) Share

Report

Posted on by Community Member Microsoft Employee

This is a two part question.

1. Where is smartlist designer in 2016r2? I cannot find it. smartlists I can find but not the designer.

2. When we do a fixed asset smartlist that combines two tables (so I am told) it will not export to excel correctly. it gives the excel sheet error and asks to recover. Then the date is not correct on the excel sheet. I have taken all the columns out of the sheet except one and it still errors out. Doesn't matter which column I keep it will still error out. thoughts? ideas?

*This post is locked for comments

All responses (13)

Answers (1)

Suggested answer

ShawnMD 1,456 User Group Leader on at

Like (0)

Report

RE: Smartlist error on export to excel and where is smartlist designer in 2016r2?

Hey Aaron - I just stumbled on this regarding your #1 - I really just go to designer from within Smartlist BUT it is available in the administration module, under reports content box and then SmartList designer!
ShawnMD 1,456 User Group Leader on at

Like (1)

Report

RE: Smartlist error on export to excel and where is smartlist designer in 2016r2?

Thank you for following up and sharing the solution!!
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Smartlist error on export to excel and where is smartlist designer in 2016r2?

The issue was in changing the order of the columns in the results. When we left the columns the way they were it was fine. When we changed the order is when it broke.
Suggested answer

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

RE: Smartlist error on export to excel and where is smartlist designer in 2016r2?

Aaron,

Check out this thread, and in particular the solution posted by Jim on Page #2... I ran a few times into such issues in the past, and most of the time the problem was caused by a user that copy/pasted infos from a web page into GP, appending an invisible character into a field, which GP as per say has no issues with, but the export process from SL to Excel goes thru XML and that is the problem..

community.dynamics.com/.../336175
Community Member Microsoft Employee on at

Like (0)

Report

RE: Smartlist error on export to excel and where is smartlist designer in 2016r2?

what check the XML hyperlink to get more info? who would have thought? yeah it just says it repaired some cells but not which cells.

As I mentioned I have tried with BOTH 32 bit and 64 bit of office with the same results. Also above I stated that other smartlists are not having an issue. I suspect it may be data as well but I have filtered out the results to one column and one item in that column and have the same issue.
Suggested answer

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

RE: Smartlist error on export to excel and where is smartlist designer in 2016r2?

Thanks Aaron,

Usually it's not a good thing to mix-up Office setups like this.. The GP Client is only a 32-bits apps and as such works only with the 32-bits version of Office.. I'm on Ofice 2016Pro 32-bits and never had issues with Excel & GP.

As a side note, did you try to click on that XML hyperlink to see what exactly was repaired (or attempted) ? it might give you a hint on the data that is causing the issue.. I've seen weird characters in GP that would cause such strange behavior when trying to export to Excel. Sometimes those are 'invisible' and are not an issue to SQL, but Excel has a problem to handle them.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Smartlist error on export to excel and where is smartlist designer in 2016r2?

64 and 32 bit both.
Suggested answer

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

RE: Smartlist error on export to excel and where is smartlist designer in 2016r2?

Hi Aaron,

Could you post a screenshot of the error message you getting in Excel.. ? it might something totally unrelated.... Which version of Office is installed ? 32- or 64-bits ?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Smartlist error on export to excel and where is smartlist designer in 2016r2?

Oh I even did a filter so it would only grab one item in the query and still same issue.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Smartlist error on export to excel and where is smartlist designer in 2016r2?

I can run the tsql in SSMS just fine, there does not appear to be any nulls. I can copy the data from the query in SQL and paste in to excel just fine.