Column Widths - Columns are very wide

Has anything changed in the latest release which would cause column widths to expand? When working in one of my dashboards, I noticed I now have to scroll to see all of my data in one of my widgets. Prior to the latest release, I am almost certain I was able to view all of the data in my widget without scrolling.

Here is a screenshot showing my column. The column is much wider than needs to be. Is there a way to adjust the width? In this case the column Customer Name is a dimension.
image

1 Like

I’m not aware of anything, certainly not seen the same issue.

I wonder if you could drop you customer list into Excel and do a count on the character length of each name.

Could be that a user has done something in the actual ERP system to cause this error?

Hi @Justin,
I agree with you, we have noticed an increase in the widths of columns. Especially the layout on financial statements. Here is an example we have:

This is on a ultra wide monitor and cannot see the numbers when everything is collapsed, which is crazy. We also have the same with grids. Why we are getting a scroll bar here is very strange:
image
Note: This widget on the dashboard has not been touched in months and the data has remained the same, but we now have scroll bars.

When I last raised this, I was told to change the property to “Paragraph” which would truncate the text after a specific length, but still with this its too wide. Also, the grid gets as wide as one of the values in the row, if you scroll down your list, does it have a customer name much longer than the others?

You could in SQL or in the designer create an expression of LTRIM(RTRIM([Customer Name])), which may eliminate the unnecessary spaces, but suspect it wont get rid of all the layout issues.

But back to your initial question, I do believe something happened a couple of releases ago which changed the behaviour of the layouts.

Jon

Hi @JonKemp,
Thanks for the reply. I will try the SQL approach and see if that helps. My users are telling me they can remember being able to see all of the data in a specific widget without having to scroll, but now they have to scroll to see data.

-Justin

Hi @StuartH,

Thanks for the reply. I will give the character count a try, but I honestly do not think it is related to data entry in the ERP. I have been getting emails from my users stating they can remember begin able to view all of the data in a specific widget without scrolling, but now they have to scroll. Some of the columns have become very wide and that is causing the need for scrolling. I do not have a cutsomer name anywhere near the width of the column.

-Justin

I agree,


Some columns are now really wide and I have to hide the dimensions to see all columns on one screen

1 Like

What mode have you got the line set to?

Equal Width, Flex, Horizontal Scroll or Stacked

@StuartH most of mine are set to Equal Width or Flex.

I just wondered if it was an issue with Flex?

I’m not having any issues on mine which mostly use Equal Width or Horizontal Scroll.

I find Flex doesn’t convert well when changing screen sizes.

Having no ability to enlarge or reduce column width has always been an issue for me. Continue to hope for the ability to size on a custom basis in future releases.

I’ve noticed some of my columns are doing the same also, like everyone else there is no extra data in the fields they’re just abnormally wide.

Experiencing this in the normal grid now.

Making columns fall off the screen and require horizontal scrolling unnecessarily.

What’s worse is that this is what I get at the end of my report - why does the vertical scroll sit on top of the data?

image

@StuartH,
Oddly enough that gremlin has now gone for me, there is a noticable improvement since the drop of 8.0.6. But still too wide. On the update notes it was there as a bug ref of dev-16248:

.

Out of curiosity, are you a Chrome,IE, Edge, safari user? Have you tried different clients just to see if its a HTML 5 issue?

Using Chrome as there are other bugs with other browsers and Chrome is what Phocas recommend for the best experience.