从ReportViewer中的DataGridView显示数据源 [英] Display DataSource from DataGridView in ReportViewer

问题描述

根据先前有关报表查看器中动态列的问题，我认为我至少会尝试使事情正常进行。

显示的输出是数学因子的列，每个列都有自己的唯一名称。这些因素（可以选择1到10之间的任何数字）在我的DataGridView控件中显示没有问题-通过根据需要添加行/列来生成DataTable，然后将数据表设置为DataGridView的数据源。

我已将ReportViewer添加到WinForm，并生成了RDLC文件。我的RDLC不用花数小时试图弄清楚如何使其动态，而是设置了10列（据我所知，永远不会超过此列），并且将DataSet分配给了ReportViewer控件。然后，我使用以下代码将数据分配给查看器：

Following on from an earlier question about dynamic columns in a report viewer, I thought I would at least attempt to get things working.
The output being displayed are columns of mathematical factors, each with their own unique name. These factors (any number from 1 to 10 can be selected) display without issue in my DataGridView control - I generate a DataTable by adding rows/columns as required, and then set the datatable as the Datasource for the DataGridView.
I have added a ReportViewer to my WinForm, and generated a RDLC file. Rather than spend hours trying to figure out how to make it dynamic, my RDLC is set up with 10 columns (as I know there will never be more than this), and the DataSet is assigned to my ReportViewer control. I then use the following code to assign the data to the viewer:

DataTable dt = new DataTable();
var source = this.dgvSelectedElements.DataSource;
while (source is BindingSource)
{
    source = ((BindingSource)source).DataSource;
}
var table = source as DataTable;
if (table != null)
{
    dt = table;
    var reportSource = new ReportDataSource("FactorReport", dt);
    this.reportViewer1.Reset();
    this.reportViewer1.ProcessingMode = ProcessingMode.Local;            
    this.reportViewer1.LocalReport.ReportPath = "FactorReport.rdlc";
    this.reportViewer1.LocalReport.DataSources.Clear();
    this.reportViewer1.LocalReport.DataSources.Add(reportSource);
    this.reportViewer1.RefreshReport();
}

因此，DataGridview的外观如下：

< a href = https://i.stack.imgur.com/NWe2z.jpg rel = nofollow noreferrer>
然后，这是Reportviewer-请注意，两个 Rate和 Mult行显示在底部



因此，尽管它似乎可以正常工作，但我无法在网格中看到这些值。另外，当年龄超过100时，年龄分类不正确-可以关闭分类功能吗？并假设我可以使它起作用，是否可以遍历ReportViewer并修改列标题？快速的Google告诉我不是在运行时吗？

So this is how the DataGridview looks:
And then, this is the Reportviewer - note the two 'Rate' and 'Mult' rows appear at the bottom
So whilst it appears to work, I cannot see the values in the grid. Also, when the ages exceed 100, the ages are sorted incorrectly - can sorting be turned off? And on the assumption I can get this to work, is it possible to iterate through the ReportViewer and amend the column captions? A quick google tells me not at run-time?

推荐答案

也许不是最好/最快的解决方案，但它可以工作，并且需要一些额外的帮助更改可见性表达式后，我只能显示已选择的列数。

我在名为 Factor_Name_1 的报表查看器中向 Factor_Name_10添加了10个参数，并在创建属性时在属性中选中了允许空值。然后，我编写了一些代码以添加参数数据，存储现有的列名称，然后将它们重命名为我的Factor1，Factor2 ... Factor10标题，如下所示（请注意，我不担心在第一个 Age列中使用）： / p>

Maybe not the best/quickest solution but it works and with some additional changes to the visibility expressions, I'm able to only show the number of columns that have been selected.
I added 10 parameters to my reportviewer named Factor_Name_1 to Factor_Name_10, and checked 'Allow null value' in the properties when creating them. I then wrote some code to add the data for the parameters, storing the existing column names before renaming them to my Factor1, Factor2...Factor10 headings as follows (note I am not worried about in the first 'Age' column):

        // loop through the columns to create parameters...
        for (int i = 1; i < dt.Columns.Count; i++)
        {
            // get the name of the column...
            string factorName = dt.Columns[i].ColumnName;
            // define the new column name...
            string colName = string.Format("Factor_Name_{0}", i);
            // change the column name now we have stored the real name...
            dt.Columns[i].ColumnName = string.Format("Factor{0}", i);
            // generate the parameter...
            var rparam = new ReportParameter(colName, factorName);
            // add it to the parameter set for the control...
            this.reportViewer1.LocalReport.SetParameters(new[] { rparam });
        }

在创建关联参数后，通过重新设置列名，数据将正确绑定。在RDLC设计器中，我要做的就是用相关的参数值替换现有的标题。然后，要隐藏未选中的列，我将参数和行文本框的可见性表达式设置为：

By re-setting the column names once I've created the associated parameter, the data will then bind correctly. All I had to do then, in my RDLC designer, is to replace the existing headings with the associated parameter values. Then, to hide the columns not selected, I set the visibility expression for the Parameter and Row Textboxes to:

=IIF(ISNOTHING(Parameters!Factor_Name_1.Value),True,False)
....
....
=IIF(ISNOTHING(Parameters!Factor_Name_10.Value),True,False)

现在，如果我选择1或10列，查看器将显示正确的列数并隐藏不需要的列。现在正在重复年龄列（已经重复了标题）并在运行时添加页眉/页脚，但是我目前有一个报告，以正确的标题显示了我需要的数据。




感谢@Reza Aghaei使我走上正轨。

Now, if I choose 1 or 10 columns, the viewer displays the correct number of columns and hides those not required. Am now working on repeating the 'age' column (already have the headings repeating) and adding a header/footer at runtime, but I currently have a report that displays the data I need with the correct headings.

Thanks to @Reza Aghaei for getting me on the right track.

这篇关于从ReportViewer中的DataGridView显示数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！