Logon page when trying to show report

[Former Member]

I have an application that runs fine on my local machine but when I move the application to the test server. When I try to run the application and show the report. I get a logon page for further information even though I add the userid and password to the report with the code. Has anybody else ever have this problem? Thanks for the help. Shawn

[Former Member · Accepted solution]

Hi Shawn,

Would request you to update me with the following information.

1. Version of Visual Studio 2003/2005/2008 ?

2. Version of Crystal Reports ?

3. Is it a Web or Windows Application ?

4. Environment of the development machine and deployment machine.

5. Method of deployment ? Server Install or using Merge Modules ?

Please get back to us with the above info to narrow down the issue

Thanks

[Former Member · Accepted solution]

1. VS 2008

2. 11

3. This is a web application.

4. Server 2003 is the OS for the test server.

5. I'm doing an install.

I have other reports working in the same application but the ones that are working are being assigned a datasource and the ones that aren't working are calling a stored procedure. Does that extra information help?

Thanks for the help.

[Former Member]

Hi,

It might be possible that your reports are using the SQL native client connection and the machines prompting for logon might have not native client installed.

Install the native client on a machine and it would resolve your issue.

Hope that works!!

Regards

Amit

[Former Member]

Our test server has it installed. Thanks for the help anyways.

[Former Member]

I thing I have noticed that you are using CR 11 with VS 2008 - would like to inform that CR 11 is not compatible with VS 2008.

VS 2008 is only compatible with Cr 10.5 (bundled with VS2008) and CR 2008 SP0.

Hope that helps!!

Regards,

Amit

[Former Member]

Does it matter that our applications are still only running under .net framework 2.0?

[Former Member]

VS 2008 also runs under Framework 2.0 so it doesn't matter.

Amit

[Former Member]

How can you explain why it works locally? I'm getting confused. Thanks for the help.

[Former Member]

Well if the reports developed in CR 11 working with VS 2008 then I am wondering that how come is it possible.

For confirming the Cr version go to the VS 2008 environment on your development machine and then check the version of the CR references.

And what runtimes have you installed on server for CR.

Hope that helps

Amit

[Former Member]

Amit,

Here are my assemblies for the application.

<add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.Enterprise.Framework, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.Enterprise.InfoStore, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.Enterprise.Web, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

* <add assembly="CrystalDecisions.Web, Version=11.5.3700.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>*

* <add assembly="CrystalDecisions.Shared, Version=11.5.3700.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>*

* <add assembly="CrystalDecisions.ReportSource, Version=11.5.3700.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>*

* <add assembly="CrystalDecisions.Enterprise.Desktop.Report, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>*

* <add assembly="CrystalDecisions.ReportAppServer.Controllers, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>*

* <add assembly="CrystalDecisions.CrystalReports.Engine, Version=11.5.3700.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>*

* <add assembly="CrystalDecisions.Enterprise.Viewing.ReportSource, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>*

What version of crystal reports are using these assemblies? Also for some more information, I was told the report would work without the sub reports in the main report. Is there something different we have to do for the logon validation for subreports?

Thanks,

Shawn

Edited by: Shawn Geller on Oct 15, 2008 9:29 PM