Server Installation Report Template Format

16-09-2021 admin

Upload Template As prompts you to assign a Template Name and Locale to the template then uploads the file to the report in the BI Publisher catalog. 6.3.2 Working in Disconnected Mode When direct connection to the BI Publisher server is not possible or not desirable, you can use the Template Builder to design and preview templates in. Right click on the newly created folder and from the popup menu, choose the New option, and then click the Template command, type the name for a new SQL template e.g. PersonInfo: Right click on the newly created SQL templates and press the Edit command, this will open SQL template in a new blank query window.

Server Installation Report Template Format Download
Server Installation Report Template Format Free

jsreport is an open-source reporting server side tool running cross-platform on node.js. It can dynamically produce reports in various formats like pdf, excel, docx, pptx and also many other text based formats. The main idea of jsreport is to let users define reports without annoying designers but instead by using code, mostly html and javascript templating engines. This approach gives great power and flexibility to the software developers and lets them use the knowledge they already have.

This article shows you the most simple use case with jsreport, which is creating a pdf invoice. It covers the basic principles you need to understand to get started.

Basic workflow

Get jsreport
Define sample input data
Define report template
Test and preview report
Call API with real input data

Get jsreport

First, you need to download and install jsreport on your PC, register for jsreport as a service solution, or start right away in jsreport playground.

No matter which option you choose, you get access to the jsreport browser-based studio you're going to need for designing and testing reports in this tutorial.

Define sample data

Before you create a pdf invoice layout, you should prepare some sample data you will later use to preview it.

You can create sample data in the jsreport studio from the entity tree panel.
Right-click the panel -> new entity -> sample data.

The sample data needs to be defined in json format and for our simple invoice it can contain the following:

Define report template

Together with the rendering process, the report template is the heart of the jsreport. A template defines what the report is going to look like and is used together with the input data every time you render a new report. You can create a report template again from the entity tree panel on the top left.
Right-click the panel -> new entity -> template.

Select sample data

For the invoice tutorial, the first thing you need to do is associate the sample data you previously defined with the newly created template.

Recipes

The report output format is defined by the template's recipe. The recipe is an algorithm used by jsreport to convert the output of templating engines into the desired format. Every report template needs to specify exactly one recipe from all that are available.

The easiest way to create a pdf invoice is to use html to pdf conversion implemented in the chrome-pdf recipe, so let's stay with it. Note that not every recipe uses html conversion and it is always recommended to read its documentation in the recipes section.

Templating engines

Templates are defined using common javascript templating engines like jsrender or handlebars. Templating engines let you assemble reports dynamically using loops, conditions, javascript helpers, or data binding. Templating engines provide you with a way to define any custom report you like.

Each template can use a different templating engine, and it's up to you which you will choose. They have a very similar feature scope and only use different syntax, but everyone has different preferences.

This time, let's use handlebars and assemble the invoice html. In a very simple way it can have the following look:

You can see it is just html with handlebars binding to the sample data you previously created. Now you can click the Run button in the jsreport studio and it should preview a pdf in the right pane. This is because you previously selected chrome-pdf, which automatically converts html into pdf.

Tip: You can use also the F8 shortcut to preview the template. Or you can click Run->Run and undock preview button to render into a new tab. Then you can move this tab to the second screen of your PC and comfortably develop on two of them.

To make it a little bit more complex, let's add a tax calculation to the template. To do so, you will need to define a custom javascript function calculating tax from the original price. Such a function can be added to the bottom panel in jsreport studio:

Then back in the top panel you can use the tax function to print the price.

Finally it should be like this:

Assets

jsreport ships out of the box with several extensions you can find useful during the development. The most commonly used is the assets extension. This extension is typically used when you want to extract parts of the template like styles or scripts into separate entities and reuse them. Or when you want to upload images to jsreport and reference them in the template.

Let's add some css styles to the invoice. Start by creating an asset entity; name it for example styles.css
.Right-click the entity tree panel -> new entity -> asset.

Now you can fill some css and save it:

Tip: You can save the active entity using CTRL+s shortcut

The main trick comes now. You want to reference the asset inside the template. Open the invoice template and add to the top the following code.

The {#asset xxx} isn't a handlebars syntax but the syntax used by the assets extension. The extension hooks into the rendering pipeline and replaces this specific string with the actual asset content. In this case, it is just plain text but it can be also an image for example.

Tip: You can also drag & drop any file to the entity tree and it gets automatically created as an asset entity.

Test and preview report

Now it's time to finish the invoice and preview it with the sample data until you are satisfied. In case you want to skip it and see the result right away, you can find it here in the playground.

Call API with real input data

Now you are ready to integrate your application with jsreport API. It's very simple and in most cases, you just need to do one REST call. You can even try it from your browser's REST plugin.

The following request will invoke rendering of the previously defined template and response back with a pdf stream:

POST:https://localhost/api/report
Headers: Content-Type: application/json
BODY:

More information about the jsreport API can be found here.