1 17000032881 2016-11-17T13:07:29-07:00 All support articles, how-to questions, troubleshooting... 17000121680 false Support 3 2016-11-17T13:07:29-07:00 1 1 2016-11-17T13:15:27-07:00 0 0 When using the Jet Web Portal for distributing/accessing reports there can be an exclamation mark appear if there is an error running the report.  To troublshoot you must run the report by using "Diagnostic Run". To do this, click on the report with the error status, on the Jet Web Portal, click Details at the bottom of the page. Click Diagnostic Run Once the Diagnostic Run has completed, click the Download button. Download and view the report.  You can select the cell with the #Value and view the comments which provide additional information as to what can cause the report to not run.  As an example: In this example, the common missing setup is to ensure that the SQL user permissions for db_datareader is granted.  Again, in this example: It appears that login failed for the user account 'ODT\wilma' does not have access to the NAV database. This error Login failed foruser 'DOMAIN\UserID' generally occurswhen the user is created on the database directly but not granted db_datareaderpermissions. In some cases the user can be granted db_datareader permissionsand will be able to connect. The best practice is to remove the user from the databasesecurity and recreate the user in the root security of the SQL Server and mapthe user to the NAV database with db_datareader permissions. For additional information on Jet Reports Web Portal see https://jetsupport.jetreports.com/hc/en-us/articles/221031088-Jet-Web-Portal <div dir="ltr"> <p>When using the Jet Web Portal for distributing/accessing reports there can be an exclamation mark appear if there is an error running the report.  To troublshoot you must run the report by using "Diagnostic Run".</p> <p><br></p> <p><span style='font-size: 10.5pt; font-family: "Lucida Sans Unicode", sans-serif; color: rgb(43, 46, 47);'>To do this, click on the report with the error status, on the Jet Web Portal, click <strong>Details</strong> at the bottom of the page.<br>Click <strong>Diagnostic</strong> <strong>Run</strong><br>Once the Diagnostic Run has completed, click the <strong>Download</strong> button.</span></p> <p><br></p> <p>Download and view the report.  You can select the cell with the #Value and view the comments which provide additional information as to what can cause the report to not run.  As an example:</p> <p><span style='font-size: 10.5pt; font-family: "Lucida Sans Unicode", sans-serif; color: rgb(43, 46, 47);'><img id="_x0000_i1025" src="https://jetreports.zendesk.com/attachments/token/iFO56ruujSiFP7kFKUWIRb2j4/?name=inline-759261060.png" style="height: 267px; width: 613px;" class="fr-dii fr-draggable"></span><br></p> <p><span style='font-size: 10.5pt; font-family: "Lucida Sans Unicode", sans-serif; color: rgb(43, 46, 47);'><br></span></p> <p><span style='font-size: 10.5pt; font-family: "Lucida Sans Unicode", sans-serif; color: rgb(43, 46, 47);'>In this example, the common missing setup is to ensure that the SQL user permissions for db_datareader is granted.  Again, in this example:</span></p> <p><span style='font-size: 10.5pt; font-family: "Lucida Sans Unicode", sans-serif; color: rgb(43, 46, 47);'><br></span></p> <p><span style='font-size: 10.5pt; font-family: "Lucida Sans Unicode", sans-serif; color: rgb(43, 46, 47);'>It appears that <strong>login failed </strong>for the user account 'ODT\wilma' does not have access to the NAV database.<br>This error Login failed foruser 'DOMAIN\UserID' generally occurswhen the user is created on the database directly but not granted db_datareaderpermissions. In some cases the user can be granted db_datareader permissionsand will be able to connect. <br><br>The best practice is to remove the user from the databasesecurity and recreate the user in the <strong>root security </strong>of the SQL Server and <strong>mapthe user to the NAV database</strong> with <strong>db_datareader </strong>permissions.</span><span style='font-size: 10.5pt; font-family: "Lucida Sans Unicode", sans-serif; color: rgb(43, 46, 47);'><br></span></p> <p><span style='font-size: 10.5pt; font-family: "Lucida Sans Unicode", sans-serif; color: rgb(43, 46, 47);'><br></span></p> <p><span style='font-size: 10.5pt; font-family: "Lucida Sans Unicode", sans-serif; color: rgb(43, 46, 47);'>For additional information on Jet Reports Web Portal see </span><a href="https://jetsupport.jetreports.com/hc/en-us/articles/221031088-Jet-Web-Portal" target="_blank">https://jetsupport.jetreports.com/hc/en-us/articles/221031088-Jet-Web-Portal</a></p> <p><span style='font-size: 10.5pt; font-family: "Lucida Sans Unicode", sans-serif; color: rgb(43, 46, 47);'><br></span></p> <p><span style='font-size: 10.5pt; font-family: "Lucida Sans Unicode", sans-serif; color: rgb(43, 46, 47);'><br></span></p> </div> 17000121680 697 17000035207 2018-01-26T15:51:44-07:00 17000265439 1 Troubleshooting Jet Reports Web Portal Report Errors Troubleshooting Jet Reports Web Portal Report Errors Jet Reports,Troubleshooting,Web,Portal,Diagnostic,Run,Error,SQL,Permissions 2 0 0 Troubleshooting Jet Reports Web Portal Report Errors 2016-11-17T13:15:27-07:00 17000265439 1 2017-07-20T11:23:11-06:00 1 0 Typically Jet Reports simply work as expected subsequent to an upgrade.  The intention of this article is to provide suggestions of things to review if they do not! Changed Field Captions/Names After an upgrade there are sometimes minor field name changes.  Your reports may need to be updated to account for these new changes.  An example would be the changing of Kitting to Assembly. Deprecated Functionality After an upgrade there are sometimes there is functionality dropped from NAV.  Your reports may need to be updated to account for these new changes.  An example would be Bizflow. Blank Filtering using @@ Change Cell references when using the @@ to check for blank fields and ensure that the "@@"& is used at the front of the reference.  For example: =A3&"@@" should be changed to ="@@"&A3 Jet Support Article to reference - https://jetsupport.jetreports.com/hc/en-us/articles/218953728-Blank-Filters-using-and-other-techniques <p><br></p><p>Typically Jet Reports simply work as expected subsequent to an upgrade.  The intention of this article is to provide suggestions of things to review if they do not!</p><p><br></p><p><strong>Changed Field Captions/Names</strong></p><p>After an upgrade there are sometimes minor field name changes.  Your reports may need to be updated to account for these new changes.  An example would be the changing of Kitting to Assembly.</p><p><br></p><p><strong>Deprecated Functionality</strong></p><p>After an upgrade there are sometimes there is functionality dropped from NAV.  Your reports may need to be updated to account for these new changes.  An example would be Bizflow.</p><p><br></p><p><strong>Blank Filtering using @@</strong></p><p>Change Cell references when using the @@ to check for blank fields and ensure that the "@@"&amp; is used at the front of the reference.  For example:</p><p>=A3&amp;"@@" should be changed to ="@@"&amp;A3</p><p>Jet Support Article to reference - <a href="https://jetsupport.jetreports.com/hc/en-us/articles/218953728-Blank-Filters-using-and-other-techniques" target="_blank">https://jetsupport.jetreports.com/hc/en-us/articles/218953728-Blank-Filters-using-and-other-techniques</a></p> 17000121680 130 17000055748 2017-07-20T11:23:11-06:00 17000265439 3 Reports not working after upgrade of Jet Reports Reports not working after upgrade to later version of Jet Reports Jet,Reports,Report,Design,Error,Upgrade 2 1 0 Reports not working after upgrade to later version of Jet Reports 2017-07-20T11:23:11-06:00 17000265439 1 2018-01-26T15:51:14-07:00 0 0 The following link is a handy page to view and download the latest edition but also historical versions of Jet Reports. Jet Reports Downloads Click here to download the latest version of Jet Reports Professional. Click here to download the latest version of Jet Reports Enterprise. Download prior visions from the following link: http://download.jetreports.com/installation/versions/ <p style="">The following link is a handy page to view and download the latest edition but also historical versions of Jet Reports.</p><p style=""><br></p><h1 style="">Jet Reports Downloads</h1><p><br></p><p><br></p><h3><a href="https://go.jetreports.com/jetproinstall">Click here to download the latest version of Jet Reports Professional.</a></h3><h3><a href="http://go.jetreports.com/jetenterpriseinstall">Click here to download the latest version of Jet Reports Enterprise.</a></h3><p><br></p><p style=""><br></p><h3 style="">Download prior visions from the following link:</h3><p style=""><br></p><p style=""><a href="http://download.jetreports.com/installation/versions/" rel="noreferrer noopener" target="_blank"><strong><span style="font-size: 16px;">http://download.jetreports.com/installation/versions/</span></strong></a></p> 17000121680 138 17000066366 2018-01-26T15:51:14-07:00 17000265439 4 Jet Reports Current and Historical Product Downloads Jet Reports Current and Historical Product Downloads Jet,Reports,Professional,Essentials,Enterprise,Download 2 0 0 Jet Reports Current and Historical Product Downloads 2018-01-26T15:51:14-07:00 17000265439 1 2018-01-29T11:32:41-07:00 0 0 Release Notes For Jet Professional What's New? Jet Professional (including the Jet Excel add-in, the Jet Web Portal, and the Jet Service Tier) receives updates on a regular basis. Click this link to see What's New in the most recent Major release of Jet Professional. See below for the changes that have been made for each chronological release. The following link provides Jet Reports Release Notes https://jetsupport.jetreports.com/hc/en-us/articles/223125607-Release-Notes-for-Jet-Professional Looking for the current and historical product downloads?  See: https://support.opendoorerp.com/solution/articles/17000066366-jet-reports-current-and-historical-product-downloads <h1 style="">Release Notes For Jet Professional</h1><p style=""><br></p><h3 style=""><strong>What's New?</strong></h3><p style=""><br></p><section><p style="">Jet Professional (including the Jet Excel add-in, the Jet Web Portal, and the Jet Service Tier) receives updates on a regular basis.</p> <p style="">Click this link to see <a href="https://jetsupport.jetreports.com/hc/en-us/articles/223092767" rel="noreferrer noopener">What's New in the most recent Major release of Jet Professional</a>.</p> <p style="">See below for the changes that have been made for each chronological release.</p></section><h3 style=""><br></h3><h3 style=""><strong>The following link provides Jet Reports Release Notes</strong></h3><p style=""><br></p><p style=""><a href="https://jetsupport.jetreports.com/hc/en-us/articles/223125607-Release-Notes-for-Jet-Professional" rel="noreferrer noopener" target="_blank">https://jetsupport.jetreports.com/hc/en-us/articles/223125607-Release-Notes-for-Jet-Professional</a></p><p style=""><br></p><p style="">Looking for the current and historical product downloads?  See:</p><p style=""><a href="https://support.opendoorerp.com/solution/articles/17000066366-jet-reports-current-and-historical-product-downloads" rel="noreferrer noopener" target="_blank">https://support.opendoorerp.com/solution/articles/17000066366-jet-reports-current-and-historical-product-downloads</a></p> 17000121680 159 17000066418 2018-01-29T11:32:41-07:00 17000265439 5 Jet Reports for Professional (Essentials) Release Notes Jet Reports for Professional (Essentials) Release Notes Jet,Reports,Professional,Essentials,Product,Release,Notes,Documentation 2 0 0 Jet Reports for Professional (Essentials) Release Notes 2018-01-29T11:32:41-07:00 17000265439 1 2018-06-01T09:37:35-06:00 0 0 The Annual Enhancement Program Includes:   All new Jet Reports version releases and upgrades 24/7 access to Jet Reports Support Site for technical assistance and troubleshooting Online knowledgebase access License changes including licensed user changes Access to videos and tutorials Report template library and new report releases The Jet Reports Annual Enhancement Plan gives you access to all the latest resources listed above and ensures your Jet Reports solution will always be working for you, when you need it. New releases include compatibility upgrades with the latest Microsoft Office and Microsoft Dynamics versions, along with enhanced feature releases designed to meet the evolving reporting needs of our customers. Named license users can be quickly and easily updated to reflect changes to your organization’s personnel. For free tips, tricks, and more, register for the Jet Reports Success Webinar Series! For more information, please contact us. <h3>The Annual Enhancement Program Includes:</h3><p> </p><ul><li>All new <a href="https://jetsupport.jetreports.com/hc/en-us/articles/223092767-What-s-New-in-Jet-Professional" rel="noreferrer noopener">Jet Reports version releases</a> and upgrades</li><li>24/7 access to Jet Reports <a href="https://jetsupport.jetreports.com/" rel="noreferrer noopener">Support Site</a> for technical assistance and troubleshooting</li><li><a href="https://jetsupport.jetreports.com/" rel="noreferrer noopener">Online knowledgebase</a> access</li><li>License changes including licensed user changes</li><li>Access to <a href="https://jetsupport.jetreports.com/hc/en-us/articles/218954018-Jet-Professional-Videos" rel="noreferrer noopener">videos and tutorials</a></li><li><a href="https://www.jetreports.com/p/jet-reports-report-players/" rel="noreferrer noopener">Report template library</a> and new report releases</li></ul><p style=""><br></p><p style="">The Jet Reports Annual Enhancement Plan gives you access to all the latest resources listed above and ensures your Jet Reports solution will always be working for you, when you need it. New releases include compatibility upgrades with the latest Microsoft Office and Microsoft Dynamics versions, along with enhanced feature releases designed to meet the evolving reporting needs of our customers. Named license users can be quickly and easily updated to reflect changes to your organization’s personnel.</p><p style=""><br></p><p style=""><strong>For free tips, tricks, and more, register for the <a href="https://www.jetreports.com/success-webinar-series/" rel="noreferrer noopener" target="_blank">Jet Reports Success Webinar Series</a>!</strong></p><p style=""><strong>For more information, please <a href="https://www.opendoorerp.com/contact/" target="_blank" rel="noreferrer noopener">contact us</a>.</strong></p><p style=""><br></p> 17000121680 108 17000073263 2018-06-01T09:37:35-06:00 17000265439 6 Jet Reports Annual Enhancement Program Explanation of the Jet Reports Enhancement benefits. Jet Reports, Annual Enhancement,AEP,Why,What 2 0 0 Jet Reports Annual Enhancement Program (AEP) 2018-06-01T09:37:35-06:00 17000265439 1 2020-04-15T16:53:34-06:00 0 0 Scheduling Consideration Have you come across instances where your scheduled reports have not been created?   How about instances where some scheduled reports were created but not others on the same day? Ar present scheduled reports should be spread out over different time intervals.  This is because the Jet Hub Scheduler does not handle multiple reports running at the the same time. If you have a report that takes 30 mins to run and it is scheduled to run at 8:00am then you should schedule your next report for at least 30mins later.  This will ensure that they do not overlap and the Jet Hub will successfully run your Jet Reports. <p><strong><span style="font-size: 13px;">Scheduling Consideration</span></strong></p><p><br></p><p>Have you come across instances where your scheduled reports have not been created?  </p><p><br></p><p>How about instances where some scheduled reports were created but not others on the same day?</p><p><br></p><p>Ar present scheduled reports should be spread out over different time intervals.  This is because the Jet Hub Scheduler does not handle multiple reports running at the the same time.</p><p><br></p><p>If you have a report that takes 30 mins to run and it is scheduled to run at 8:00am then you should schedule your next report for at least 30mins later.  This will ensure that they do not overlap and the Jet Hub will successfully run your Jet Reports.</p><p><br></p><p><br></p> 17000121680 61 17000102603 2020-04-15T16:55:37-06:00 17002568458 7 Jet Hub Scheduler Failure The Jet Hub Scheduler does not work when reports are scheduled at the same time 2 0 0 Jet Hub Scheduler 2020-04-15T16:55:37-06:00 17002568458