By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,763 Members | 1,609 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,763 IT Pros & Developers. It's quick & easy.

Data base login in Crystal Report.NET

P: n/a

I have a VB.NET program with several CR.NET reports using ADO.NET Datasets.
It takes data from Visual FoxPro 8.0 database. I have also two computers
with VS.NET 2003 installed on both of them.

Problem is that this program gives Data base login screen and doesn't create
report on first computer. The same time it works fine on second computer.
The best hint so far I got from about Data base login

":The report in the application contains two database tables. When
programmatically passing an ADO.NET dataset to this report, a logon dialog
box appears, prompting for a user name and password.

:This behavior occurs because one or more tables in the report could not
read data from the ADO.NET dataset.

To resolve this behavior, pass each table from the ADO.NET dataset to each
table in the report.

The following is sample code for Visual Basic .NET:

report.Database.Tables(0).SetDataSource(Dataset.ta bles(0))

report.Database.Tables(1).SetDataSource(Dataset.ta bles(1))"

In my code it was:
mCrystalReport_RunL.Database.Tables(0).SetDataSour ce(LDataSet_DS)

This hint fixed reports and works the same on both computers. But second
computer can work without this fix.

Did anybody have similar problem? What should be changed on a first computer
to run program the same as a second?


Feb 2 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.