top of page
Jet Reports

How-to-Use NL (Columns)

NL is a useful function in Jet Reports that help you create custom reports quickly and easily. The NL function can be used in conjunction with (“Columns”) to insert a copy of the entire column of each value that meets the Filter criteria, allowing your report to display the values on the column from left to right.

Here are the steps to create a report that shows the customer names on each column

  1. Open your Excel report and navigate to the Jet tab.

  2. Click on the NL function under the Tools section.

Join On Point Academy to view all content

3. Fill in the fields as follows:

  • What tab: Column

  • Table tab: Customer

  • Field tab: Name

4. Click on OK.

5. Once that is done, you should see a display of the customer names.

6. Give your column a title.

7. When you run your report, you should see the customer names displayed from left to right.

By following these simple steps, you can effectively use the NL function with (“Columns”) to create a report that displays the desired values on each column

Get trained
the On Point way

From self paced online courses to private training sessions.
Become industry ready.
bottom of page