Validating jsreport integration

You can use the sample templates bundled by jsreport to validate the integration.

To produce a report, you need to:

Create a script in Investigate that calls the jsreport API to produce a PDF.
Associate the script to an entity table.
Test the script.

Creating the script

Go to Management → Scripts.
Set the Title of the new script to jsreport validation.
Set the Type to template.
Make sure that Version is set to a value of 2 (default option).

Paste the following into the Source text area:

function buildPdfDownload() {
  // The id of the jsreport sample template named "Invoice"
  const templateId = 'rkJTnK2ce';

  const data = {
    amount: 60000,
    number: 99,
    items: [
      {
        name: 'Ice Cream',
        price: 5000
      },
      {
        name: 'Pizza',
        price: 60000
      }
    ]
  };

  return { filename: 'invoice.pdf', templateId, data };
}

context.registerPerspectives({
  binary: {
    PDF: {
      render: buildPdfDownload
    }
  }
});

Click Save.

Associating perspectives

Go to Data Model and select an entity table or create a new one.
Go to the Template scripts tab and click Add scripts.
Click the play button next to the perspective registered earlier with the jsreport validation script.
From Download as… in the preview, click PDF.

If the integration is working, you can download a PDF, invoice.pdf, based on the sample invoice template.

Next steps

For step-by-step instructions on how to create templates and downloadable reports, see Templating and reporting.

For more information about template scripts, see Template scripts.

For more information about scripting, see Scripting API documentation.