[Solved] Having problems with the exports

[TelerikUser]

For some rason when I hit the export buttons I'm getting the columns names but the data is missing. Any idea what is wrong (see code below):

     <telerik:RadGrid ID="RadGrid2" Width="950px" runat="server" AutoGenerateColumns="False" OnNeedDataSource="RadGrid2_NeedDataSource" AllowSorting="True" OnItemCommand="RadGrid2_ItemCommand" OnItemCreated="RadGrid2_ItemCreated" Skin="Office2007" >

            <MasterTableView DataKeyNames="unit_id" CellSpacing="-1">

                    <RowIndicatorColumn>
                    <HeaderStyle Width="20px"></HeaderStyle>
                    </RowIndicatorColumn>

                      <Columns>
                        <telerik:GridTemplateColumn UniqueName="TemplateColumn6" HeaderText="col1" AllowFiltering="False">
                            <ItemTemplate>
                                <asp:HyperLink ID="HyperLink6" runat="server"><%# Eval("unit_label") %></asp:HyperLink>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>

                        <telerik:GridTemplateColumn UniqueName="TemplateColumn3" HeaderText="col2" AllowFiltering="False">
                            <ItemTemplate>
                                <asp:HyperLink ID="HyperLink3" runat="server"><%# Eval("date") %></asp:HyperLink>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>

                        <telerik:GridTemplateColumn UniqueName="TemplateColumn4" HeaderText="col3" AllowFiltering="False">
                            <ItemTemplate>
                                <asp:HyperLink ID="HyperLink4" runat="server"><%# Eval("event") %></asp:HyperLink>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>

                        <telerik:GridTemplateColumn UniqueName="TemplateColumn5" HeaderText="col4" AllowFiltering="False">
                            <ItemTemplate>
                                <asp:HyperLink ID="HyperLink5" runat="server"><%# Eval("address") %></asp:HyperLink>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>

                        <telerik:GridTemplateColumn UniqueName="TemplateColumn8" HeaderText="col5" AllowFiltering="False">
                            <ItemTemplate>
                                <asp:HyperLink ID="HyperLink8" runat="server"><%# Eval("data_status")%></asp:HyperLink>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                    </Columns>

                    <ExpandCollapseColumn>
                    <HeaderStyle Width="20px"></HeaderStyle>
                    </ExpandCollapseColumn>

                    </MasterTableView>

    </telerik:RadGrid>

        protected void Button1_Click(object sender, System.EventArgs e)
        {
            RadGrid2.ExportSettings.ExportOnlyData = true;
            RadGrid2.ExportSettings.OpenInNewWindow = true;
            RadGrid2.ExportSettings.FileName = "View_" + DateTime.Now;
            RadGrid2.MasterTableView.ExportToExcel();

        }

        protected void Button2_Click(object sender, System.EventArgs e)
        {
            RadGrid2.ExportSettings.ExportOnlyData = true;
            RadGrid2.ExportSettings.OpenInNewWindow = true;
            RadGrid2.ExportSettings.FileName = "View_" + DateTime.Now;
            RadGrid2.MasterTableView.ExportToWord();
        }

        protected void Button3_Click(object sender, System.EventArgs e)
        {
            RadGrid2.ExportSettings.ExportOnlyData = true;
            RadGrid2.ExportSettings.OpenInNewWindow = true;
            RadGrid2.ExportSettings.FileName = "View_" + DateTime.Now;
            RadGrid2.MasterTableView.ExportToCSV();
        }

        protected void Button4_Click(object sender, System.EventArgs e)
        {
            RadGrid2.ExportSettings.ExportOnlyData = true;
            RadGrid2.ExportSettings.OpenInNewWindow = true;
            RadGrid2.ExportSettings.FileName = "View_" + DateTime.Now;
            RadGrid2.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.ExcelML;
            RadGrid2.MasterTableView.ExportToExcel();
        }

        protected void Button5_Click(object sender, System.EventArgs e)
        {
            RadGrid2.ExportSettings.ExportOnlyData = true;
            RadGrid2.ExportSettings.OpenInNewWindow = true;
            RadGrid2.ExportSettings.FileName = "FleetView_" + DateTime.Now;
            RadGrid2.MasterTableView.ExportToPdf();
        }

[Pavlina]

Hi,

For more information about how to export GridTemplateColumn, please examine the following help article:
Exporting tips and tricks (Exporting GridButtonColumn/GridTemplateColumn/GridHyperLinkColumn data section)

I hope this helps.

All the best,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[TelerikUser]

Well, I looked at tips and tricks but I couldn't find anything that will make my export work.
I have some other RadGrids on my project that work but I don't understand why doesn't work on this specific case.
Thank You!

[Pavlina]

Hello,

I am afraid that the most suitable approach to export GridTemplateColumn is explain in Exporting GridButtonColumn/GridTemplateColumn/GridHyperLinkColumn data section of this help topic.
You merely need to hide initially GridBoundColumn with the same data (setting its Visible property to false), then switch its visibility with the one for the GridTemplateColumn, and finally export it to Excel calling Telerik RadGrid's ExportToExcel method.
Could you please confirm that you have examine this suggestion? If so what is the result?

Sincerely yours,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.