Hierarchical grid child template

Hi Dess.

I think you misunderstood my problem.
For example, in the sample you sent, let's say I'd like to display just the ProductName and the Picture in the child grid.

So the child template would look like something like this:

        private GridViewTemplate CreateChildTemplate()
        {
            GridViewTemplate childTemplate = new GridViewTemplate();
            childTemplate.AutoGenerateColumns = false;
            GridViewDataColumn column = new GridViewDecimalColumn("ProductName");
            childTemplate.Columns.Add(column);
            column = new GridViewDecimalColumn("Picture");
            childTemplate.Columns.Add(column);
            //column = new GridViewDecimalColumn("ProductName");
            //childTemplate.Columns.Add(column);
            //column = new GridViewDecimalColumn("UnitPrice");
            //childTemplate.Columns.Add(column);
            //column = new GridViewDecimalColumn("SupplierID");
            //childTemplate.Columns.Add(column);
            //column = new GridViewDecimalColumn("CategoryID");
            //childTemplate.Columns.Add(column);
            //column = new GridViewDecimalColumn("UnitsInStock");
            //childTemplate.Columns.Add(column);
            childTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
            this.radGridView1.Templates.Add(childTemplate);
            return childTemplate;
        }

I set the AutoGenerateColumns property to false and add just the two columns to the template. But this code change doesn't change a thing in the output. The grid would always display all columns. Setting the AutoGenerateHierarchy property to false leads to an empty product list though...

Regards,
Bernhard

Hi Dess.

[quote]1. Set the AutoGenerateHierarchy property to true and hide all redundant columns.[/quote]
How do I hide auto generated columns? When setting up the template, the columns collection is empty. So I have to use an event after databinding to set the column's isVisible property to false?

[quote]2. Set the AutoGenerateHierarchy property to false, the child template's AutoGenerateColumns property to false, add the desired columns and set up the relation programmatically.[/quote]
Can you please provide working code - in the sample you attached - for this approach?

The following code leads to the attached output. I don't get it why the child rows are not displayed.

        private void RadForm1_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'nwindDataSet.Products' table. You can move, or remove it, as needed.
            this.productsTableAdapter.Fill(this.nwindDataSet.Products);
            // TODO: This line of code loads data into the 'nwindDataSet.Suppliers' table. You can move, or remove it, as needed.
            this.suppliersTableAdapter.Fill(this.nwindDataSet.Suppliers);
            
            GridViewTemplate childTemplate = CreateChildTemplate();
            GridViewRelation relation = new GridViewRelation(this.radGridView1.MasterTemplate, childTemplate);
            relation.ChildColumnNames.Add("Products");
            this.radGridView1.AutoGenerateHierarchy = false;
            this.radGridView1.DataSource = this.suppliersBindingSource;
            this.radGridView1.Relations.Add(relation);
        }

        private GridViewTemplate CreateChildTemplate()
        {
            GridViewTemplate childTemplate = new GridViewTemplate();
            GridViewDataColumn column = new GridViewDecimalColumn("ProductName");
            childTemplate.AutoGenerateColumns = false;
            childTemplate.Columns.Add(column);
            column = new GridViewDecimalColumn("Picture");
            childTemplate.Columns.Add(column);
            childTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
            this.radGridView1.Templates.Add(childTemplate);
            return childTemplate;
        }

Hi Dess,

     I have two issue in my Radgrid

1. There is borders of columns are not showing when export to Excel, or getting dataonly when export. I need to show both case that with border or without border.
2. If Hierarchical data Grid : The expanded chilled templates are not showing  when take print preview of grid.

Regards

Jamshi

Hi Dess,
     Thanks for your answer, But 

Where I asked about hierarchy data not in case of export, I am asking in case of print preview of hierarchical grid.

I take Print Preview of hierarchical grid, Where not showing chilled template. 

Is there any property to show template in print preview.

Thanks
Jamshi

hello Dess,

     Thanks, I got chilled rows in PrintPreview, But

Still I didn't get the border when export to Excel. 

I tried SpreadExporter.cellformating event, but I am not getting correct output.

here s my code to export

Thanks

Jamshi

Hi,
     Here I have a Hierarchical Grid.

When printing, all GridViewTemplates are coming  that is expanded and none expanded templates, but

I need to print expanded GridViewTemplate only as chiled.

Regards

Jamshi

Hello, Jamsheer,    

The purpose of the printing behavior in RadGridView is to print all rows together with their child rows when there is a hierarchical template no matter of the current expanded state of the row. 

If you need to skip printing the child records for a certain parent row, e.g. the second row in the grid, the possible solution that I can suggest is to hide the child rows for this particular parent row before invoking the print logic and restore the rows visibility after it. You can find below a sample code snippet demonstrating how to skip printing the child rows for the parent row at index 1:

        private void radButton1_Click(object sender, EventArgs e)
        {
            foreach (GridViewRowInfo row in this.radGridView1.Rows[1].ChildRows)
            {
                row.IsVisible = false;
            }
            GridPrintStyle style = new GridPrintStyle();
            style.PrintHierarchy = true;
            this.radGridView1.PrintStyle = style;
            this.radGridView1.PrintPreview();
            foreach (GridViewRowInfo row in this.radGridView1.Rows[1].ChildRows)
            {
                row.IsVisible = true;
            }
        }

Should you have further questions please let me know.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Hi Dess,

      Its working fine but, If the row is not expanded then I don't want to see the template column header also not only the data rows

I need to show the template grid header column only when parent is expanded.

How could I hide.

Regards

Jamshi

Hello, Jamsheer,    

In order to achieve your goal, I would suggest you an alternative solution. However, it would require creating a custom PrintGridTraverser. Thus, in its CanStepInHierarchy method you can control whether the child rows will be traversed when printing considering the expanded state of the row. Please refer to the following code snippet: 

        private void radButton1_Click(object sender, EventArgs e)
        { 
            CustomGridPrintStyle style = new CustomGridPrintStyle();
            style.PrintHierarchy = true;
            this.radGridView1.PrintStyle = style;
            this.radGridView1.PrintPreview(); 
        }

        public class CustomGridPrintStyle : GridPrintStyle
        {
            public override void Initialize()
            {
                base.Initialize();
                FieldInfo fi = typeof(GridPrintStyle).GetField("traverser", BindingFlags.NonPublic | BindingFlags.Instance);
                fi.SetValue(this, new CustomPrintGridTraverser(this.GridView.MasterView));
            }
        }

        public class CustomPrintGridTraverser : PrintGridTraverser
        {
            public CustomPrintGridTraverser(GridViewInfo viewInfo) : base(viewInfo)
            {
            }

            protected override bool CanStepInHierarchy()
            {
                GridViewHierarchyRowInfo hierarchyRow = this.Traverser.Current as GridViewHierarchyRowInfo;
                if (hierarchyRow != null)
                {
                    return hierarchyRow.IsExpanded;
                }
                return base.CanStepInHierarchy();
            }
        }

Should you have further questions please let me know.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik