NL Function Replicators in Jet Reports make it easy to create dynamic, automated reports directly in Excel. They allow you to replicate rows, columns, or entire worksheets based on data from your ERP or other connected sources; all while keeping formatting, layout, and formulas intact.
By using Replicators, you can save hours of manual work and build reports that update instantly with fresh data.
Types of NL Function Replicators
Row Replicators
-
Created using NL(“Rows”).
-
Automatically generates a list down rows.
-
Default region: one row.
-
Expandable by specifying the row count in the What argument.
-
Example:
"Rows=2"will replicate the current row and the one below it.
-
-
Perfect for reports where you need dynamic row-based listings, like invoices, sales orders, or customer transactions.
Column Replicators
-
Created using NL(“Columns”).
-
Generates a list across columns.
-
Default region: one column.
-
Expandable by specifying the column count in the What argument.
-
Example:
"Columns=2"will replicate the current column and the one to the right.
-
-
Useful for side-by-side comparisons such as monthly figures, budgets vs. actuals, or year-over-year data.
Sheet Replicators
-
Created using NL(“Sheets”).
-
Creates and inserts a new worksheet for every value in the result set.
-
Each worksheet is named after the returned value (adjusted to fit Excel’s naming rules).
-
The replicated region is always the entire worksheet.
-
Ideal for departmental reporting, customer statements, or regional breakdowns.
How Replicators Expand in Jet Reports
When switching to Report Mode:
-
Sheet Replicators expand first.
-
Then Column Replicators.
-
Finally, Row Replicators.
When you return to Design Mode, Jet Reports automatically removes all inserted rows, columns, or worksheets.
⚠️ Note: A replicator must be the only function in a cell. You cannot nest it inside another Excel formula (e.g., IF()).
For more flexibility, Jet Reports also supports Conditional Replication, which lets you apply rules for when replication occurs.
Conclusion
Jet Reports NL Function Replicators empower you to build dynamic, automated and professional reports in Excel; without needing complex coding or manual formatting. Whether you’re listing transactions, comparing data across columns, or creating separate worksheets per department, Replicators help you deliver reports faster and with greater accuracy.
By mastering Row, Column and Sheet Replicators, you’ll unlock the full potential of Excel-based reporting and give your team access to real-time, actionable insights.
If You Need Any Help, Contact us Now!
