你要把代码写成如下的样子:
把它放在你刷新的代码里,dataset是你的数据源:
crysreport1 crp = new crysreport1();
crp.SetDataSource(dt.Tables[0]);
this.crystalReportViewer1.ReportSource = crp;
把它放在你刷新的代码里,dataset是你的数据源:
crysreport1 crp = new crysreport1();
crp.SetDataSource(dt.Tables[0]);
this.crystalReportViewer1.ReportSource = crp;
解决方案 »
- 有一段储存过程看不明白 谁能给解释一下
- 紧急求助:sql server 2000 中我把一个字段的数据类型设置成varchar(8000),但实际只能存900个字符,附代码!
- 一个很简单的SQL
- Service Broker 问题,超难 100分
- 一个简单的存储过程,请问错误出在哪里?
- 关于统计结果作为条件的问题
- 一个查询条件不执行的问题 急待解决
- Sql 取最近的时间
- 请问sql服务怎么启动不了啊????
- 去重复问题
- 大力快快请进,有事请教.谢谢
- 将表table_a中的字段fieldA、fieldB、fieldC的内容写入table_B中字段fieldA、fieldB、fieldC,应该怎样写??
我是用crystal report 開發工具刷新的
HenanBoy(想飞的更高):
您是甚麼意思呢?
Trusted Connection的復選按鈕沒有。如果沒
有選擇一下再試。
DatabaseName=Table.LogOnDatabaseName
For I =Lbound(DBInfosArr,2) to Ubound(DBInfosArr,2)
if instr(1,UCase(DBInfosArr(1,I)),Ucase(DatabaseName),1)>0 then
DSNName=DBInfosArr(0,I)
DBName=DBInfosArr(1,I)
UserID=DBInfosArr(2,I)
Pwd=DBInfosArr(3,I)
Table.SetLogonInfo cstr(DSNName), cstr(DBName), cstr(UserID), cstr(Pwd)
Exit for
end if
Next
Next
'************************************
'Set the Main Report's Parameters' value
set Params = Session("oRpt").Parameterfields
For each Param in Params
ParamType=Param.valuetype
ParamName=GetParamName(Param.Name)
ParamValue=Eval(ParamName)
Select Case ParamType
Case 7'Number
Call Param.SetCurrentValue (dfVntToInt(ParamValue), 7)
Case 8'Currency
Call Param.SetCurrentValue (Cdbl(ParamValue), 8)
Case 10'Date
Call Param.SetCurrentValue (CDate(ParamValue), 10)
Case 12'String
Call Param.SetCurrentValue (CStr(ParamValue), 12)
End Select
Next
set Params=nothing
'************************************
Set CRXSections = Session("oRpt").Sections
For Each CRXSection In CRXSections
'In each section, you get all the objects in the section.
Set CRXReportObjects = CRXSection.ReportObjects
'You cycle through the objects.
For Each CRXReportObject In CRXReportObjects
'1---Text Object
'2---Fields Object
'3---Line
'4---Box
'Sub Report---5
If CRXReportObject.Kind = 5 Then
Set CRXSubreportObj = CRXReportObject
Set CRXSubreport = CRXSubreportObj.OpenSubreport
'************************************
'Set The Sub Reports Parameters'Value
Set Params=CRXSubreport.Parameterfields
For each Param in Params
ParamType=Param.valuetype
ParamName=GetParamName(Param.name)
ParamValue=Eval(ParamName)
if Instr(1,ParamName,"?Pm-")=0 then
Select Case ParamType
Case 7'Number
Call Param.SetCurrentValue (dfVntToInt(ParamValue), 7)
Case 8'Currency
Call Param.SetCurrentValue (CDbl(ParamValue), 8)
Case 10'Date
Call Param.SetCurrentValue (CDate(ParamValue), 10)
Case 12'String
Call Param.SetCurrentValue (CStr(ParamValue), 12)
End Select
end if
Next
set Params=nothing
'************************************
Set subReportOneTablesCollection = CRXSubreport.Database.Tables
For Each Table in subReportOneTablesCollection
DatabaseName=Table.LogOnDatabaseName
For I =Lbound(DBInfosArr,2) to Ubound(DBInfosArr,2)
if instr(1,UCase(DBInfosArr(1,I)),Ucase(DatabaseName),1)>0 then
DSNName=DBInfosArr(0,I)
DBName=DBInfosArr(1,I)
UserID=DBInfosArr(2,I)
Pwd=DBInfosArr(3,I)
Table.SetLogonInfo cstr(DSNName), cstr(DBName), cstr(UserID), cstr(Pwd)
Exit for
end if
Next
Next
End If
Next
Next