Jet from insightsoftware

Special Characters in a Filter
Special Characters in a FilterHelp Topics... Overview Certain characters have specific meanings in queries and are considered to be special characters e.g., |   >   <   =    .  (   )   & If you need to include any of these characters as part of filter value then you need to precede the filter with "@@". The "@@" will pass the filter in as a literal st...
Filter Ranges and Excel
Filter Ranges and Excel Always enclose in quotes any ranges containing ".." that you type directly into a formula or into a parameter with the Excel function wizard. Without quotes, Excel may interpret your range as a set of values from the worksheet. For example, if you enter "49950..59950" (including the quotes), Excel will interpret the filter as a simple text string.  Withou...
Blank Filters - using @@ and other techniques
Blank Filters - using @@ and other techniquesHelp Topics... Overview Sometimes you want to filter an NL function based on the contents of another cell or the output of another NL function, where either of which could be a blank value. The NL function does not allow you to use blank filters, and you will get a #VALUE error message if you fill in a FilterField parameter and leave t...
Filter Syntax In Your Jet Reports
Filter Syntax In Your Jet ReportsRelated Articles... Overview When creating reports, it is important to have an basic understanding of how to apply filters to your queries so as to get exactly the data you want from your database. This reference provides the methods for applying various filter types ("not equal to", "greater than", "and", "or", etc.) to your Jet functions: ...
Creating a Filter to include XX* but exclude *YY
Creating a Filter to include XX* but exclude *YY Overview If you want to create a filter to include everything that starts with XX, but exclude everything that ends in YY, you have to use a combination of NL("Filter") and NP("Difference") functions. For example: You want a list of Job Numbers that begin with XX, but exclude all the job numbers that end in YY: =NL("Rows","...
Using more than 10 filters in an NL() function
Using more than 10 filters in an NL() functionHelp Topics... Overview Under typical usage, you can employ up to 10 filters in a single NL() function - e.g., NL("Rows") and NL("Table").  Occasionally, you may want to use more than 10. You can use the FILTERS= special filter. Example (note: this won't work) =NL("Rows","Customer",," No .","10000..999...
Speed up Dynamics GP reports by excluding inactive accounts
Speed up Dynamics GP reports by excluding inactive accounts Overview Jet Reports users can increase the speed of Dynamics GP financial reports by excluding inactive accounts. Many Dynamics GP users have large charts of accounts that include many accounts not currently in use.  Marking those accounts inactive can be an excellent way to make sure that these accounts will not clutter up—and...
First Page
Back
For an optimal Community experience, Please view on Desktop