将数据绑定到参数将定义报告参数(C1FlexReport.Parameters集合中的元素)的有效值。ReportParameter.AllowedValuesDefinition.Binding.DataSourceName属性用于建立数据源中的参数列表。以下代码说明了如何将数据绑定到具有多个数据源的报表中的参数。
CS
// add datasource and parameter using this datasource DataSource mds = c1FlexReport.DataSource; DataSource ds = new DataSource(); ds.Name = "CategoriesDS"; ds.ConnectionString = mds.ConnectionString; ds.RecordSource = "select * from categories"; ds.DataProvider = DataProvider.OLEDB; c1FlexReport.DataSources.Add(ds); mds.RecordSource = "select * from products where categoryid = [CategoryParam]"; ReportParameter rp = new ReportParameter(); rp.DataType = Doc.ParameterType.Integer; rp.Prompt = "Category"; rp.Name = "CategoryParam"; rp.AllowedValuesDefinition.Binding.DataSourceName = "CategoriesDS"; rp.AllowedValuesDefinition.Binding.ValueExpression = "CategoryID"; rp.AllowedValuesDefinition.Binding.LabelExpression = "CategoryName"; c1FlexReport.Parameters.Add(rp);