因为AR9提供三种报表类型,RDL报表,页面报表,区域报表,不同的报表添加使用的接口不一样。
我给您发送一个示例,您可以查看里面的LayoutBuilder.cs文件,里面有三种报表的数据绑定,您适当修改下ConnectString 和 DataProvider:
- // create DataSource for the report
- DataSource dataSource = new DataSource();
- dataSource.Name = "DataSource1";
- dataSource.ConnectionProperties.DataProvider = "DATASET";
- dataSource.ConnectionProperties.ConnectString = "";
- //Create DataSet with specified query and load database fields to the DataSet
- DataSet dataSet = new DataSet();
- Query query = new Query();
- dataSet.Name = "DataSet1";
- query.DataSourceName = "DataSource1";
- query.CommandType = QueryCommandType.Text;
- query.CommandText = "";
- dataSet.Query = query;
- //获取主表字段
- Field field = new Field("公司名称", "C_O.公司名称", null);
- dataSet.Fields.Add(field);
-
- //create report definition with specified DataSet and DataSource
- report.Report.DataSources.Add(dataSource);
- report.Report.DataSets.Add(dataSet);
- return report;
复制代码
|