jetreports

jetreports

16 Dec 2023 · 2 min read

Jet Reports 101 - Using more than 10 filters in an NL() function

When working with the NL() function, you can apply multiple filters to refine the data you retrieve. However, situations may arise where you need to exceed this limit and apply more than the maximum 10 filters that Jet Reports allows. This is where the FILTERS= special filter comes into play.

Read more

jetreports

19 Mar 2023 · 3 min read

Jet Reports 101 - Other Features of =NL(Lookup)

We all know that the =NL (Lookup) function is used to pull a list of values from a database, but there's a few features of it that are probably not as often used. Let's take a look.

Read more

jetreports

10 Nov 2022 · 4 min read

Jet Reports 101 - Creating User Defined Options

Report options are a powerful way of adding customisability to your reports that means you don’t have to have a designer to put a report into design mode to change a parameter or filter. So let’s see how we create them.

Read more

jetreports

7 Nov 2022 · 6 min read

Jet Reports 101 - Scheduling Reports with Jet Scheduler

It’s safe to say that any opportunity to automate a report is an opportunity I always pounce on. The Jet Scheduler is a powerful tool that allows you to schedule reports to be automatically run by the Windows Task Scheduler.

Read more

jetreports

3 Nov 2022 · 4 min read

Jet Reports 101 - Row 1 & Column A… what CAN you use it for?

We see tutorials and instructions state that Jet Reports uses Column A and Row 1. But what can we use this row and column for? Let's find out!

Read more

jetreports

31 Oct 2022 · 3 min read

Jet Reports 101 - NL(Filter) vs. LINK=

When writing reports, you may find that you need to filter your data based on information stored in a separate table. Let's take a look at how to do this in Jet Reports.

Read more

Excel

25 Oct 2022 · 2 min read

Jet Reports 101 - Evaluating Formulas NP(Eval)

If too much reliance is put on volatile functions, it can make recalculation times slow in Excel alone - when you couple that with Jet reporting it can compound the issue further.

Read more

data-analysis

10 Oct 2022 · 4 min read

Jet Reports 101 - Improving Performance

Some reports can run in a matter of seconds, but if it is not built following ‘best practice’ guidelines, over time it can grow into an unoptimised mess that takes MUCH longer to run. This article will explore some of the most impactful ways to streamline a Jet report.

Read more