Invalid Table Name in Crystal .NET

[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.InvalidArgu mentException: 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

[cj]

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

"Ravi sankar" <ra*****@lycos.com> wrote in message
news:06****************************@phx.gbl...

I suppose the owner of the table is "dbo" and the user u r
trying at runtime is not a dbo.
R u using the same sql id and password when u execute from
crystal and the web application?
Try replacing
objReportTable.Location = objConn.DatabaseName & ".." &
objReportTable.Name

with

objReportTable.Location = objConn.DatabaseName & ".dbo." &
objReportTable.Name
thanks and regards,
s.ravi sankar

-----Original Message-----
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.InvalidArg umentExce

ption: 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
.