Hello every one ,
in this question i just want to create Telerik report with an empty table and assign table data source from code.
in output window the Telerik Report Show without table
here is my code from window form :
all this code below written in from load of reportviewerform.cs
var sourceReportSource = new UriReportSource { Uri = @"C:\Users\ali.raza\source\repos\telerick_windowform\telerick_windowform\Reports\SampleReport.trdp" };
var reportInstance = UnpackageReport(sourceReportSource);
var report = (Report)reportInstance;
Telerik.Reporting.Table processingTable = report.Items.Find("table1", true)[0] as Telerik.Reporting.Table;
//Telerik.Reporting.Processing.Table processingTable = (sender as Telerik.Reporting.Processing.Table);
this.table2.ColumnGroups.Clear();
this.table2.Body.Columns.Clear();
this.table2.Body.Rows.Clear();
Telerik.Reporting.TextBox textboxGroup;
Telerik.Reporting.TextBox textBoxTable;
string connectiostring = "server=win-dc;database=testdb;uid=hrs;password=hrs;Initial Catalog=testdb;Integrated Security= false";
string selectstring = "select * from tbl_telerik";
SqlDataAdapter sqlAdapter = new SqlDataAdapter(selectstring, connectiostring);
DataSet ds = new DataSet();
sqlAdapter.Fill(ds);
Telerik.Reporting.TableGroup tableGroupColumn;
int i = 0;
foreach (System.Data.DataColumn dc in ds.Tables[0].Columns)
{
tableGroupColumn = new Telerik.Reporting.TableGroup();
this.table2.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Unit.Inch(1)));
textboxGroup = new Telerik.Reporting.TextBox();
textboxGroup.Value = dc.ColumnName.ToString();
textboxGroup.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));
tableGroupColumn.ReportItem = textboxGroup;
table2.ColumnGroups.Add(tableGroupColumn);
textBoxTable = new Telerik.Reporting.TextBox();
table2.Body.SetCellContent(0, i++, textBoxTable);
textBoxTable.Value = "=Fields." + dc.ColumnName;
}
Telerik.Reporting.TableGroup tableGroupRow = new Telerik.Reporting.TableGroup();
this.table2.RowGroups.Add(tableGroupRow);
tableGroupRow.Grouping.Add(new Telerik.Reporting.Grouping());//new Telerik.Reporting.Data.Grouping());
processingTable.DataSource = ds.Tables[0];
var reportSource = CreateInstanceReportSource(reportInstance, sourceReportSource);
this.reportViewer1.ReportSource = reportSource;
this.reportViewer1.RefreshReport();
1 Answer, 1 is accepted
Hello Ali,
If you need to create the tables dynamically, I would recommend checking the following resources:
- How to Create a Dynamic Table/Crosstab/List item (contains a sample report)
- How to add multiple tables dynamically based on the data source (contains a sample report)
- How to modify table with preset styles and width dynamically
Regards,
Neli
Progress Telerik
I have Almost Done on what i am doing just need a little help
this is my code form generating table programmatically.
string connectionString = "Data Source=;Initial Catalog=;Integrated Security=False;User ID=;Password=";// no connection string error.
//get the processing table object since we're in the context of event
Telerik.Reporting.Processing.Table processingTable = (sender as Telerik.Reporting.Processing.Table);
//construct the select statement based on the selected report parameters
string selectString = "SELECT " + FormatArray((object[])processingTable.Report.Parameters["TableColumns"].Value) + " FROM " + processingTable.Report.Parameters["TableName"].Value;
SqlDataAdapter sqlAdapter = new SqlDataAdapter(selectString, connectionString);
//create a dataset, fill it and set it as datasource to the processing table object
DataSet ds = new DataSet();
sqlAdapter.Fill(ds);
processingTable.DataSource = ds.Tables[0];
//create two HtmlTextBox items (one for header and one for data) which would be added to the items collection of the table
Telerik.Reporting.HtmlTextBox textboxGroup;
Telerik.Reporting.HtmlTextBox textBoxTable;
//we do not clear the Rows collection, since we have a details row group and need to create columns only
this.table1.ColumnGroups.Clear();
this.table1.Body.Columns.Clear();
this.table1.Body.Rows.Clear();
int i = 0;
this.table1.ColumnHeadersPrintOnEveryPage = true;
foreach (System.Data.DataColumn dc in ds.Tables[0].Columns)
{
Telerik.Reporting.TableGroup tableGroupColumn = new Telerik.Reporting.TableGroup();
this.table1.ColumnGroups.Add(tableGroupColumn);
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Unit.Inch(1)));
textboxGroup = new Telerik.Reporting.HtmlTextBox();
textboxGroup.Style.BorderColor.Default = Color.Black;
textboxGroup.Style.BackgroundColor = Color.AliceBlue;
textboxGroup.Style.BorderStyle.Default = BorderType.Solid;
textboxGroup.Value = dc.ColumnName.ToString();
textboxGroup.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));
tableGroupColumn.ReportItem = textboxGroup;
textBoxTable = new Telerik.Reporting.HtmlTextBox();
textBoxTable.Style.BorderColor.Default = Color.Black;
textBoxTable.Style.BorderStyle.Default = BorderType.Solid;
textBoxTable.Value = "=Fields." + dc.ColumnName.ToString();
textBoxTable.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));
this.table1.Body.SetCellContent(0, i++, textBoxTable);
this.table1.Items.AddRange(new ReportItemBase[] { textBoxTable, textboxGroup });
}
this code is generating table column perfect but repeat row data.
OUTPUT.
Hi Ali,
Indeed, the outcome is strange. Can you please please send us a sample project with the AdventureWorks database which we distribute with the Examples installation, so we can test in our end?
In general, if the report structure is the same and you only need to change the connection string, I would recommend some of the following approaches.
One of the options is the approach described in the KB Change Connection String dynamically through a report parameter. Then from the viewer, you can pass the connection string. Note that this won't work for the connection string of Report Parameter AvailableValues DataSource if any.
The other one is: Changing the connection string dynamically according to runtime data KB article is suitable for Desktop Viewers.