General information
Forum:
Microsoft SQL Server
Category:
Reporting Services
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only