473,543 Members | 2,477 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

CrystalDecision s.CrystalReport s.Engine.Invali dArgumentExcept ion: Error in
File c:\..\..\..\..\ InvoiceReport.r pt: Invalid table number.

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

1 For Each objReportTable In rptInvoice.Data base.Tables
2 Dim objTableLogOnIn fo As TableLogOnInfo = objReportTable. LogOnInfo
3 objTableLogOnIn fo.ConnectionIn fo = objConn
4 objReportTable. ApplyLogOnInfo( objTableLogOnIn fo)
5 objReportTable. Location = objConn.Databas eName & ".." &
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
Jul 19 '05 #1
2 10060
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.Databas eName & ".." &
objReportTable. Name

with

objReportTable. Location = objConn.Databas eName & ".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...

CrystalDecisio ns.CrystalRepor ts.Engine.Inval idArgumentExce

ption: Error in
File c:\..\..\..\..\ InvoiceReport.r pt: Invalid table

number.

It happens when trying to set the location for each table

in the report

1 For Each objReportTable In rptInvoice.Data base.Tables
2 Dim objTableLogOnIn fo As TableLogOnInfo =

objReportTable. LogOnInfo
3 objTableLogOnIn fo.ConnectionIn fo = objConn
4 objReportTable. ApplyLogOnInfo( objTableLogOnIn fo)
5 objReportTable. Location = objConn.Databas eName

& ".." &
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
.

Jul 19 '05 #2
Huzaifa
1 New Member
I got the same error and after some work found out that it was caused because I was using integrated security when creting the report and while running the report from code I was using sql login. Using Sql Login when creating the report solved the issue. Also the error can occur if your saving the report with Crystal report with crystal reports full version instead of crystal reports .Net included with Visual Studio and the version do not match. Try saving with Crystal in VS.

Hope this helps.

Regards,
Huzaifa
Feb 13 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1564
by: Deep Purple | last post by:
I started with the following error... ------------------------------------------------------- An error occured while loading the schema with TargetNamespace 'http://www.w3.org/2001/XMLSchema' referenced in this document. The value for the 'base' attribute is invalid - 'xsd:string' is an invalid value for the 'base' attribute. An error...
1
1581
by: cj | last post by:
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...
0
1619
by: Marvin Massih | last post by:
Hello, I want to print a Crystal report from a web-service or ASP .NET application. I have Crystal Reports 8.0 and Visual Studio .NET 2003 Enterprise Architect (including Crystal Reports for Visual Studio .NET) installed. However, as soon as I call ReportDocument report = new ReportDocument();
1
13954
by: Harshil | last post by:
Hi All, I am working on Vb.net application with oracle as my database. I have developed reports using crystal report 9. Usually when you open reports directly in crystal report viewer control it prompts you for any necessary login information. My goal was to provide the login information by means of code, so that the user is not prompted for...
3
2485
by: Amar | last post by:
I have a abc.PRG file in visual foxpro 8.0. I can run this file using visual foxpro environment and it creates a table X.dbf in the same folder where this program file is and populates some data in the table. I am now using VB.NET to run this abc.PRG file through VB.net environment. (Equivalent method to perform same as "DO abc.prg" command...
0
1324
by: Ray | last post by:
Hi, I have deployed a program with crystal report called in three client's PC. Two of the clients can preview the report successfully. However, the remaining clients has error occured while previewing the report. The error is "Invalid table number". How can I solve this problem? Please help. Thanks a lot, Ray
3
1960
by: David C. Barber | last post by:
Using SQL Server 2000 and moving to a new computer. We did a full backup of the existing database to tape, brought up the new computer with a clean install using the same server name and IP address, and did a full restore. Not only were some permissions messed up, but Crystal Reports 10 and some Access Data Projects refused to run. I finally...
1
5251
by: swatii | last post by:
Hi, I am new to .NET.I have created a desktop application in C#.NET that has Crystal reports used in it. This all works fine when I log in on the "EVERY" as servername which is the default name of my machine and also SQL SERVER name. However when I run it on another machine it does not work.It expect "EVERY" server.It should expect because the...
4
6282
by: mattehz | last post by:
Hey there, I am trying to upload old source files and came across these errors: Warning: Invalid argument supplied for foreach() in /home/mattehz/public_html/acssr/trunk/inc_html.php on line 59 Notice: Undefined index: args in /home/mattehz/public_html/acssr/trunk/inc_error.php on line 92 Warning: Invalid argument supplied for...
0
7399
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7341
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7729
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7677
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5880
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
4884
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3385
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1809
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
626
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.