Dan Munns Posted August 28, 2019 Share Posted August 28, 2019 Hi, I have created a report and when running it via the data preview it shows all the data in the description field. However when I run the report to .csv/.xls/.xlxs/.pdf the description has the middle of the field contracted and replaced with ... This contraction is removing the data I am actually interested in for the report. Is there a way of stopping the actual report from doing this? Thanks, Dan Link to comment Share on other sites More sharing options...
Dan Munns Posted August 30, 2019 Author Share Posted August 30, 2019 Anyone? Link to comment Share on other sites More sharing options...
Dan Munns Posted September 12, 2019 Author Share Posted September 12, 2019 Anyone at all? @Victor can you help? Link to comment Share on other sites More sharing options...
NeilWJ Posted October 29, 2019 Share Posted October 29, 2019 Hi @Dan Munns, This will be any issue with the output generator. I will ask one of the server team to look at it. I assume they are truncating text after a certain size limit is reached. Thanks Link to comment Share on other sites More sharing options...
NeilWJ Posted October 29, 2019 Share Posted October 29, 2019 Hi @Dan Munns, Can you confirm data is actually being truncated or is it you are just presented with a "..." after certain number of chars and when you click on "..." it it expands the data fully? Cheers Link to comment Share on other sites More sharing options...
NeilWJ Posted October 29, 2019 Share Posted October 29, 2019 Not to worry can replicate it it fine. Server team are looking at it....need to ascertain why this was done. Maybe for display purposes in a pdf but for xls, csv i wouldn't have expected it to cut it out. Will let you know what server team say. Cheers Link to comment Share on other sites More sharing options...
Dan Munns Posted October 29, 2019 Author Share Posted October 29, 2019 Thanks @NeilWJ Link to comment Share on other sites More sharing options...
NeilWJ Posted October 31, 2019 Share Posted October 31, 2019 @Dan Munns, So server team is fixing so the text is not cut in the middle but instead will do a left trim. We do not allow reporting on the full length of TEXT fields as, well, it could be any length and in past reports have caused servers to grind to a halt because of reporting on full length of data. There is an existing setting reporting.reports.maxFieldLength that you can set to a maximum of 4096. By default this is set to 1024 (i believe)...so that will be your first port of call, change that setting to 4096. Once fix is released the data will be trimmed from char 0 to 4096 (if that is what you change setting to). Cheers Link to comment Share on other sites More sharing options...
Dan Munns Posted October 31, 2019 Author Share Posted October 31, 2019 Thanks @NeilWJ That will make my reporting a lot easier Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now