帮助！ .rdlc报告未显示数据行. [英] Help! .rdlc report is not displaying datarow.

问题描述

我的报告无法正常工作.它不显示从数据库检索到的任何数据行.因此，我尝试创建一个datagridview来测试查询命令的结果(.rldc报告和datagridview使用相同的datasouce)，并且工作正常.仅.rdlc报告因仅显示标头而无法使用.这是我的代码和运行结果的图片.

My report isn''t work properly. It doesn''t show any row of data which is retrieved from database. So I try to create a datagridview for test the result of query command (.rldc report and datagridview use the same datasouce) and it works fine. Only the .rdlc report that is not working because it shows header only. Here is my codes and a picture of running result.

sqlcmd = "select * from tb_employee"
cmd = New OleDbCommand(sqlcmd, cn)
dr = cmd.ExecuteReader()
dt.Load(dr)
gvtest.DataSource = dt
datasetReport.Tables(0).Load(dr)
dr.Close()
cn.Close()
       rds.Name = "dsReportGroupByProject_dtReport"
rds.Value = datasetReport.Tables(0)
Me.ReportViewer1.LocalReport.DataSources.Add(rds)
Dim rpt(2) As ReportParameter
rpt(0) = New ReportParameter("monthStart",ddlmonth.SelectedItem.ToString)
rpt(1) = New ReportParameter("monthStop", ddlmonth.SelectedItem.ToString)
rpt(2) = New ReportParameter("quot;year", ddlyear.SelectedItem.ToString)
Me.ReportViewer1.LocalReport.SetParameters(rpt)
Me.ReportViewer1.RefreshReport()

在此处查看图片>> [

See the picture here>>[^]

推荐答案

现在，我已经通过将代码改进为以下方式对其进行了修复:

Now,I have already fix it by improve that code to this:

sqlcmd = "select * from tb_employee"
        cmd = New OleDbCommand(sqlcmd, cn)
        dr = cmd.ExecuteReader()
        dt.Load(dr)


        datasetReport.Tables(0).Load(dr)
        dr.Close()
        cn.Close()
        'ReportViewer1.LocalReport.ReportEmbeddedResource = "QSBGPayRoll.ReportEmps.rdlc"
        rds.Name = "dsReportGroupByProject_dtReport"
        'rds.Name = "DataSetReport_dt1"
        rds.Value = dt 'datasetReport.Tables(0)
        gvtest.DataSource = datasetReport.Tables(0)
        ReportViewer1.LocalReport.DataSources.Clear()
        Me.ReportViewer1.LocalReport.DataSources.Add(rds)
        Dim rpt(2) As ReportParameter
        rpt(0) = New ReportParameter("monthStart", ddlmonth.SelectedItem.ToString)
        rpt(1) = New ReportParameter("monthStop", ddlmonth.SelectedItem.ToString)
        rpt(2) = New ReportParameter("year", ddlyear.SelectedItem.ToString)
        Me.ReportViewer1.LocalReport.SetParameters(rpt)
        Me.ReportViewer1.RefreshReport()

谢谢您我和我的努力.

Thank you for myself and my effort.

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