Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

The Jet Function Wizard (Jfx)

This article mainly discusses the Jfx feature of Jet Reports.  The GL concepts are also applicable to Jet Basics

Related Articles...

Overview

In the Jet Reports , the Jfx offers the ability to add all four Jet Functions ( NL , GL , NF , and NP ).

In Jet Basics , you can use the Jfx to add a GL function.

  1. Once you click on one of the options for the Jfx, the Jfx window defaults to that particular function (you can change this if you wish)...

    jfx_choices.png

  2. You are presented with the list of parameters for the function you chose (e.g., What , Table , and Field ).

    Clicking the arrow next to the What parameter will give you a list of possible arguments for that parameter:

  3. When you click the arrow next to the Table parameter you will get a Lookup window with a list of tables in your database.

  4. Similarly, clicking the arrow next to the Field parameters will give you a lookup window with a list of the fields in that table.

  5. To reference a cell for the FilterField parameter:  With the cursor in the FilterField parameter, click on the appropriate cell in your worksheet.

    filter_cell.png

  6. When you click the Evaluate button at the top of the Jfx window, you will get an approximate result for your function.

    This approximate result is the same as the result you will see in Design mode before you run your report and may not be accurate (always Run the report to ensure accuracy).

When you click OK , your function will be inserted into the active cell on your worksheet.

Related Articles

Published:

The Jet Function Wizard (Jfx)

This article mainly discusses the Jfx feature of Jet Reports.  The GL concepts are also applicable to Jet Basics

Related Articles...

Overview

In the Jet Reports , the Jfx offers the ability to add all four Jet Functions ( NL , GL , NF , and NP ).

In Jet Basics , you can use the Jfx to add a GL function.

  1. Once you click on one of the options for the Jfx, the Jfx window defaults to that particular function (you can change this if you wish)...

    jfx_choices.png

  2. You are presented with the list of parameters for the function you chose (e.g., What , Table , and Field ).

    Clicking the arrow next to the What parameter will give you a list of possible arguments for that parameter:

  3. When you click the arrow next to the Table parameter you will get a Lookup window with a list of tables in your database.

  4. Similarly, clicking the arrow next to the Field parameters will give you a lookup window with a list of the fields in that table.

  5. To reference a cell for the FilterField parameter:  With the cursor in the FilterField parameter, click on the appropriate cell in your worksheet.

    filter_cell.png

  6. When you click the Evaluate button at the top of the Jfx window, you will get an approximate result for your function.

    This approximate result is the same as the result you will see in Design mode before you run your report and may not be accurate (always Run the report to ensure accuracy).

When you click OK , your function will be inserted into the active cell on your worksheet.

Related Articles

For an optimal Community experience, Please view on Desktop