A common usability issue is not selecting the correct field in a filterfield input to link data from one table to another. Adding indication for which field is the table key in the list of FilterFields will help users choose the right one when per...

Today while using the internal report portal for JRI I ran the Partner Overview report. This report has a filter by Partner name and in the UK we have around 60+ partners listed. I had to use the scroll bar to find the partner name needed as a fil...

The Table Builder is a great starting Point for a table that is finally used as the base data of an Pivot table. However, to show in the Pivot able the Information like customer nr + customer Name in one row (for example "10000 - Meller Industries...

You can define an Excel range or named range as a table source for the NL function, but there is no way to filter on that range. By parsing the number of columns in the table range, you could expose an implicit fields list ColA, ColB, ColC, etc an...

(email from Miha) I see this happening more and more. Our clients are using PivotTables only, and when asked to refresh, they go to Jet tab and click refresh. That takes waaaaaaaay longer (since Jet checks for any formulas, replicators, etc), not ...

When a Jet Report is generated from the Hub, the manual page breaks do not replicate with the rows. When reports are printed, they will not page break as epxpected. There is an option in the Jet Client (App Settings - Excel - Preserve Page Breaks)...

For one of my customers, I've implemented a 2D code from the IDAutomation Data Matrix Font and Encoder Suite in a warehousing report: =@IDAutomation_DMatrix_FontEncoder($P13) This is working, but I've encountered severe performance issues when com...

It is a typical requirement to add some text from Excel into a word document (sometimes mid-sentence, and multiple occurrences of the same piece of data), and it would be useful to choose whether the source document formatting or the destination d...

I recently copied a series of similar formula columns from one Jet Report to another and accidentally copied a field column that did not exist in the new Jet Report. When it ran, I got the generic Pivot Table could not be refreshed error. But ther...