Information générale
Forum:
Microsoft SQL Server
Catégorie:
Services de reporting
Titre:
SQL Express & report
Before, all of my reports whose connection is using "SQL Server"
Now, i want to use SQL Express instead. I can run the system well, but the report fails
**I got over 100 reports and I don't want to re-write them . How can I use the same report under SQL Express? Thanks
Dim ReportTemp As New ReportDocument
Try
ReportTemp.Load(_report)
For Each table In ReportTemp.Database.Tables
pPrintSetting.GetInfo()
logoninfo = table.LogOnInfo
With logoninfo.ConnectionInfo
.ServerName = "DTS-MYSERVER\SQLEXPRESS"
.DatabaseName = "accountdb"
.UserID = ""
.Password = ""
.IntegratedSecurity = True
End With
table.ApplyLogOnInfo(logoninfo)
Next table
ReportTemp.RecordSelectionFormula = " {myinvoice.invo} ="123" " <-- got error . It said "Logon Fail ... , Unable to connect: incorrect log on parameters"
Please help
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement