top of page
Jet Reports

How to Create a Report in Excel using the NL (Rows) Function

In this guide, we will show you how to use the NL (Rows) function to create a report in Excel. The NL function is a powerful tool that allows you to display values from your database on your report. Using this function, you can create reports showing specific information clearly and concisely. The NL (“Rows“) function inserts a new row for each value in the database. We will now display a list of Customer Names using the NL (Rows) function.

Join On Point Academy to view all content

Step 1: Open Your Excel Report and Navigate to the Jet Tab

First, open your Excel report and navigate to the Jet tab. The Jet tab is where you will find the NL function, which you must use to create your report.

Step 2: Click on the NL Function

Once on the Jet tab, navigate to Tools and click on the NL function. This will bring up a drop-down menu where you can configure the function to display the information you want on your report.

Step 3: Fill in the NL Function

In the drop-down menu, fill in the NL function as follows:

  • In the "What" tab, select Rows as you want to display each value retrieved from the database on a new row.

  • In the "Table" tab, select the table that contains the data you want to display.

  • In the "Field" tab, select the field that contains the data you want to display.

Step 4: Click on "OK"

Once you have filled in the NL function, click "OK". This will generate a report that displays the information you have selected.


Step 5: Add a Column Name to Your Report

Add a column name to make your report easier to read and understand. You can do this by selecting the cell above your NL function and entering a title in the appropriate field.

Step 6: Run Your Report

Once you have added a title to your report, run it to see the information you have selected displayed clearly and concisely.

Get trained
the On Point way

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