动态设置devexpress报告参数 [英] Dynamically set devexpress report parameter

问题描述

我是devexpress报告的新手。我知道如何为我的报告设置数据，例如我得到以下代码。我可以填充并生成我的报告。参数设计中的问题我可以分配数据源，数据成员，数据显示。但是我不知道要在报告加载时动态填充参数吗？

I am new to devexpress reports. I know how to set the data for my report e.g. I got the following codes. I can populate and generate my report. The issue in the parameter design I can assign data source, data member, data display. But I dont know to populate the parameters dynamically say on load of the report?

public report1()
{
    InitializeComponent();
    rpt2 rp2 = new rpt2();
    rp2.DataSourceDemanded += rp2_DataSourceDemanded;

    pre1.DocumentSource = rp2;
}
void rp2_DataSourceDemanded(object sender, EventArgs e)
{
    rpt2 report = sender as rpt2 ;
    companyDS ds1 = new companyDS();
    myCon getMyCon1 = new myCon();
    SQLiteConnection con = getMyCon1.GetConnection();
    string sql = "SELECT companyID,companyName from company";
    SQLiteCommand cmd = new SQLiteCommand(sql, con);            
    using (SQLiteDataAdapter da = new SQLiteDataAdapter(cmd))
    {
        da.Fill(ds1, "Datatable1");
    }
    report.DataSource = ds1;
    report.DataMember = ds1.DataTable1.TableName;
}

推荐答案

我建议您仔细阅读以下内容示例和文档参考。

I suggest you go through these example and documentation references.

如何：使用参数创建报告（运行时示例）

如何在运行时向报表添加参数

在运行时将参数传递给报表

如何在devexpress报告中传递参数

示例：

private void simpleButton1_Click(object sender, EventArgs e) {
    // Create a report instance.
    XtraReport1 report = new XtraReport1();

    // Create a parameter and specify its name.
    Parameter param1 = new Parameter();
    param1.Name = "CatID";

    // Specify other parameter properties.
    param1.Type = typeof(System.Int32);
    param1.Value = 1;
    param1.Description = "Category: ";
    param1.Visible = true;

    // Add the parameter to the report.
    report.Parameters.Add(param1);

    // Specify the report's filter string.
    report.FilterString = "[CategoryID] = [Parameters.CatID]";

    // Force the report creation without previously 
    // requesting the parameter value from end-users.
    report.RequestParameters = false;

    // Show the parameter's value on a Report Header band.
    XRLabel label = new XRLabel();
    label.DataBindings.Add(new XRBinding(param1, "Text", "Category: {0}"));
    ReportHeaderBand reportHeader = new ReportHeaderBand();
    reportHeader.Controls.Add(label);
    report.Bands.Add(reportHeader);

    // Assign the report to a ReportPrintTool,
    // to hide the Parameters panel,
    // and show the report's print preview.
    ReportPrintTool pt = new ReportPrintTool(report);
    pt.AutoShowParametersPanel = true;
    pt.ShowPreviewDialog();
}

希望这项帮助。

这篇关于动态设置devexpress报告参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！