Easy way to get a report from a filtered radgridview??

[Udo]

Hi there ,

I have a WindowsForms application with a RadGridView.
Now I would like to output the filtered values ​​as a report or transfer them to a report.
Is there an easy way?

Thanks

Udo

[Todor]

Hi, Udo,

RadGridView offers ChildRows collection which returns the data rows that are currently represented by RadGridView in the order in which they appear. The collection is modified every time a data operation (e.g. filtering) occurs. It is possible to populate programmatically a DataTable considering the content of the ChildRows collection. Then, use this DataTable for generating the report. 

For the reporting part, you need to create a report definition that reflects the desired layout. You may check our Getting Started articles for details. You will have to use an ObjectDataSource component that points to the DataTable generated from the RadGridView. Finally, you may display the report in our WinForms Report Viewer.

Regards,
Todor
Progress Telerik

[Udo]

Hi there,

how can I write the ChildRowSelection to a Datatable?

I need Help please!!.

 

Thanks for Help

Udo

[Dess | Tech Support Engineer, Principal]

Hello, Udo, 

I have prepared a sample code snippet demonstrating how to generate a DataTable populated with the data from the filtered RadGridView:

            DataTable dt = new DataTable();
            foreach (GridViewColumn col in this.radGridView1.Columns)
            {
                dt.Columns.Add(col.Name);
            }
            foreach (GridViewRowInfo row in this.radGridView1.ChildRows)
            {
                DataRow dr = dt.NewRow();
                foreach (GridViewColumn col in this.radGridView1.Columns)
                {
                    dr[col.Name] = row.Cells[col.Name].Value;
                }
                dt.Rows.Add(dr);
            }

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

[Udo]

Tank You.

It works perfect