Crystal report prompting for login to Dataset [Problem]

[Former Member]

Hello,

I'm developing a C# windows application with an Access db

I'm getting the data from the database and load it to a dataset then pass the dataset to the report

every thing is working fine on my local machine but..

When I run it on any other machine it prompts me to enter the login information while there are no login informations to enter because I'm connecting to a data set

here is my simple code to load the report

VisitReasibReoirt VisitReasonRPT = new VisitReasibReoirt();
                        VisitReasonRPT.DataSourceConnections[0].IntegratedSecurity = true;
                        VisitReasonRPT.SetDataSource(ds);
                        crystalReportViewer1.ReportSource = VisitReasonRPT;
                        crystalReportViewer1.RefreshReport();

Also there is an other problem in the design

I cannot change the language of the datetime fields like what I did with text fields.. How can I solve this ?

please tell me what to do...this is very important I searched a lot but I found nothing usefull

Edited by: Mando! on Aug 26, 2010 2:04 AM

[former_member188030 · Accepted solution]

Hello,

Information needed..

Version of Crystal Reports?

Version of Visual Studio?

Type of data connectivity used? (i.e. OLEDB, ODBC)

Did you diploy the application? How? (MSM's or MSI's)

If the new machine is also a developement environment, does the report work from designer?

Version of windows on prev and new machine?

Make sure that..

If the application is deployed, the proper runtimes are installed.

The database provider is installed.

The target database is located where it should be.

The target database is unchanged.

One question per thread please.

see [Rules of engagement|http://wiki.sdn.sap.com/wiki/display/HOME/Rules%20of%20Engagement].

Thanks,

Bhushan.

[Former Member · Accepted solution]

Thanks for reply...

Version of Crystal Reports: Crystal Reports 2008 Developer Edition

Version of Visual Studio: VS 2008 Professional Edition

Type of data connectivity used: ADO.Net (Connecting to Dataset)

Did you diploy the application, How: Yes I did (as MSI) Using VS Deployment tool

If the new machine is also a developement environment, does the report work from designer? No

Version of windows on prev and new machine? Windows XP on both machines

====================================================

I solved it

Here is the describtion for people may face it in the future

My report is getting it's data from more than 1 table, The problem happens when the dataset contains a data for one or more tables but not all the tables that the Report has

So I redesigend my report and made sub reports so each one of them has only 1 table to get it's data from, Now every thing is ok and I don't get the login prompt any more

but if there is an other solution else this one it will be fine

Thanks

[former_member183750 · Accepted solution]

I do not have another solution, but I do have a blog that describes the best way to troubleshoot the issues with connecting CR to Datasets:

[Troubleshooting Issues with VS .NET Datasets and Crystal Reports|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13270] [original link is broken] [original link is broken] [original link is broken];.

In a nut shell, you always have to be cognizant of the fact that the report expects the data in the same format as what it was designed with. Any changes (field type, missing field, incorrectly named field, etc., etc., will cause issues). The thing that throws off most people is that the report prompts for a database logon and like most of you working with this, I wish the report engine would throw a better description of what is wrong. But that is another story - something to work on with Program Management :).

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

[Former Member · Accepted solution]

Thanks Ludek for help

I agree with you the engine should throw better description to let us know where to go

another thing it should be faster

anyway Crystal Reports still the best

Thanks again

[Former Member · Accepted solution]

Hello Ludek,

the problem which Mando Extreme described is exactly the one I am having. Unfortunately the field with your helpful answer looks empty to me. Could you please post the answer again or give it to me another way?

Thanks a lot.

[former_member183750 · Accepted solution]

Hello Thomas

Wow, weird. Ain't technology just wonderful? LOL

I am pretty sure I provided the following link:

Troubleshooting Issues with VS .NET Datasets and Crystal Reports

For me, that doc is a life saver. See if it helps you also.

- Ludek

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces