ONYX REPORTING LTD.
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
Search

5 Ways to Sort Jet Reports

12/6/2017

1 Comment

 
If your Jet Report has ever suddenly stopped working ("it was fine and all of a sudden...") many times it can be attributed to behaviors that can cause spreadsheet corruption.  The most common culprit? Changing the structure of the spread sheet ex.
  • Inserting Columns or Rows 
  • Moving Columns or Rows around OR
  • CHANGING THE SORT ORDER OF YOUR REPORT!
Picture
In the follow 45 minute tutorial, I demonstrate 5 alternatives that will NOT corrupt your workbook.
  • Values Only Workbook (scheduler)
  • Table Builder and NL("table") functions
  • Applying a basic sort
  • Grouping
  • Implementing dynamic sorting

Warning:  Shameless Plug.

This presentation was inspired by a client who emailed me just before the weekend.  Feel free to pass your questions along, who knows, you may get an extended tutorial out of it!

Alternatively, if you need onsite training and/or a bunch of reports developed, we do have a summer sale for onsite days with additional discounts for non profit organizations.  

​Interested?  Give us a holler.
Picture
1 Comment
Danny
14/4/2020 01:02:04 pm

Hi, I know this is old, but just wanted to let you know that I found this very useful for creating Jet reports.

Reply

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
    Domo
    Excel Tricks
    Executive Training & Leadership
    Extract
    Jet Enterprise
    Jet Essentials
    New Release
    NP Function
    Onyx Reporting
    Planning
    Power Pivot
    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