Topic
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 the pieceWe 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 the pieceReport 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 the pieceIt’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 the pieceWe 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 the pieceWhen 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 the pieceIf 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 the pieceSome 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 the piece
