Hi Stratos,
We don’t have option to programmatically refresh the fields in a dataset and we are programmatically creating connection using the connectionstring available in dataset and adding the column names as fields to the datasets. You can create the database connection in your sample during the report creation and resultant column names need to be added to the respective dataset fields collection to display at initial load of the report. The fields can be added to the report collection as shown in the below code sample.
|
private Syncfusion.RDL.DOM.ReportDefinition EditDataSet(object dataTable, Syncfusion.RDL.DOM.ReportDefinition reportDefinition)
{
foreach(Syncfusion.RDL.DOM.DataSet dataset in reportDefinition.DataSets)
{
dataset.Fields = new Syncfusion.RDL.DOM.Fields();
foreach (DataColumn column in (dataTable as DataTable).Columns)
{
Field field = new Field()
{
Name = column.ColumnName,
DataField = column.ColumnName,
TypeName = column.DataType.ToString()
};
dataset.Fields.Add(field);
}
}
return reportDefinition;
} |
Please refer to the below online knowledge base to know more about editing report element programmatically.
Please let us know if have any queries.
Regards,
Vijay R .
