ONYX REPORTING LTD.
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
Search

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

4/12/2014

0 Comments

 
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 calcula
te 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
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Profile Picture Jae Wilson
    View my profile on LinkedIn

    Stay Informed.

    * indicates required

    RSS Feed

    Categories

    All
    Automation
    Basic Training Series
    Business Intelligence
    Connect
    Dashboard
    Data Pipeline
    Data Science
    Domo
    Excel Tricks
    Executive Training & Leadership
    Extract
    Jet Enterprise
    Jet Essentials
    New Release
    NP Function
    Onyx Reporting
    Planning
    Power Pivot
    Python
    Report Writing
    Statistics And Analytics
    TimeXtender
    Visualization

London, UK
jae@OnyxReporting.com
+44 747.426.1224
Jet Reports Certified Trainer Logo
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters