on 06-28-2016 3:30 PM
Hi,
When I set my reports datatable connection info it is ignored and I get the SQL connection login. I have set the integrity to true. Here is my code:-
With crConnectionInfo
.ServerName = Session("SiteSQLName")
.DatabaseName = Session("DatabaseName")
.IntegratedSecurity = True
crConnectionInfo.Type = CrystalDecisions.Shared.ConnectionInfoType.SQL
End With
crDatabase = rptCICPrint.Database
crTables = crDatabase.Tables
For Each crTable In rptCICPrint.Database.Tables
crTableLogonInfo = crTable.LogOnInfo
crTableLogonInfo.ConnectionInfo = crConnectionInfo
crTable.ApplyLogOnInfo(crTableLogonInfo)
Next
This code works in another project but not the one I am currently working on.
Regards,
Roger
What SDK are you using? Have you updated it to recent patch release?
If it works on one PC but not your then check your DB connection properties and be sure you have access to the Database. CR respects DB security, if you don't have access then either will the report.
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.