水晶报表未显示正确的数据 [英] Crystal Report not showing correct data

问题描述

R/全部，

我在asp.net 2008项目中使用vb语言正在使用Crystal报表.该报表在运行时映射一次，报表显示正确的数据，但是当单击Crystal报表上的Export按钮时，报表将刷新，并且它们将显示所有表数据我们的查询.

请帮助我们.

我正在使用此代码
-----------

R/All,

Am Using Crystal report in my asp.net 2008 project in vb language.the report are map on run time one time report are showing correct data but when m click export button on crystal report, report are refresh and they are showing all table data instead of our query.

please help us.

I''m Using this code
-----------

Dim rptDoc As New ReportDocument 
Dim dt As New DataTable 
Dim rstRep As New ADODB.Recordset 
st = ConfigurationManager.ConnectionStrings("XXSCL_WebPortelConnectionString").ToString 
con = New Data.SqlClient.SqlConnection(st) 
Dim objRpt As New CrystalReport1 
con.Open() 
Dim dscmd As New SqlDataAdapter(sql, con) 
Dim ds As New DataSet1 
dscmd.Fill(ds, "XXSCL_DDR") 
objRpt.Database.Tables.Item("XXSCL_DDR").SetDataSource(ds) 
CrystalReportViewer1.ReportSource = objRpt

问候
ashish

regards
ashish

推荐答案

Dim mypdffile As New DiskFileDestinationOptions
mypdffile.DiskFileName = Filename
               With objReport.ExportOptions
                   .ExportDestinationType = ExportDestinationType.DiskFile
                   .DestinationOptions = mypdffile
                   .ExportFormatType = ExportFormatType.PortableDocFormat
               End With

               objReport.Export()

我认为问题出在这一行.

i think the problem is in this line.

objRpt.Database.Tables.Item("XXSCL_DDR").SetDataSource(ds)

以这种方式尝试.

try in this way.

da.Fill(dt)
ds.Tables(0).Merge(dt)
objRpt.SetDataSource(ds)

这篇关于水晶报表未显示正确的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！