Jump to content

Freeze columns dropdown?

Recommended Posts

Does anyone know if its possible to have a freeze columns dropdown in a report - tabular or pivot?

Would be great if the User could choose whether to freeze 1, 2 or 3 columns, or turn freeze off completely.

Alternatively, does anyone at least know whether it's possible to simply turn the column freeze on or off, using javascript or jQuery, when the report is displayed, via a dropdown I could add in there?  I'm really looking for the code that controls the freeze function.

What I've found so far is the following HTML:

<th class="cbResultSetLabel cbResultSetHeaderCell cbFreezeColumnsDivider_65699f5f6d3e23 cbFreezeBoxSizing_65699f5f6d3e23" scope="col" style="display: none; width: auto; visibility: hidden;"> 


But I'm just not sure if I'm able to have any control over this.

Any help much appreciated .

Link to comment
Share on other sites

Hi @Farnsbarnes,  To keep the table header row and interactive options such as Download, Sorting, Bulk Edit and Search Again always within view, you can enable the Sticky Header Row feature in the DataPage wizard. Additionally, one or more columns of the report may be fixed using the Freeze Columns feature. Here is the link for further explanation https://howto.caspio.com/datapages/reports/fixed-rows-and-columns/

I hope this helps.

Link to comment
Share on other sites

Hi SunakoChan, thanks for you response.

Perhaps I wasn't clear enough.  I know that I can freeze columns in the datapage wizard.  But once set they are fixed.  What I want to be able to do is alter the freeze column settings when viewing the report itself, in real time.  I'm fine with doing the coding for a little drop down menu in jQuery or javascript to be placed next to the download button in the report.  But in this dropdown I'd like to be able to turn the column-freeze on and off, or even better, to set to 1, 2,3 columns, etc, again, in real time. 

Does anyone know the essential coding to be able to do this?


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...