Skip to Content
author's profile photo Former Member
Former Member

Invalid table number

Hi,

I really need help on resolving this issue, I have been searching a solution 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 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 does not have a subreport.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Mar 05, 2013 at 06:04 PM

    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?

    Don

    And moved to .NET SDK Forum

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.dll

      CrystalDecisions.Shared.dll

      CrystalDecisions.ReportSource.dll

      CrystalDecisions.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 Expert

      3. Remove the stored procedure used on the working report

      4. Choose the actual stored procedure for the report

      5. Deploy on IIS and error was rectified! - not sure how it worked.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.