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
Open your Excel report and navigate to the Jet tab.
Click on the NL function under the Tools section.
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