Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Report definition suitelet - footer and links
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 0