水晶报表问题,高分相送~~~~~~~~100分
大家好,我现在做了一个网站,在水晶报表中出了问题,请大家帮忙
问题是这样的:
我用强类型定义的水晶报表,同时在WEB.CONFIG中设置了他的数据库路径,通过
程序调用这个路径
可是,现在出现一个问题,就是更改web.config中的数据库,报表的数据没有任何变化,是不是web.config中的路径对报表没有影响呀。
web.config中的原代码是这样的:
<add key="ConnectionDatabaseString" value="Server=APJ007;uid=sa;pwd=;database=SHODATA"/>
水晶报表中的原代码是这样的:
Dim irow As Integer
Dim sPassword As String, sServer As String, sUid As String, sDatabase As String, sConnection As String
Dim clsConnectionInfo As New cConnectionInfo()
sConnection = ConfigurationSettings.AppSettings.Item("ConnectionDatabaseString")
If sConnection.Trim <> "" Then
With clsConnectionInfo
.ConnectionString = sConnection
.resolveConnectionStr()
sPassword = .Password
sServer = .ServerName
sDatabase = .DabaBaseName
sUid = .UID
clsConnectionInfo = Nothing
End With
Else
clsConnectionInfo = Nothing
Exit Sub
End If
'define the parameter about Criticalreport
Dim paramFields As New ParameterFields()
Dim paramField As New ParameterField()
Dim discreteVal As New ParameterDiscreteValue()
paramField.ParameterFieldName = "@category"
discreteVal.Value = Request.QueryString("Category")
paramField.CurrentValues.Add(discreteVal)
paramFields.Add(paramField)
'bind Criticalreport at crystalCritical
Dim Criticalreport As New CachedCritical_Essential()
'Instanziamo la classe e creiamo un nuovo oggetto
Dim credentials As New TableLogOnInfo()
'Completiamo le proprietà con i nostri parametri per l'accesso a SQL
credentials.ConnectionInfo.DatabaseName = sDatabase
credentials.ConnectionInfo.UserID = sUid
credentials.ConnectionInfo.Password = sPassword
credentials.ConnectionInfo.ServerName = sServer
'Aggiungiamo le credenziali al Report Viewer
crystalCritical.LogOnInfo.Add(credentials)
crystalCritical.ParameterFieldInfo = paramFields
crystalCritical.ReportSource = Criticalreport
crystalCritical.DisplayGroupTree = False
crystalCritical.DataBind()
我在做水晶报表时,是直接规定了一个数据库的,现在我想通过web.config中
设定,随时改变路径,请大家帮帮忙!!