When a workbook is taking too long to calculate one often tries to Cancel the calculation. Unfortunately, the cancellation often takes longer than letting the original calculation continue. This should not be so. Cancel should mean Cancel. Upon re...

When using Jet with a NL(Sum) on a SQL datasource (Exact Online) through a CData ODBC driver, the result is a statement with a lot of ‘OR’ clauses. This causes a recursion error. We asked CData on how to bypass this, and here is what they suggest:...

It would be great to somehow encapsulate the Sort by Sum (or count) functionality located here (https://docs.jet.insightsoftware.com/hc/en-us/articles/25815129463565-Sort-by-Sum-or-count-with-Dynamics-NAV-and-Business-Central) into a Jet function....

As a designer I would like to have an option to show a calendar in Report Options window when users run a report (Capture0.png). I think it should be displayed after the marked arrow is clicked (Capture1.png). That will probably require a new keyw...

IT would be useful to be able to run a report and save as a PDF from the portal. Then the user can open it and it will simply render as a PDF in the webpage rather than having to download an Excel workbook

Currently functionality is Jet automatically removes autofilters across the whole application. There are some reports where AutoFilters breaks Jet (replicating rows) and some where it does not (static reports like financial statements). Would like...

Auto-fill of fields in JFx. So instead of using the dropdown to get the list of fields and then start typing, they just want to start typing and have the dropdown appear that way Customers really want this. Remembering to show the list first is ...

As a new function, consider NP(User). This function would retrieve the Windows User ID currently running Jet and provide it as a potential filter to use in NL(Rows) and other functions. The advantage here is that retrieved results could be limited...

This would save the additional steps required to manually type in a date range filter after drilling down from a cell in a Jet report that is using the FlowFilter (Date Filter) field- each time you drill down from a cell in one of these reports.

I suggest be beneficial to have the ability to lookup the table and field numbers in the NL function wizard when using a NAV data source. I know that you can just write the numbers in the NL function, but that doesn't give you the table or field n...