Answers

• tangerine Posts: 3,365Questions: 39Answers: 395

  March 2017

  Please post a link to a test case showing the problem. as per the forum rules.
  https://datatables.net/forums/discussion/12899/post-test-cases-when-asking-for-help-please-read
• adibro Posts: 3Questions: 1Answers: 0

  March 2017

  I cannot provide the url but i can provide the print screen image:

  Thanks...

  error11.png 196.6K
• tangerine Posts: 3,365Questions: 39Answers: 395

  March 2017

  The solution will be in your code. A screenshot is not helping.
• adibro Posts: 3Questions: 1Answers: 0

  March 2017

  Here is the code:

  $(document).ready(function() {
  $('#dtAllRequests').DataTable( {
  "ajax": {
  "url": "xAGENT_vwAllCompletedRequestsMyDeptJSON.xsp",
  //"url": '#{javascript:getXAgentPageNo("CompletedRequests")}',
  "dataSrc": ""
  },
  order : [0, 'desc'],
  iDisplayLength : 20,
  aLengthMenu : [10,20,50],
  // Tabletools options:
  // https://datatables.net/extensions/tabletools/button_options
  "sDom": "<'dt-toolbar'<'col-xs-12 col-sm-6'f><'col-sm-6 col-xs-6 hidden-xs'lT>r>"+
  "t"+
  "<'dt-toolbar-footer'<'col-sm-6 col-xs-12 hidden-xs'i><'col-sm-6 col-xs-12'p>>",
  "oTableTools": {
  "aButtons": [
  {
  "sExtends": "xls",
  "sTitle": "All_Completed_Requests"

    }, 
     {
    "sExtends": "pdf",
              "sTitle": "All_Completed_Requests",
              "sPdfMessage": "All Completed Requests",
              "sPdfSize": "letter"
          },
          {
              "sExtends": "print",
              "sMessage": "<div class=\"DTTT btn-group\"><input type='button' value=\"Print\" onclick=\"print()\" class=\"btn btn-default DTTT_button_print\"/><input type=\"button\" onclick='javascript:window.location.reload()' value=\"Back\"  class=\"btn btn-default DTTT_button_print\"/></div><br/><br/>"
          }
       ],
      "sSwfPath": "js/plugin/datatables/swf/copy_csv_xls_pdf.swf"
  },
  
  "autoWidth" : true,
          "columns": [        
          { "data": "xlink"       },
          { "data": "xName"      },
          { "data": "xDept"       },
          { "data": "JobTitle"       },
          { "data": "RequestType"       },
          { "data": "xAppName"       },
  
          { "data": "xDate"       },
          { "data": "CurrentStatus"       },
          { "data": "xRequesterName"       },
          { "data": "xWith"       }
      ],
  

  "fnCreatedRow": function( nRow, aData, iDataIndex ) {
  $(nRow).attr('class', 'clickableRow');

  }
  } );
  $('#dtAllRequests tbody').on('click', 'tr', function () {
      window.location.href = $(this).find("a").attr('href');
  } );
  //$("#dtAllRequests tbody").find("tr").addClass("clickableRow");
  

  } );

  Sorry for the non formatted code as there are too many quotation marks...``
• tangerine Posts: 3,365Questions: 39Answers: 395

  March 2017

  TableTools was retired some time ago. Use Buttons and Select.
  https://datatables.net/extensions/tabletools/