i have deploy crystal report at live server. That report working properly at my place local mahine
when i upload over live server it is asking me for server login detail so i have write code as per below
Dim i As Integer
Dim LogonInfo As String()
Dim Server As String = "", Database As String = "", User As String = "", Pwd As String = ""
LogonInfo = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString.Split(";")
For i = 0 To LogonInfo.Length - 1
Dim strTemp As String() = LogonInfo(i).Split("=")
Select Case strTemp(0).ToLower()
Case "server"
Server = strTemp(1)
Exit Select
Case "database"
Database = strTemp(1)
Exit Select
Case "user id"
User = strTemp(1)
Exit Select
Case "password"
Pwd = strTemp(1)
Exit Select
End Select
Next
CRViewer.ReportSource = rptName
Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo()
myConnectionInfo.DatabaseName = Database
myConnectionInfo.UserID = User
myConnectionInfo.Password = Pwd
myConnectionInfo.IntegratedSecurity = True
Dim myTableLogOnInfos As TableLogOnInfos = CRViewer.LogOnInfo()
For Each myTableLogOnInfo As TableLogOnInfo In myTableLogOnInfos
myTableLogOnInfo.ConnectionInfo = myConnectionInfo
Next
Still it is askind for credential so plz give me solution for this....
Thanks,
Angel.........
Remember to click “Mark as Answer” on the post, if it helps you.
Esha Desai
Member
541 Points
366 Posts
Crystal Report Loading Issue..
Aug 06, 2012 12:20 PM|LINK
i have deploy crystal report at live server. That report working properly at my place local mahine
when i upload over live server it is asking me for server login detail so i have write code as per below
Dim i As Integer
Dim LogonInfo As String()
Dim Server As String = "", Database As String = "", User As String = "", Pwd As String = ""
LogonInfo = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString.Split(";")
For i = 0 To LogonInfo.Length - 1
Dim strTemp As String() = LogonInfo(i).Split("=")
Select Case strTemp(0).ToLower()
Case "server"
Server = strTemp(1)
Exit Select
Case "database"
Database = strTemp(1)
Exit Select
Case "user id"
User = strTemp(1)
Exit Select
Case "password"
Pwd = strTemp(1)
Exit Select
End Select
Next
CRViewer.ReportSource = rptName
Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo()
myConnectionInfo.DatabaseName = Database
myConnectionInfo.UserID = User
myConnectionInfo.Password = Pwd
myConnectionInfo.IntegratedSecurity = True
Dim myTableLogOnInfos As TableLogOnInfos = CRViewer.LogOnInfo()
For Each myTableLogOnInfo As TableLogOnInfo In myTableLogOnInfos
myTableLogOnInfo.ConnectionInfo = myConnectionInfo
Next
Still it is askind for credential so plz give me solution for this....
Angel.........
Remember to click “Mark as Answer” on the post, if it helps you.
Mudasir.Khan
All-Star
15346 Points
3142 Posts
Re: Crystal Report Loading Issue..
Aug 06, 2012 12:36 PM|LINK
please check this
http://msdn.microsoft.com/en-us/library/ms160330(v=SQL.90).aspx
http://forums.asp.net/t/1300763.aspx
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_23081672.html
Ajay2707
Contributor
5076 Points
977 Posts
Re: Crystal Report Loading Issue..
Aug 06, 2012 01:31 PM|LINK
Hi Esha,
Please check that you not save your report as "Save with data" option in file menu, then untick and save.
Also If it is possible than you check give live database credential to report and save it and deploy again.
Still if you have problem. then check your live database credentials.
see below link.
http://forums.asp.net/t/1647609.aspx/1
http://stackoverflow.com/questions/4801835/crystal-report-credentials-prompt-after-deployment
Esha Desai
Member
541 Points
366 Posts
Re: Crystal Report Loading Issue..
Aug 07, 2012 07:12 AM|LINK
Hi Ajay,
Please check that you not save your report as "Save with data" option in file menu, then untick and save
Where i will find this option..??? in file menu i didnt get any such option.
Also If it is possible than you check give live database credential to report and save it and deploy again.
Can you tell me how i will change report credential ?? from export Database option.. ??
Angel.........
Remember to click “Mark as Answer” on the post, if it helps you.
Ajay2707
Contributor
5076 Points
977 Posts
Re: Crystal Report Loading Issue..
Aug 07, 2012 09:53 AM|LINK
Hi Esha,
See link,
Step by Step Tips - Changing data source and database
http://www.softwareforces.com/Support/Learning-Center/Step-by-Step/rpt-Inspector/Changing-Data-source-and-Database-Crystal-Reports-Dev-to-QA-to-Production
Esha Desai
Member
541 Points
366 Posts
Re: Crystal Report Loading Issue..
Aug 07, 2012 01:19 PM|LINK
HI..
How to assign credential so subreport in crystal report. (in vb.net )
please share code.. i m facing problem in this..
Angel.........
Remember to click “Mark as Answer” on the post, if it helps you.
Esha Desai
Member
541 Points
366 Posts
Re: Crystal Report Loading Issue..
Aug 08, 2012 05:34 AM|LINK
Help me out on this....
Angel.........
Remember to click “Mark as Answer” on the post, if it helps you.
Lajja
Member
18 Points
16 Posts
Re: Crystal Report Loading Issue..
Aug 08, 2012 05:40 AM|LINK
I have same issue ... your answers did not help me... please help me