Crystal Report Engine Error 723
Contents |
SAP Crystal Reports - Legacy SDKsWhere is this place located?All Places SAP Crystal Reports SAP Crystal Reports - Legacy SDKs 3 Replies Latest reply: Mar 19, 2013 9:05 AM by Jens Fichtner Tweet Error 723: Failed to query engine error in crystal report retrieve data from the database Jens Fichtner Mar 15, 2013 10:55 AM unknown query engine error in crystal report Currently Being Moderated Hi together,I'm currently facing a strange error within the Crystal XI "Runtime": I have a report which crystal reports print engine error is working in the development environment but it refuses to work in the production environment. It is a fairly simple report, just joining two tables from the database (and has a subreport crystal reports print engine error text which access another table). The "production environment" is a Custom Print Spooler written in Delphi 7 with the CR XI VCLs (which are working fine for all other reports). The report is accessing the database (MS SQL Server 2008 R2) via ODBC. This works usually fine.The following things have been tried:=> Checking / Validating database: No errors found=> Extracting the SQL command and trying to
Query Engine Error 42000 Crystal Report
run it on the SQL Server: successful=> Giving the report the "replaced qualified table names" (Google translation of "ersetzter qualifizierter Tabellenname" - I'm using the german CR here): no effect=> deleting the subreport: no effect=> Search for formula errors: No errors found (and the report was working fine in CR 8.5)The main reason to upgrade was the support for unicode. But in this one of all reports (which is unfortunately a quite important one) CR XI fails... (German) Error message is:Error:723 Fehler in der Datei (Path/Pfad)\BatchProt.rpt:Daten konnten nicht aus Datenbank abgerufen werden.Details: [Datenbankanbietercode: 156 ]Execute
365 for Enterprise Skype for business Microsoft Dynamics Microsoft Dynamics Sales Service Marketing Social Enterprise Resource Planning Small and Midsize Business Windows Windows 10 for business
Crystal Report Unknown Query Engine Error Error In File
Windows 10 for Internet of Things Windows devices Data and analytics Data management and analytics Microsoft SQL Server Microsoft Power BI Microsoft Cortana Intelligence Suite Operations management Operations Management Suite System Center Sign in Search Microsoft Search Dynamics Community Participate Ask a Question Get Started Badges Earn Badges View Badges Leaderboards Compete on Leaderboards View https://scn.sap.com/thread/3327016 Leaderboards Become an Expert Recommend a Blog Introduce Yourself Provide Feedback Communities Microsoft Dynamics AX Microsoft Dynamics CRM Microsoft Dynamics GP Microsoft Dynamics NAV Other Products Partner Community Dynamics Community Microsoft Dynamics SL Forum Blogs Videos Experts Support Dynamics Community Participate Ask a Question Get Started Badges Earn Badges View Badges Leaderboards Compete on Leaderboards View https://community.dynamics.com/sl/f/35/t/13705 Leaderboards Become an Expert Recommend a Blog Introduce Yourself Provide Feedback Communities Microsoft Dynamics AX Microsoft Dynamics CRM Microsoft Dynamics GP Microsoft Dynamics NAV Other Products Partner Community Microsoft Dynamics SL Forum Blogs Videos Experts Support "Crystal Print Engine Error: 723" when printing from Microsoft Dynamics SL 7 Sign In Share Twitter LinkedIn Facebook Email Print RSS IT2428 Question Status Unanswered IT2428 asked a question on 24 Feb 2009 12:13 PM When using Microsoft Dynamics SL to view a custom report that is linked to a custom view, table, or stored procedure and you get this error message...Cannot start print job. Report: C:\Program Files\Solomon\Usr_Rpts\CUSTOM.RPT Crystal Print Engine Error: 723 - Error in File C:\Program Files\Solomon\Usr_Rpts\CUSTOM.RPT: Failed to open a rowset....check to make sure you have set the correct permissions for access to your custom view, table, or stored procedure.You can run this SQL script (make sure you have proper backups in case you make an error) to set the permissions correctly after you
from GoogleSign inHidden fieldsSearch for groups or messages
this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 11 of 11 Thread: Custom Reporting Documentation? Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode March 9th, 2011,12:31 #1 Seanatron View Profile View Forum Posts Senior Member Join Date Aug 2007 Posts 125 Custom Reporting Documentation? Is there any documentation with regards to creating custom reports from queries? I've created a few reports that report straight from a single table, but when trying to actually write a query joining tables, every time the report is run it says that the log on parameters are incorrect. However, I'm using the same log on parameters/ODBC/credentials that the other reports are using. Do I need to create a view or stored procedure and run the report off of that? I apologize, but I am a complete n00b when it comes to Crystal Reports. Any help will be appreciated. EDIT: This database is used for our outbound dialer and is SQL Server 2005. Last edited by Seanatron; March 9th, 2011 at 15:11. Reply With Quote March 15th, 2011,12:37 #2 vbosnjak View Profile View Forum Posts Member Join Date Mar 2010 Location Nijmegen, The Netherland Posts 31 clarification Hi Seanatron, So you're using Crystal Reports straight from the desktop right? Like CR 2008 developer, or CR XI? 1) So you're joining tables coming from the same database right (i.e. I3_dialer)? 2) You're connecting Crystal Reports by using an ODBC connection which has been made on your local computer? 3) You didn't upload the report to a Crystal Reports Server or Business Objects Server? You open the report locally, right? 3) The ODBC connection on your computer provides sufficient rights to access the database? Vladimir Bosnjak - Reporting & Scripting Bosch Communications Center Nijmegen, The Netherlands Reply With Quote March 16th, 2011,13