Home > Crystal Report > Crystal Report Error 723

Crystal Report Error 723

When the ip addresses were resolved the report worked. 0 LVL 100 Overall: Level 100 Crystal Reports 94 Message Active today Expert Comment by:mlmcc2005-07-29 Comment Utility Permalink(# a14560089) Interesting. By joining you are opting in to receive e-mail. Do you have access to the data underlying the report so you can check some of this out? 0 LVL 1 Overall: Level 1 Message Author Comment by:Quadeeb20032005-07-29 Comment Utility Copy/Paste these few bottom lines to new query window 5. Check This Out

Index Register Login You are not logged in. Join UsClose Skip to forum content Programmer's Town Welcome to the Programmer's Town community forums. Join Now For immediate help use Live now! 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 https://support.microsoft.com/en-us/kb/905310

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 Cycles, shade based on proximity to another object's geometry Why didn't Doctor Strange use the Eye of Agamotto to heal his hands? Doing the ODBC DSN fix works sometimes, but this one (x 3 reports) did not work.The problem was indeed the link to a table I added to the report - I Our original DSNs were located in the User tab.

They updated the name of the client dll to SQLNCLI10.dll and CR 2008 and above is the only versions that supports that extended client dll. It can even sometimes automatically create recursive links that might not be viewable 'at once' in the relations screen. Let me know. Join them; it only takes a minute: Sign up Crystal Reports - Failed to open a rowset up vote 7 down vote favorite What can be done to resolve the exception:

If you're interested in additional methods for monitoring bandwidt… Network Analysis Networking Network Management Paessler Network Operations Advertise Here 695 members asked questions and received personalized solutions in the past 7 Make a "Ceeeeeeee" program Can Mage Hand wield a Shield? 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 The report is accessing the database (MS SQL Server 2008 R2) via ODBC.

Privacy Policy Site Map Support Terms of Use Cloud Platform Stories Infrastructure Microsoft Azure Mobility Enterprise mobility Office mobility Windows mobility Microsoft Surface Microsoft Lumia Productivity Office Office 365 for business Database;//basis Crpe1.ParamFields. 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 I cant even get an unmodifiedtrial balance to open.

Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Click Script View/Table as - Create to - New Query Editor Window 3. BrianA Members Profile Find Members Posts MicrosoftDynamicsForums.com Member Joined: August012006 Location: United States Status: Offline Points: 13 Post Options Post Reply QuoteBrianA Report Post Thanks(0) QuoteReply Posted: March122007 at Create (Application); Crpe1.Clear; Crpe1.ReportName: = ' a way to reports '; Crpe1.Connect.

crystalReportViewer1.ReportSource = crReportDocument; } Posts [ 4 ] Pages 1 You must login or register to post a reply Programmer's Town »Databases »Crystal Report Engine Error 723 - Failed to open his comment is here Click Here to join Tek-Tips and talk with other members! Sponsored Links Rohtash Kapoor Members Profile Find Members Posts Visit Members Homepage MicrosoftDynamicsForums.com Moderator Joined: July062005 Location: United States Status: Offline Points: 656 Post Options Post Reply QuoteRohtash Kapoor Report Post Login.

I can grant permissions to MSDSL no problem.. Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects: Crystal ApplyLogOnInfo (crTableLogOnInfo); } //Set the viewer to the report object to be previewed. this contact form So, even if you add one field to that report and even SUPPRESS is, it will fix that error message (if this is the problem).

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 Posted on 2005-07-28 Crystal Reports 9 1 solution 4,191 Views Last Modified: 2008-02-20 My complete error: Crystal Reports Engine Error# 723 Failed to retrieve data from the database. 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)

Check to see if the report has any subreport.

Why don't my users have separate desktops in Windows 10? MS does not support SQL 2008 using MDAC, those are the drivers you see in ODBC Drivers tab. share|improve this answer answered Nov 9 '10 at 14:34 PedroC88 1,74752754 add a comment| up vote 0 down vote Check Changing Crystal Report Database logon information at runtime in VS2005 for If your report was targeted to a specific database and then the database was changed without updated the report, this can cause it.

Post Reply Tweet Forum Jump -- Select Forum -- GP - Installation and Administration GP - Customization and Integration GP - Web Applications GP - General SL - Installation for (int i = 0; i http://digitalezines.com/crystal-report/crystal-report-dll-win-xp.html UserID = "vantech"; crConnectionInfo.

If you do... Can my employer see what I do on the internet when I am connected to the company network? Can a supine verb have arguments? User DSN's did not work but a file DSN did.

Could it be some type of permission problem? Count; i ++) { crTable = crTables [i]; crTableLogOnInfo = crTable. 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. Really, really couldn't hate Crystal more for their exception masking - let this be a lesson to all programmers; Try 'your code here Catch Throw new exception("Hey, here's a really friendly

But when I try to run it in Dynamics SL I got the error that I mentioned above and could not remember what I did wrong. Change the table/view name as mentioned above and run the scriptI have run into this several times now that I have created a new view and then linked to my report Try using onlyUSER DSN's. I hope can be helpful to someone else who has the same error.

BrianA Members Profile Find Members Posts MicrosoftDynamicsForums.com Member Joined: August012006 Location: United States Status: Offline Points: 13 Post Options Post Reply QuoteBrianA Report Post Thanks(0) QuoteReply Posted: March092007 at C01 being the default for the programmers, sort of a test company. Is X+X finitely representable in X? When it runs it retrieves nothing, but it runs.

more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science