Invalid Table Name in Crystal .NET

  • Thread starter Thread starter cj
  • Start date Start date
C

cj

Has anyone come across the following error in running a Crystal Report in
ASP.NET using the Crystal Reports Web Viewer control...

CrystalDecisions.CrystalReports.Engine.InvalidArgumentException: Error in
File c:\..\..\..\..\InvoiceReport.rpt: Invalid table number.

It happens when trying to set the location for each table in the report

1 For Each objReportTable In rptInvoice.Database.Tables
2 Dim objTableLogOnInfo As TableLogOnInfo = objReportTable.LogOnInfo
3 objTableLogOnInfo.ConnectionInfo = objConn
4 objReportTable.ApplyLogOnInfo(objTableLogOnInfo)
5 objReportTable.Location = objConn.DatabaseName & ".." &
objReportTable.Name
6 Next

on line 5. All the articles/newsgroup postings etc have yet to be of any
help. The Crystal site has an article on the problem but refers to using a
ODBC file DSN, but I'm using the OLEDB driver in the reports and not ODBC.
If I run the report in the Crystal windows viewer it is fine - only the web
viewer doesn't want to play nice.

Any help is appreciated.

Cameron
 
Thanks Ravi,
But I already tried your suggestion and no dice. The user and password are
the same for both Crystal and my application, and I even tried the 'sa' user
and still get the same problem.

I know it's nothing to do with the web viewer itself, because I can't even
run the report let alone display it in the viewer.

Cheers,

Cameron
 
Back
Top