Crystal report for VS2010 asks password on non development pc
Hi to all,
I developed an application with VS2010 prof. containing some reports created with Crystal version for Visual studio.
On my computer everything is ok either running it from the development environment or running the compiled program that is placed in the same position that users should use. If you launch the program from another computer (test done on three different PCs) when you view the report it shows a login screen that is visibile at this link
and it doesn't show the report. Also if I insert username and password nothing to do it returns Access denied.
My code (VB) used to pass credentials to report viewer is the following:
Dim report As ReportDocument = New ReportDocument Dim nr As Integer, i As Integer Try report.Load(nomeReport) Dim logOnInfo As New TableLogOnInfo nr = report.Database.Tables.Count For i = 0 To nr - 1 logOnInfo = report.Database.Tables.Item(i).LogOnInfo logOnInfo.ConnectionInfo.ServerName = cSettings.server_name logOnInfo.ConnectionInfo.DatabaseName = cSettings.db_name logOnInfo.ConnectionInfo.UserID = cSettings.dbUser logOnInfo.ConnectionInfo.Password = cSettings.dbPassword logOnInfo.TableName = report.Database.Tables.Item(i).Name report.Database.Tables(i).ApplyLogOnInfo(logOnInfo) Next crViewer.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None Me.crViewer.ReportSource = report Catch ex As Exception MsgBox("Errore nella stampa del report " & ex.Message, MsgBoxStyle.OkOnly + MsgBoxStyle.Exclamation) End Try
I use SQL Server express 2008 as database using oledb to connect to it.
On client PCs I installed runtime version 13.0.1 and operating systems are both windows xp and 7
Where is my fault?
Thanks in advance,