Crystal report dialog box

[Former Member]

I use VS 2008 and SQL 2008 to develop my project. To my last project I have a strange behaviour when I deplay the project to users PCs. When the user is asking to display on the screen a project report a crystal report dialog appears (NOT ALWAYS..!!!), waiting for user credentials. When he clicks 'Cancel' the report is correctly displayed on the screen...! When I run the project on my developing environment I never get the crystal report dialog box...! Again, the dialog box is not always displayed...!

• For each report I use data sets (*.xsd).

Any ideas ??

Thanks,

Zindros

[former_member183750 · Accepted solution]

So, I know you are using VS 2008 and SQL 2008. What about the version of Crystal Reports? What about any updates for CR?

Ludek

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

[Former Member · Accepted solution]

Ludek,

I use the embedded to Visual studio version of Crystal reports - Crystal Reports 2008 Basic. What I get from "About Microsoft Visual studio is :

Microsoft Visual Studio 2008

Version 9.0.30729.1 SP

Microsoft .NET Framework

Version 3.5 SP1

Installed Edition: Professional

Microsoft Visual Basic 2008 91605-130-0422292-60340

Microsoft Visual Basic 2008

Microsoft Visual C# 2008 91605-130-0422292-60340

Microsoft Visual C# 2008

Microsoft Visual C++ 2008 91605-130-0422292-60340

Microsoft Visual C++ 2008

Microsoft Visual Studio 2008 Tools for Office 91605-130-0422292-60340

Microsoft Visual Studio 2008 Tools for Office

Microsoft Visual Web Developer 2008 91605-130-0422292-60340

Microsoft Visual Web Developer 2008

Crystal Reports AAJ60-G0MSA4K-68000CF

Crystal Reports Basic for Visual Studio 2008

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB944899) KB944899

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/944899.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB945282) KB945282

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/945282.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946040) KB946040

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/946040.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946308) KB946308

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/946308.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946344) KB946344

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/946344.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946581) KB946581

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/946581.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947171) KB947171

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/947171.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947173) KB947173

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/947173.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947180) KB947180

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/947180.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947540) KB947540

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/947540.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947789) KB947789

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/947789.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB948127) KB948127

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/948127.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB953256) KB953256

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/953256.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB971092) KB971092

This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this hotfix will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/971092.

Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB945140) KB945140

This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this service pack will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/945140.

Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB947888) KB947888

This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this service pack will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/947888.

Security Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB972222) KB972222

This security update is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this security update will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/972222.

Security Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB973675) KB973675

This security update is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this security update will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/973675.

Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB956453) KB956453

This update is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this update will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/956453.

Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB967143) KB967143

This update is for Microsoft Visual Studio 2008 Professional Edition - ENU.

If you later install a more recent service pack, this update will be uninstalled automatically.

For more information, visit http://support.microsoft.com/kb/967143.

*Also, CrystalDecisions.x.x is 10.5.3700.0*

[Former Member · Accepted solution]

Ludek,

I use the embedded version of Crystal reports, the basic version. CrystalDecisions.x.x is 10.5.3700.0

Crystal Reports xxxxxxxxxxxxxxxxxxxx

Crystal Reports Basic for Visual Studio 2008

Edited by: Ludek Uher on Apr 12, 2010 10:49 AM

[former_member183750 · Accepted solution]

Never share or post your keycode in any public setting. I removed your keycode from your last post.

Download SP 1 and see if that resolves the issue:

https://smpdl.sap-ag.de/~sapidp/012002523100009351512008E/crbasic2008sp1.exe

Ludek

[Former Member · Accepted solution]

Dear Ludek,

I downloaded and installed the sp1 you provided to developing machince as well as to the customer machine. The behaviour is the same. The first time I run the report (to the customer machine) the database login dialog box is opened and the second time I run the same report the dialog box is not opened...!

Ionas

[former_member183750 · Accepted solution]

See if you can reproduce teh behavior with the sample app vbnet_win_dbengine.zip (Windows) or vbnet_web_simplelogonengine.zip . The apps can be downloaded from here:

https://wiki.sdn.sap.com/wiki/display/BOBJ/CrystalReportsfor.NETSDK+Samples

Ludek

[Former Member · Accepted solution]

Ludek,

I followed your suggestion and the problem is reproduced. Again, I was asked to enter my password.

Ionas

[former_member183750 · Accepted solution]

Can you copy and paste the code as it relates to CR?

Also, I believe this is an issue after you deploy the app and it works as expected on your development system. Is that correct?

Ludek

[Former Member · Accepted solution]

Ludek,

Yes, to development environment works as expected. When I deploy the project to the customer sometimes (not always) some reports (not all of them) are showing the login dialog box before the reports is displayed on the screen. When I press "Cancel" the report is displayed on the screen. Following lines show the relative code:

Imports System.Data.SqlClient

Imports CrystalDecisions.Shared

Imports CrystalDecisions.CrystalReports.Engine

Public Class frmPalletteBoxStockCon

Dim repDoc As New rptPalletteBoxStockCon()

Dim crDatabase As Database

Dim crTables As Tables

Dim crTable As Table

Dim crLogOnInfo As TableLogOnInfo

Dim crConnInfo As New ConnectionInfo()

Private ds As PalletteBoxStockCon.PalletteBoxStockConDataTable

Public Sub New(ByVal DS As PalletteBoxStockCon.PalletteBoxStockConDataTable)

Me.ds = DS

InitializeComponent()

crDatabase = repDoc.Database

crTables = crDatabase.Tables

Dim ConnectionString As String() = IT.A.ConnectionString.Split(";")

For Each crTable In crTables

With crConnInfo

.ServerName = ConnectionString(0).Split("=")(1)

.DatabaseName = ConnectionString(1).Split("=")(1)

.UserID = IT.A.User.LoginName

.Password = IT.A.User.LoginPassword

End With

crLogOnInfo = crTable.LogOnInfo

crLogOnInfo.ConnectionInfo = crConnInfo

crTable.ApplyLogOnInfo(crLogOnInfo)

Next

End Sub

Private Sub frmPrint_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

repDoc.SetDataSource(CType(Me.ds, DataTable))

CType(repDoc.ReportDefinition.Sections(0).ReportObjects("lblCompanyData"), CrystalDecisions.CrystalReports.Engine.TextObject).Text = IT.Functions.GetCompanyName

CType(repDoc.ReportDefinition.Sections(0).ReportObjects("lblAddress"), CrystalDecisions.CrystalReports.Engine.TextObject).Text = IT.Functions.GetCompanyAddress

rptViewer.ReportSource = repDoc

End Sub

End Class

IONAS

[former_member183750 · Accepted solution]

See if enabling the options "Verify on first refresh" and "Verify stored procedures on first refresh" helps. If not, you'll have to discover some pattern to this.

E.g.; "...sometimes (not always) some reports (not all of them) are showing the login dialog box..." is way to vague. There has got to be some pattern. E.g.; is this when there is a heavy load on the app? Is there a particular sequence of steps you have to do in order for the issue to occur? Etc.

Also, compare the runtime loaded on good systems and bad systems. Use [Modules|https://smpdl.sap-ag.de/~sapidp/012002523100006252802008E/modules.zip] for that.

Ludek

[former_member11696]

Moved to .NET SDK forum