Crystal Report Database Error File Could Not Be Found
Contents |
360 games PC games the table could not be found crystal reports Windows games Windows phone games Entertainment All Entertainment
The Table Could Not Be Found Crystal Reports Viewer
Movies & TV Music Business & Education Business Students & educators the table could not be found error in file crystal report Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet crystal reports database table cannot be found Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Crystal error : The table cannot be found Want to Advertise Here? Solved Crystal error : The table cannot be https://support.microsoft.com/en-us/kb/939712 found Posted on 2010-04-28 DB Reporting Tools Crystal Reports 1 Verified Solution 14 Comments 2,180 Views Last Modified: 2013-11-15 Hi Experts, I have a problem with one of my weekly reports scheduled to run every Monday morning. When I look in the CMC for the error message it gives : Error in File ~tmp*****.rpt: The table could not be https://www.experts-exchange.com/questions/26104827/Crystal-error-The-table-cannot-be-found.html found. When I remotly control my server where Crystal Reports 2008 is installed, I can run the report without problems with all the same accounts. I also did a "verify database" on each sub report and the main report. Nothing have changed in the report, so I don't really know what is causing the problem. --> There are 7 different databases for this report, so the error message don't tell me which of these databases is the problem. I even tried to import the report with another name and run it in the CMC, same message! Does anyone happen to have this problem before? 0 Question by:Etdashou Facebook Twitter LinkedIn Google LVL 1 Best Solution byEtdashou Problem solved! worked with SAP on the issue and they helped me with one thing : find the log. The message "Table cannot be found" doesn't tell which table is the problem, but in the log you can find Go to Solution 14 Comments LVL 14 Overall: Level 14 Crystal Reports 13 DB Reporting Tools 5 Message Ex
Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. Error in file; Table Could Not Be Found Search this topic...|Search Crystal Reports...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered http://www.forumtopics.com/busobj/viewtopic.php?p=859178 Posts Register or Login to Post Forum Index -> Building Reports -> Crystal Reports http://forums.asp.net/t/1684858.aspx?table+not+found+error+in+crystal+report+10+5 Author Message mcliffordgooForum EnthusiastJoined: 13 Feb 2003Posts: 1148Location: Washington, DC Posted: Fri Dec 09, 2011 3:15 pmPost subject: Error in file; Table Could Not Be Found We've migrated a CR2008 report from dev to prod. We are recieving an error message stating that the table could not be found. I've verified that the DSNs are valid in production crystal report and we've check the data base directly they are all valid. I was wondering where else and what I should check. I am new when it comes to CR._________________Michael P. Goo Washington, DC Back to top kevlrayForum AssociateJoined: 23 Jun 2010Posts: 717Location: California Posted: Mon Dec 12, 2011 4:07 pmPost subject: Re: Error in file; Table Could Not Be Found Did you verify the database (main and subreports) when you migrated over? I am assuming not be found that the report is using an ODBC to connect to the data. I hope this helps. Back to top mcliffordgooForum EnthusiastJoined: 13 Feb 2003Posts: 1148Location: Washington, DC Posted: Tue Dec 13, 2011 9:02 amPost subject: Re: Error in file; Table Could Not Be Found We actually found the solution but as for understanding why it works I don't know. In this case all of the necessary default parameters needed to connect to our Netezza EDW are in the ODBC DSN. In CR I set the properties of the data base connection to use the default DSN Properties. For whatever reason the developer had it set to False and I just changed it to True. It worked. Thank you for the feedback._________________Michael P. Goo Washington, DC Back to top smptrainingSenior MemberJoined: 07 Jul 2009Posts: 80Location: Bournemouth Posted: Tue Dec 13, 2011 10:20 amPost subject: Re: Error in file; Table Could Not Be Found Look at the SQL code (Database -> Show SQL Query) and try running that in another environment to help pinpoint errors._________________Crystal Reports Training & Consultancy Specialists Bournemouth, UK www.smptraining.co.uk Back to top smptrainingSenior MemberJoined: 07 Jul 2009Posts: 80Location: Bournemouth Posted: Tue Dec 13, 2011 10:21 amPost subject: Re: Error in file; Table Could Not Be Found Sorry - my message crossed with yours - still, my comment might help
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Advanced ASP.NET/Crystal Reports/table not found error in crystal report 10.5 table not found error in crystal report 10.5 [Answered]RSS 10 replies Last post Jun 03, 2011 12:38 AM by nileshschaudhari ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply nileshschaud... None 0 Points 16 Posts table not found error in crystal report 10.5 May 28, 2011 03:40 AM|nileshschaudhari|LINK hi, i am using vs 2008 and oracle 10g. i cannot bind stored procedure with crystal report but it works fine with view and table. But in case of stored procedure i gives an error like table not found. I am using oracle OLE DB provider for oracle. please help me Reply necro_mancer Contributor 5231 Points 1602 Posts Re: table not found error in crystal report 10.5 May 30, 2011 10:51 PM|necro_mancer|LINK Hi nile, Have you tried to bind it on an SQL Server Database? The reason I am asking about this is simply because Crystal Report is tightly integrated with Visual Studio and Visual Studio is Microsoft product. Anyway, this is just a recommendation and please keep me posted of any good news! ASP.NET Programming is simple - ASP.NET Hosting Reply nileshschaud... None 0 Points 16 Posts Re: table not found error in crystal report 10.5 May 31, 2011 06:44 AM|nileshschaudhari|LINK thanx for reply. i don't tried it with SQL Server. Reply necro_mancer Contributor 5231 Points 1602 Posts Re: table not found error in crystal report 10.5 Jun 01, 2011 10:46 PM|necro_mancer|LINK hi nile, would you advise the error message you see on your application? with an error message, other forum members can help you easily :-) ASP.NET Programming is simple - ASP.NET Hosting Reply nileshschaud... None 0 Points 16 Posts Re: table not found error in crystal report 10.5 Jun 01, 2011 11:33 PM|nileshschaudhari|LINK hi necro_mancer, the error message is like this, The table 'DB.dbo.sp_XXXXXXX;1' could not be found. Error in File C:\WINDOWS\TEMP\DetailReport {DEB40054-9599-4581-BE44-601597510688}.rpt: The table could not be found. thanks for posts Reply necro_mancer Contributor 5231 Points 1602 Posts Re: table not found error in crystal report 10.5 Jun 02, 2011 01:56 AM|necro_mancer|LINK hi there, does it happen to one particular stored proc OR does it happen t