Hi Jet Reports team,
I am getting this error when trying to run report "NAV014 - Trial Balance by Month" from Jet Express.
The pivot table 'PivotTable1' could not be refreshed. The following error was reported: 'Reference isn't valid.'
I have clicked the cell with #VALUE and clicked Show Error (Debug), but then I get to Execution Timeout Expired.
There have not been any modifications to the G/L Account table and the Excel file was downloaded with the Report Player as of the past week.
The Data Source is a direct connection to SQL, with NAV 2016 W1 Build 44974. The report runs for about 25 minutes before hitting the error. It runs for about five minutes when debugging and then hits the Execution Timeout.
Thanks for any support you can offer.