本文介绍了如何将查询结果显示为Crystal Reopt的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在我的应用程序中,我使用了水晶报表.
In my application I used crystal report.
dim str as new string
str="select table1.*,table2.* from table2 inner join table1 on table1.id=table2.code where table1.id=1500
Dim mycmd As New SqlCommand
mycmd.Connection = roConform
mycmd.CommandText = StrSQl
mycmd.CommandType = CommandType.Text
Dim myda As New SqlDataAdapter
Dim myds As New DataSet
myda.SelectCommand = mycmd
myda.Fill(myds, "table")
Dim crptReport As New CryFamilyMembers1
crptReport.SetDataSource(myds)
CRViewer.ReportSource = crptR
查询结果正确,但是Crystal报表填充了所有记录.
Query result is correct but crystal report populated all records
推荐答案
这篇关于如何将查询结果显示为Crystal Reopt的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!