I'm trying to create a pivot report based off the example in the help guide. I'm wondering how can I add footer filters for things like date range. Also, how do I make things link when you click on them? Right now when you click on a transaction number it goes to https://system.netsuite.com/app/site/hosting
instead of the actual record. Here is the suitelet

function runOpportunitiesPivot(request, response)  {      //Instantiate a report definition to work with      var reportDefinition = nlapiCreateReportDefinition();         //Define the rows/column hierarchy and the actual column data      var lamp = reportDefinition.addRowHierarchy('displayname', 'Lamp', 'TEXT');   var transdate = reportDefinition.addColumn('trandate', false, 'Date', null, 'TEXT', null);   var trans = reportDefinition.addColumn('tranid', false, 'Trans', null, 'TEXT', null);   var compstat = reportDefinition.addColumnHierarchy('custitemitemsubtype', 'Lamp Type', null, 'TEXT');   var quantitysold = reportDefinition.addColumn('quantity', true, 'Sold', compstat, 'INTEGER', null);   var quantityship = reportDefinition.addColumn('quantityshiprecv', true, 'Shipped', compstat, 'INTEGER', null);   var transstatus = reportDefinition.addColumn('statusref', false, 'Status', compstat, 'TEXT', null);   //var qtysoldper = reportDefinition.addColumn('qtysoldp', false, 'Percent', null, 'PERCENT', 'F(quantity, quantityshiprecv) = (quantity/quantityshiprecv)*100');         //Create the search to feed