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.
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.
