Crystal Reports Print Engine Error Text Invalid Table Number
Contents |
SAP Crystal Reports, version for Visual StudioWhere is this place located?All Places SAP Crystal Reports, version for Visual Studio 2 Replies Latest reply: Mar 6, 2013 4:33 AM by Jonathan crystal report error codes Mirafelix Tweet Invalid table number Jonathan Mirafelix Mar 5, 2013 11:21 AM
Crystal Report Error 2147190908
Currently Being Moderated Hi,I really need help on resolving this issue, I have been searching a solution
Crystal Report Error Method Of Object Failed
for quite some time now but no luck.I am using Visual Studio 2003 (Microsoft .NET Framework Version:1.1.4322.2500; ASP.NET Version:1.1.4322.2500) and Crystal Report version 9.2.2.634. Funny thing is I have
Crystal Report Error Load Report Failed
created few reports using the same version before but I did not encounter any error at all.Error occured when setting the location "crReportDocument.Database.Tables.Item(i).Location"Exception Details: CrystalDecisions.CrystalReports.Engine.InvalidArgumentException:table number.It will work in my development machine when I tried to save the report in Crystal Report basic for VS2008. But same error occured when I tried to deploy to other machine.Note: The report crystal reports errors does not have a subreport. 889Views Re: Invalid table number Don Williams Mar 5, 2013 7:04 PM (in response to Jonathan Mirafelix) Currently Being Moderated This would indicate you don't have the same database client installed or your assemblies are mixed up.And which one are you using, VS 2003 or VS 2008? And then which CR assemblies are you using?DonAnd moved to .NET SDK Forum Alert Moderator Like (0) Re: Invalid table number Jonathan Mirafelix Mar 6, 2013 4:33 AM (in response to Don Williams) Currently Being Moderated Hi Don,Thank you for your reply.We are actually using VS2003 for the web application that uses the report that I have created.The CR assemblies that we are using are the following:Version:9.1.9360.0 (Crystal Reports for Visual Studio .NET)CrystalDecisions.Web.dllCrystalDecisions.Shared.dllCrystalDecisions.ReportSource.dllCrystalDecisions.CrystalReports.Engine.dll------------------------------------------------------------------------------------------------------------------------------------Update on the Issue: I managed to make it work by doing the following.1. Open a report that is currently working using the full version of Crystal Report 9.2. Save As the report and click Database > Database Expert3. Remove the stored procedure used on the working report4.
to it is ‘I re-installed my PC'. What I had happening was when I was changing invalid table number error in crystal reports the Location of a Crystal Reports table to change the database details: foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { crTableLogOnInfo = crTable.LogOnInfo; crTableLogOnInfo.ConnectionInfo = crConnectionInfo; crTable.ApplyLogOnInfo(crTableLogOnInfo); crTable.Location = DatabaseName+".dbo." + crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1); } This final line would error out with an Invalid Table Number. The cause it turns out is not a bad Crystal version or installation, but rather a broken https://scn.sap.com/thread/3319320 ASPNET user account. When Crystal runs, it runs in the aspnet_wp.exe process, which runs as ASPNET local user. Somehow when I renamed my computer name, it messed up the SQL server authentication of that user. And re-adding the COMPUTER\ASPNET user to SQL didn't seem to want to work. It acted exactly like my ASPNET user was not really COMPUTER\ASPNET. Stranger http://not42.com/2006/12/18/crystal-reports-invalid-table-number/ still, my ASPNET webpages did work, just not Crystal. The solution: I manually deleted my Windows ASPNET user, used "aspnet_regiis -i" to then re-create the user correctly, re-added that user to my SQL Server and then re-booted my PC. As if by magic, problem solved. Permalink 3 Comments » Nathan Freeman-Smith said, May 19, 2010 @ 4:38 pm Hi, thanks for the information in your post. Im getting the error message you have described and your fix has worked for me before. Im getting the error again on another production server but the problem is the SQL server instance is on another machine so i cant add the ASPNET user to the SQL service instance as you cant add a local user from another machine! do you know if i can specify the user Crystal reports is using to access the database? or can you think of another way i can get around this!? Im using similar code to yours above to set the connection info to the new database so im pretty sure its not a code problem
Post your question and get tips https://bytes.com/topic/asp-net/answers/480327-invalid-file-name-when-printing-crystal-report & solutions from a community of 418,472 IT Pros & Developers. It's quick & easy. Invalid file name when printing Crystal Report P: n/a Bernard Goh Hi All, I am newbie for ASP.NET programming and I am having this error when I tried to print crystal report a crytal report from my dotnet web application. Error Message : Invalid file name. at .K(String , EngineExceptionErrorID ) at .F(Int16 , Int32 ) at CrystalDecisions.CrystalReports.Engine.FormatEngin e.Export(ExportRequestCont ext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngin e.Export() at CrystalDecisions.CrystalReports.Engine.ReportDocum ent.Export() at CrystalWeb.ReportPrinter.Page_Init(Object sender, EventArgs e) in c:\inetpub\wwwroot\CrystalWeb\ReportPrinter.aspx.v b:line 42 crystal report error Following is my code for the printing : Dim crReportDocument As ReportDocument Dim crExportOptions As ExportOptions Dim crDiskFileDestinationOptions As DiskFileDestinationOptions Dim Fname As String crReportDocument = New ReportDocument() crReportDocument.Load("C:\Inetpub\wwwroot\CrystalW eb\CrystalReport\Report1.r pt") Fname = "C:\Inetpub\wwwroot\CrystalWeb\Download\" & Session.SessionID.ToString & ".pdf" crDiskFileDestinationOptions = New DiskFileDestinationOptions() crExportOptions = crReportDocument.ExportOptions With crExportOptions .DestinationOptions = crDiskFileDestinationOptions .ExportDestinationType = ExportDestinationType.DiskFile .ExportFormatType = ExportFormatType.PortableDocFormat End With Try crReportDocument.Export() ' <-----Error Occured Here Response.ClearContent() Response.ClearHeaders() Response.ContentType = "application/pdf" Response.WriteFile(Fname) Response.Flush() Response.Close() System.IO.File.Delete(Fname) Catch err As Exception Response.Write("
") Response.Write(err.Message.ToString) Response.Write("
") Response.Write(err.StackTrace.ToString) End Try I exhausted all method that i know of and still don't know what is wrong. anyone can help me out with this ? Any help is very much appreciated. -- Bernard Goh IT Administrator Success Electronics & Transformer Manufacturer Sdn Bhd No.5 & 7,Jalan TSB 8 Taman Industri Sg. Buloh 47000 Sg.Buloh Selang
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 08:08:40 GMT by s_hv987 (squid/3.5.20)