Jet Essentials - NL(Filter), NP(Integers) and Dynamic Replication

I was corresponding with a former colleague at Jet Reports US, Steve Little, and he shared this fantastic report.  The general gist of the report is to Print Mailing labels on Avery 5160 paper for Christmas cards!

If you ask any Jet Reports consultant, they'll tell you, writing the report is never the problem.  Formatting it for printing especially multipage printing is a pain!  

Steve uses a classic technique described in summary below:  

Count the number of qualifying records do display and identify how many records to fit per page.
Identify how many Pages to print, then replicate the report with NL("sheets")
On each page, use 'Excel Number Magic' to calculate which record to start on.
Then use a series of NL("nth") functions to show the 1st, 2nd, 5th, nth Record.  

It's really quite clever! 

If you're interested in honing your skills for the Jet Certification exams take a look at the use of:
 
NL("Filter") to create an Array of customers
     note the use of  the Filters= keyword to quickly select an array of Filter criteria


NP("Integers") to replicate numbers in the NL("Sheets") function.
    note the use of named cell references 

essentials_-_nav_-_customer_labels_for_avery_5160_labels_-_original.xlsx
File Size:	23 kb
File Type:	xlsx

Download File

---

Steve was so excited about the report, he encouraged me to share it with my customers and fellow bloggers, so feel free to distribute it!

But, be advised, the report would be suitable for printing on one specific type of paper and label size.  

I personally am too lazy to make a version for A4 and A5, so I thought, why not find a dynamic way where the user can identify how many rows they want in their report (as opposed to a fixed 30 records per page).

At the end of it all, it's really just the same report with some fancy Excel math and expanded replication regions which we learned from grouping reports -- NL("rows=6").

essentials_-_nav_-_customer_labels_for_avery_5160_labels_-_finished.xlsx
File Size:	15 kb
File Type:	xlsx

Download File

---

DISCLAIMER:  I am not the originator of this report.  Steve Little and his team at Jet Reports US originally developed this report.  I'm blogging about it to provide a learning opportunity for up and coming consultants and report writers.

If you have any questions about the techniques used, please don't be a stranger.  Email me at Jae@OnyxReporting.com