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...

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...

When a Jet Report encounters a data error, you get a generic error message that is not at all helpful. Then I have to start digging. Per the support topic: Error: The Pivot Table 'PivotTableX' Could Not Be Refreshed...'Reference Is Not Valid.': ht...

There is the possibility to use "SUM(<fieldname>)" as a field parameter in the NL function for universal datasources to make sorting/filtering on aggregated data possible. I was surprised to see that "COUNT(<fieldname>)" generated an e...

Right now i dont have the ability to sort the data in my dashboard windows, especially when i am comparing 2 years. For example if i am comparing the sales of my top 10 customers (2018 vs 2019). It sorts it by the total of the 2018 and 2019 sales,...

Often customer wants salesinvoicelines and salesceditnotelines. and if it needs to be fast you use table builder. but since it's 2 different table you can't combine them. and then you can't get them in the same pivot afterwards. i would be really ...

See support ticket 80677

Make +Lock and Data Validation work together. When the cell is locked, data validation doesn't work. (Attached example does not require any particular data source.)

As an end user it would be nice if Jet Essentials would apply specific formatting based on the data type being pulled from the database. For example, when pulling in a date field instead of returning the Julian format (ie: 42431) it would be nice ...

It would be nice to create more dynamic reports where the user can select a dimension from a dropdown list in the options page and then use a replicator to list these out across rows, columns, or sheets. This would make it easy to use a single rep...