Home > Crystal Report > Crystal Report Error Code 723

Crystal Report Error Code 723

Reply Industries Education Government Health Discrete Manufacturing Hospitality and travel Retail and consumer goods For customers Small and midsize businesses Enterprise Envision Microsoft Ignite Microsoft AppSource For partners Microsoft partner resources I've seen this type of error when the source for a report is a stored procedure and the stored procedure doesn't return any data. We have on the company I work for an application built in Delphi V with Crystal Reports 8. Hmm. check my blog

Failed to retrieve data.... Jon Jacobs Gert de Boom Delphi Developer 2007-01-07 07:36:49 PM Re: Delphi 7 and Crystal 9, Error 723 Although I'd say that the driver and databasefieldtype are probably not The problem was the link to a table I added to the report - I added the table to the report, so that I could use fields from that table as mlmcc 0 LVL 1 Overall: Level 1 Message Author Comment by:Quadeeb20032005-07-28 Comment Utility Permalink(# a14546806) That is what I was thinking, but I didn't know where to start. https://scn.sap.com/thread/3327016

varchar(8) Quote By the way: what driver (OLE DB, ODBC, Native) do you use in ODBC Quote to the database? This is the SQL query that was created SELECT "tblServiceOrders"."SONumber"FROM "Samplev10"."dbo"."tblServiceOrders" "tblServiceOrders" Thanks for any help IP Logged hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3507 share|improve this answer answered Sep 24 '14 at 13:49 atik sarker 927817 Would you explain why this helps? –Apostrofix Jan 12 '15 at 13:07 add a comment| Your Answer The COM object for CR.

Issue resolved as i switch to each sub report and make it verify again with database/tables/views. Connect with top rated Experts 15 Experts available now in Live! Details: [Database Vendor Code: 4104]. I can grant permissions to MSDSL no problem..

When I limit the browser window to just one item, the item I would like to run the report for, I get the error above. Look in the "Sources & Demos" section. I suspect a problem with the data collection process. https://www.experts-exchange.com/questions/21507616/Crystal-Reports-Engine-Error-723-Failed-to-retrieve-data-from-the-database.html Doing the ODBC DSN fix works sometimes, but this one (x 3 reports) did not work.

E non sono sicuro della seconda (Einstein) IP Logged Printable version Forum Jump -- Select Forum -- Announcements Talk with the Author Self-Publishing Job Postings New feature request Report Design Data All Rights Reserved. Re: ADO Search Question. (Some Error) Google Grupları Tartışma Forumları'nı kullanmak için lütfen tarayıcı ayarlarınızda JavaScript'i etkinleştirin ve sonra bu sayfayı yenileyin. . I suspect the same issue as with moving away from ODBC, but you caught my interest.

Thanks !! We are using MS SQL SERVER 2008 R2 And I tried you steps to getting the correct permission setings, but it does not display the grant script not sure if that share|improve this answer answered Dec 30 '08 at 17:05 Philippe Grondier 7,93721753 add a comment| up vote 0 down vote Every time you add a new table in crystal it adds Not the answer you're looking for?

Can any of you experts help me here? 500 pts. 0 Comment Question by:Quadeeb2003 Facebook Twitter LinkedIn Email https://www.experts-exchange.com/questions/21507616/Crystal-Reports-Engine-Error-723-Failed-to-retrieve-data-from-the-database.htmlcopy LVL 100 Active today Best Solution bymlmcc Sounds like a permissions problem click site By using this site, you accept the Terms of Use and Rules of Participation. End of content United StatesHewlett Packard Enterprise International CorporateCorporateAccessibilityCareersContact UsCorporate ResponsibilityEventsHewlett Packard LabsInvestor RelationsLeadershipNewsroomSitemapPartnersPartnersFind a PartnerPartner I don't know how we would have gotten to that from the reports not working. I have experienced OLE DB to be more stable then ODBC connections.

Just another possible solution to add to the KB. Tags: "SL Error" "Crystal Report" SQL Server 2005 Microsoft Dynamics SL report Crystal Reports Reply All Responses (2) DavidSL65 DavidSL65 responded on 11 Jul 2011 11:08 PM Sorry to drag up more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed news Jens Fichtner March 15, 2013 at 10:55 AM 0 Likes Correct Answer Don Williams replied March 18, 2013 at 20:41 PM Error 723 means: PE_ERR_OPENROWSET               723And to add to Ludek's info

This works usually fine.The following things have been tried:=> Checking / Validating database: No errors found=> Extracting the SQL command and trying to run it on the SQL Server: successful=> Giving Solved Crystal Reports Engine Error# 723 Failed to retrieve data from the database. Jon Gert de Boom Delphi Developer 2007-01-09 04:13:50 AM Re: Delphi 7 and Crystal 9, Error 723 Quote Hmm.

I want to make a report with data that is stored on another server that is not Dynamics, but it can run from Dynamics.

I'm facing the same error message and can't seem to find a solution for it... –marc_s Jul 26 '10 at 13:41 Unfortunately the report was rewritten, and in that Important line in it is: table.Location = Database & ".dbo." & table.Name share|improve this answer edited Nov 4 '12 at 23:31 Jason Sturges 13.8k93662 answered Dec 8 '11 at 7:26 Muzee Error in File filename {9FEE6406-1613-409A-B9BD-C5FDA24E3DEE}.rpt: The rowset column could not be found. When Im in crystal reports XI, the preview run successfully with defaut data.When I try and run the report using my company's software, I get the following database error code (4104).

Can you run this report independantly with the same criteria and get a successful result? 0 LVL 1 Overall: Level 1 Message Author Comment by:Quadeeb20032005-07-28 Comment Utility Permalink(# a14547513) Copy/Paste these few bottom lines to new query window 5. See the Developers helpfile of Crystal. More about the author Still, you might give it a try.

Good luck! Some components may not be visible. MS does not support SQL 2008 using MDAC, those are the drivers you see in ODBC Drivers tab. When it runs it retrieves nothing, but it runs.

Why do I need HCl? If I can do this? CR has also the bad habit to create 'default' links each time you modify the list of tables and views needed for the report. From crystal I clicked on the preview screen and it displays the name of the report, and under that a list of possible people (documents to apply this report to).

All reports are written in C01, and whichever company you go to (C02 or C04) the reports run as the root is somehow substituted. Another option would be to change to the RDC component. share|improve this answer answered Sep 7 '10 at 2:53 Ken 1 add a comment| up vote 0 down vote I had this problem - we use SQL logins for our security