Dynamically change the height of "sScrollY"

dajones12

Hello,
I'm a complete beginner here, so I apologize if this is a simple question. How do I go about making the height of my table dynamic based on the rows in it? My current code is:

$(document).ready(function() {
                var oTable = $('#displayTable').dataTable( {
                    "bPaginate": true,
                    "processing": true,
                    "bDeferRender": true, 
                    "bAutoWidth": true,
                    "sScrollY": "300px",
                    "bStateSave": true,
                    "sDom": '< TC > ftiS',
                    "oTableTools": {
                        "sSwfPath": "js/copy_csv_xls.swf",
                        "aButtons": [
                            "copy",
                            "print",
                            {
                                "sExtends":    "collection",
                                "sButtonText": "Save",
                                "aButtons":    [ "xls" ]
                            }
                        ]
                    },

Ideally, I would like for it to have a max height of 300px, but be shorter if there are fewer rows.

Thanks!

jr42.gordon

https://datatables.net/reference/option/scrollCollapse

Use this

dajones12

I tried that and for some reason it had no effect on my table.

jr42.gordon

Based on your code, you appear to be using an older version of DataTables. I believe scollCollapse is a fairly new option.

dajones12

I just got it working. You were correct. I just had to add a "b" to the front of it. So:

"bScrollCollapse": true

worked for me.
Thanks for the help!

allan

scrollCollapse for 1.10+, and bScrollCollapse for the legacy interface.

Allan