This is a migrated thread and some comments may be shown as answers.

Exporting RadGrid - background color of GridBoundColumn Header

7 Answers 148 Views
Ajax
This is a migrated thread and some comments may be shown as answers.
Joseph
Top achievements
Rank 1
Joseph asked on 10 Jul 2014, 09:38 PM
So on the button click of a telerik:RadToolBarDropDown I export a Telerik:RadGrid to either PDF, Excel or Word, depending on what they select.
The telerik:RadGrid has 2 levels of DetailTables.  I was able to add a background color of the MasterTableView using the code below:

For Each hdrItem As GridHeaderItem In RadGrid1.MasterTableView.GetItems(GridItemType.Header)
            hdrItem.BackColor = System.Drawing.Color.LightBlue
            For Each cell As TableCell In hdrItem.Cells
                cell.Style("text-align") = "left"
            Next
Next

My question is how can I also add a background color of each DetailTable Header?  Please Advice.  Thank You.

7 Answers, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 1
answered on 11 Jul 2014, 03:59 AM
Hi Joseph,

Please try the below approach to set the background color for the Detail Table.

ASPX:
...
<telerik:GridTableView Name="Detail2" runat="server" >
    <HeaderStyle CssClass="color2" />
...

CSS:
.color2
{
    background-image: none !important;
    background-color: Blue !important;
}

Thanks,
Shinu.
0
Joseph
Top achievements
Rank 1
answered on 11 Jul 2014, 03:15 PM
Shinu,

I already have the formatting done on render.  But when i export to pdf, word, or excel, that is what i need help on.  I need to problematically apply the header background color.
0
Shinu
Top achievements
Rank 1
answered on 14 Jul 2014, 03:13 AM
Hi Joseph,

Please try the below approach to change the style of detail table from code behind.

C#:
protected void RadGrid1_DetailTableDataBind(object source, Telerik.Web.UI.GridDetailTableDataBindEventArgs e)
{
    GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;
    switch (e.DetailTableView.Name)
    {
        case "Orders":
            {
                     ....
                e.DetailTableView.HeaderStyle.CssClass = "color2";
                break;
            }
    }
}

CSS:
.color2
{
    background-image: none !important;
    background-color: Blue !important;
}

Thanks,
Shinu.
0
Joseph
Top achievements
Rank 1
answered on 15 Jul 2014, 12:06 AM
Ok i'm going to give this one more try, i thought i explained it well enough that i didn't have to go this route.

The page is rendering well with the right color.  It is fine.
My problem is, on a click of a button I do a RadGrid1.MasterTableView.ExportToPDF or ExportToExcel or ExporttoWord
and this is where i am having a problem, because you cannot pass a style class.

I did show a code above and was able to make the color of the MasterTableView header, on export to pdf, except i wasn't able to do it on the DetailTable - GridTableView header, the header is just plain white, again on export to PDF, Excel, Word.  So yeah i would like to  know how I can do that so that it will look good on PDF, Excel and/or Word once exported out - programatically 
0
Shinu
Top achievements
Rank 1
answered on 15 Jul 2014, 04:03 AM
Hi Joseph,

I apologize for misunderstanding your requirement. Please try the below c# code snippet to achieve your scenario.

C#:
public static int flag = 0;
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.ExportToPdfCommandName)
    {
        flag = 1;
    }
}
protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
{
    if (flag == 1)
    {
        if (e.Item is GridHeaderItem && e.Item.OwnerTableView.Name == "Orders")
        {
            e.Item.Style["background-color"] = "Blue";
        }
    }
}

Let me know if you have any concern.
Thanks,
Shinu.
0
Joseph
Top achievements
Rank 1
answered on 16 Jul 2014, 05:24 PM
Hey Shinu, thank you for all your help

Is there a way for me to get access to the RadGrid1 GridTableView so i can change the color?  The code below works to change the color of the MasterTableView header:
Private Sub ExpandRadGrid1ForExport()
        For Each hdrItem As GridHeaderItem In RadGrid1.MasterTableView.GetItems(GridItemType.Header)
            hdrItem.BackColor = System.Drawing.Color.LightBlue
            For Each cell As TableCell In hdrItem.Cells
                cell.Style("text-align") = "left"
            Next
        Next
        If RadGrid1.MasterTableView.HasDetailTables Then
            For Each grdTblView As GridTableView In RadGrid1.MasterTableView.DetailTables
                grdTblView.HierarchyDefaultExpanded = True
                If grdTblView.HasDetailTables Then
                    For Each gtv As GridTableView In grdTblView.DetailTables
                        gtv.HierarchyDefaultExpanded = True
                    Next
                End If
            Next
        End If
    End Sub

RadGrid1 partial code:

<telerik:RadGrid ID="RadGrid1" runat="server" Width="100%" ShowStatusBar="true" AutoGenerateColumns="False"
                   PageSize="20" AllowSorting="false" AllowMultiRowSelection="False" AllowPaging="False"
                   Skin="Vista">
                   <PagerStyle Mode="NumericPages"></PagerStyle>
                   <MasterTableView Width="100%" DataKeyNames="CustomerName" AllowMultiColumnSorting="True">
                       <DetailTables>
                           <telerik:GridTableView DataKeyNames="ListingName,EventName" Name="Listings" Width="100%" AllowPaging="true" PagerStyle-PageSizes="15">
                               <DetailTables>
                                   <telerik:GridTableView Name="Events" Width="100%">
                                       <Columns>
                                           <telerik:GridBoundColumn HeaderText="City" HeaderButtonType="TextButton" DataField="ListedCity"
                                               HeaderStyle-Width="300">
                                           </telerik:GridBoundColumn>


I have tried the code below and that didn't work:

For Each hdrItem2 As GridHeaderItem In RadGrid1.MasterTableView.DetailTables(0).GetItems(GridTableView)
            hdrItem2.BackColor = System.Drawing.Color.LightBlue
        Next



Note I call ExpandRadGrid1ForExport() from PerformanceCustomer_ButtonClick which exports the RadGrid1 into PDF.
0
Accepted
Shinu
Top achievements
Rank 1
answered on 17 Jul 2014, 05:15 AM
Hi Joseph,

Please try the below code snippet to achieve your scenario.

VB:
Protected Sub rbtnExportToPDF_Click(sender As Object, e As EventArgs)
    For Each hdrItem As GridHeaderItem In RadGrid1.MasterTableView.GetItems(GridItemType.Header)
        hdrItem.BackColor = System.Drawing.Color.LightBlue
        For Each cell As TableCell In hdrItem.Cells
            cell.Style("text-align") = "left"
        Next
    Next
    For Each item As GridDataItem In RadGrid1.Items
        If item.OwnerTableView.Name = "Orders" Then
            Dim tableView As GridTableView = DirectCast(item.OwnerTableView, GridTableView)
            For Each hItem As GridHeaderItem In tableView.GetItems(GridItemType.Header)
                hItem.BackColor = System.Drawing.Color.LightBlue
            Next
        End If
    Next
    RadGrid1.MasterTableView.ExportToPdf()
End Sub

Thanks,
Shinu.
Tags
Ajax
Asked by
Joseph
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 1
Joseph
Top achievements
Rank 1
Share this question
or