是要通过后台代码切换数据库连接,在生成报表对象时,修改DataSources属性;
DataSource dataSource = new DataSource();
dataSource.Name = "Reels Database";
dataSource.ConnectionProperties.DataProvider = "OLEDB";
dataSource.ConnectionProperties.ConnectString = ExpressionInfo.FromString(“initial catalog=Best;password=landa;user id=sa;data source=192.168.0.111\sql2008”);
DataSet dataSet = new DataSet();
Query query = new Query();
dataSet.Name = "Sample DataSet";
query.DataSourceName = "Reels Database";
query.CommandType = QueryCommandType.Text;
query.CommandText = ExpressionInfo.FromString(Constants.cmdText);
dataSet.Query = query;
String[] fieldsList = new String[] { "MoviedID", "Title", "YearReleased", "MPAA" };
foreach (string fieldName in fieldsList)
{
Field field = new Field(fieldName, fieldName, null);
dataSet.Fields.Add(field);
}
report.Report.DataSources.Add(dataSource);
report.Report.DataSets.Add(dataSet);
|