Results report Frozen column width adjustment - how to

[StephenS]

Hi All

I have a results report which is using three groupings, with a large number of subsequent fields.  

All works ok, but when I freeze the first three columns, the width seems to default to a small width and I can find no way of adjusting them.  

 

The usual width setings and those in the style seem only to impact the columns if they are not frozen,  

Can anyone assist in how you can set the frozen columns to a wider and fixed width

 

thanks in advance

 

 

[TellMeWhy]

4 minutes ago, StephenS said:

Hi All

I have a results report which is using three groupings, with a large number of subsequent fields.  

All works ok, but when I freeze the first three columns, the width seems to default to a small width and I can find no way of adjusting them.  

 

The usual width setings and those in the style seem only to impact the columns if they are not frozen,  

Can anyone assist in how you can set the frozen columns to a wider and fixed width

 

thanks in advance

 

 

What does yours look like?
Mine adjusts accordinly...

[StephenS]

When the columns are not frozen, the column widths are ok and  have the correct width I have set up, and the text does not wrap in them. 

 

When I freeze these columns they all shrink to the same width, which looks to be some sort of default.  the test in them wraps and I cannot then change their width 

 

 

 

[StephenS]

Hi Just nudgin this to see if there are any othersuggestions thanks  

[Kurumi]

Hi @StephenS - can you provide a sample URL of the report? Thanks!

[cheonsa]

Hi All!

I used the code provided here to adjust the width of the frozen columns. But instead of display:none, I replaced it with padding: 8px 70px.

To avoid word-wrapping, you can use white-space:pre !important;

 

<style>

form[action*='[@cbAppKey]'] tr.cbResultSetDataRow td:nth-child(1),
form[action*='[@cbAppKey]'] tr.cbResultSetTableHeader th:nth-child(1)
{
padding: 8px 70px !important;
}
form[action*='[@cbAppKey]'] tr.cbResultSetDataRow td:nth-child(2),
form[action*='[@cbAppKey]'] tr.cbResultSetTableHeader th:nth-child(2)
{
white-space:pre !important;
}
</style>

Hope this helps!

[chumkirebzi]

Hi all! I followed @cheonsa's code in adjusting the width of frozen columns and it worked!

Wanted to share some adjustments I made for another column since I have some long texts with truncate and expand/collapse button enabled.

<style>
form[action*='[@cbAppKey]'] tr.cbResultSetDataRow td:nth-child(1),
form[action*='[@cbAppKey]'] tr.cbResultSetTableHeader th:nth-child(1)
{
padding: 9px !important;
white-space:pre !important;
}

form[action*='[@cbAppKey]'] tr.cbResultSetDataRow td:nth-child(1) span:nth-child(2),
form[action*='[@cbAppKey]'] tr.cbResultSetTableHeader th:nth-child(1)  span:nth-child(2)
{
white-space:normal !important;
}
</style>

I found that the truncated text was located in a different span (second span hence the (2)) and added white-space:normal !important; to contain all the text within the column

Hope that helps!