Telerik Forums
UI for ASP.NET AJAX Forum
11 answers
703 views
Hi All,

I have Radgrid for which i am using custom paging,and i need to give export to excel functionality for this Grid, and i am using RadGrid the Export to excel functionality, but it is not working some times , some times means 
when the page load without giving any filter to grid this export to excel functionality is working , but when i give any column filter that time it is not working properly , even my grid is showing 100 records with 10 pages but when i click export button it is exporting only first page records (my Radgrid page size is 10 records per page.), even though i given IgnorePaging = True in Export setting.
but when i tried for the RadGrid where custom paging is not implimented for that RadGrid it is working

if You have any solution regarding this please help me to sharing.

My code is below
<telerik:RadGrid ID="rg_PlannedOrders" runat="server" OnNeedDataSource="rg_PlannedOrders_NeedDataSource" AllowMultiRowSelection="true"
                         AllowCustomPaging="true" OnDeleteCommand="rg_PlannedOrders_DeleteCommand" OnItemDataBound="rg_PlannedOrders_OnItemDataBound"
                         OnItemCommand="rg_PlannedOrders_ItemCommand" OnPageIndexChanged="rg_PlannedOrders_PageIndexChanged" PageSize="50" >
                           <ExportSettings ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true" HideStructureColumns="false"  FileName = "PlannedOrderExc">
                                <Excel Format="Biff" />
                   </ExportSettings> 
                        <MasterTableView CommandItemDisplay="Top" AllowMultiColumnSorting="true" AutoGenerateColumns="false">

   
CS side code is 

protected void rg_PlannedOrders_ItemCommand(object sender, GridCommandEventArgs e)
     {
         try
         {
             switch (e.CommandName)
             {
 case RadGrid.ExportToExcelCommandName:
                     rg_PlannedOrders.AllowCustomPaging = false;
                     ((GridColumn)rg_PlannedOrders.Columns.FindByUniqueName("DeleteCommandColumn")).Visible = false;
                     ((GridColumn)rg_PlannedOrders.Columns.FindByUniqueName("CheckBoxSelect_Detail")).Visible = false;
                     ((GridColumn)rg_PlannedOrders.Columns.FindByUniqueName("History")).Visible = false;
                     ((GridColumn)rg_PlannedOrders.Columns.FindByUniqueName("TemplateColumn_IsConsolidate")).Visible = false;
                     ((GridColumn)rg_PlannedOrders.Columns.FindByUniqueName("Temp_IsContractMRP")).Visible = false;

                     break;


                 default:

                     break;

                        
}
             string RgInvantoryCache = GetSearchCacheName();
             GridSettingsPersister.SaveGridSettings(rg_PlannedOrders, e, RgInvantoryCache);

         }
         catch (Exception oException)
         {  }

Thanks 
saikumar
Top achievements
Rank 1
 answered on 26 Sep 2017
1 answer
579 views

I am showing a RadTreeView on my page and it has a context menu associated with each node.  When you right click on any node, an option is displayed called "Export".  This export will run a stored procedure and bring data from the database.  I want to export this date to a .txt file.  This is enforced by my business requirements so exporting it to Excel or PDF is not an option!!  I also need to be able to prompt the user for location of where they want to save this file and what they want to name it.  Does telerik have any controls that will help me accomplish these tasks?  I have looked into the ClientExportManager and the export functionalities of the RadGrid and TreeList, but nothing exports data to text file that I can see.

 

thanks

 

doug

Peter Milchev
Telerik team
 answered on 26 Sep 2017
3 answers
126 views
My customer would like the default focus set so when they click the add new record button the focus is set to the first textbox on the input line so they can begin typing without having to click the field first. Is this possible? I don't see any settings that would suggest so. Perhaps a sneaky code behind trick? Any tips greatly appreciated.

~Mike
Swati
Top achievements
Rank 1
 answered on 26 Sep 2017
0 answers
101 views
Any ideas?  Map loads, in IE, but no bubbles.... Works fine in Chrome, Firefox latest versions.  Currently using IE 11 on Windows 7.
Logan Marshall
Top achievements
Rank 2
Iron
 asked on 25 Sep 2017
2 answers
163 views
Hello,
        I am using RadImageAndTextTile.I want to hide Title text and title image when peek template is visible.Please suggest me how could I achieve this?
Thank you
Debasish
Top achievements
Rank 1
 answered on 25 Sep 2017
1 answer
48 views

Hello.

We have a Radmenu that uses a Sitemap data source, and we have the menu set up with a OnClientMouseOut function that shows a overlay to mask a section of the page. However, when the mouse goes over separators, the overlay is hidden, and then pops up again once it goes over a menu item, it's like it does not count separators as being part of the menu. Is there a way to prevent this from happening?

Thanks,

Marco

Peter Milchev
Telerik team
 answered on 25 Sep 2017
3 answers
117 views
Hi could please help me, I'm using RadClientExportManage, to be able export a chart with a table of html but when I added the PageBreakSelector the report doesn't show the chart and the html table only shows the first <td> of the <tr> this is my code
    <script>
        function exportAllPanelItems() {
            var cem = $find("<%=RadClientExportManager1.ClientID%>");
            cem.exportPDF($telerik.$(".panel-container"));
        }
    </script>

 <telerik:RadClientExportManager runat="server" ID="RadClientExportManager1">
       <PdfSettings PaperSize="A4" MarginRight="10mm" MarginLeft="10mm" />
    </telerik:RadClientExportManager>


    <div class="exportButtonContainer">
        <telerik:RadButton RenderMode="Lightweight" ID="RadButton1" runat="server"
            OnClientClicked="exportAllPanelItems" Text="Export Items" AutoPostBack="false" UseSubmitBehavior="false">
        </telerik:RadButton>
    </div>

    <div class="panel-container">
        <div runat="server" id="panelPrinicpal">
            <table style='padding: 0px; width: 100%; cellpadding: 0; cellspacing: 0; font-weight: normal;'>
                <tr>
                    <td valign='top' width='49%'>1000 Sawgrass Corporate Pkwy, Suite 120</td>
                    <td valign='top' width='2%'></td>
                    <td align='right' valign='top' width='49%'>123</td>
                </tr>
            </table>
            <table style='padding: 0px; width: 100%; cellpadding: 0; cellspacing: 0; font-weight: normal;'>
                <tr>
                    <td valign='top' width='49%'>Sunrise, FL 33323</td>
                    <td valign='top' width='2%'></td>
                    <td align='right' valign='top' width='49%'>Sunrise, FL 33323</td>
                </tr>
            </table>
        </div>

        <div id="Div1" class="pageBreak">

            <telerik:RadHtmlChart runat="server" ID="RadHtmlChart1" Width="400" Height="400" Transitions="true"
                Skin="Metro">
                <Appearance>
                    <FillStyle BackgroundColor="Transparent"></FillStyle>
                </Appearance>
                <ChartTitle Text="Server CPU Load By Days">
                    <Appearance Align="Center" BackgroundColor="Transparent" Position="Top">
                    </Appearance>
                </ChartTitle>
                <Legend>
                    <Appearance BackgroundColor="Transparent" Position="Bottom">
                    </Appearance>
                </Legend>
                <PlotArea>
                    <Appearance>
                        <FillStyle BackgroundColor="Transparent"></FillStyle>
                    </Appearance>
                    <XAxis AxisCrossingValue="0" Color="black" MajorTickType="Outside" MinorTickType="Outside"
                        Reversed="false">
                        <Items>
                            <telerik:AxisItem LabelText="Monday"></telerik:AxisItem>
                            <telerik:AxisItem LabelText="Tuesday"></telerik:AxisItem>
                            <telerik:AxisItem LabelText="Wednesday"></telerik:AxisItem>
                            <telerik:AxisItem LabelText="Thursday"></telerik:AxisItem>
                            <telerik:AxisItem LabelText="Friday"></telerik:AxisItem>
                            <telerik:AxisItem LabelText="Saturday"></telerik:AxisItem>
                            <telerik:AxisItem LabelText="Sunday"></telerik:AxisItem>
                        </Items>
                        <LabelsAppearance DataFormatString="{0}" RotationAngle="0" Skip="0" Step="1">
                        </LabelsAppearance>
                        <TitleAppearance Position="Center" RotationAngle="0" Text="Days">
                        </TitleAppearance>
                    </XAxis>
                    <YAxis AxisCrossingValue="0" Color="black" MajorTickSize="1" MajorTickType="Outside"
                        MaxValue="100" MinorTickSize="1" MinorTickType="Outside" MinValue="0" Reversed="false"
                        Step="25">
                        <LabelsAppearance DataFormatString="{0}%" RotationAngle="0" Skip="0" Step="1">
                        </LabelsAppearance>
                        <TitleAppearance Position="Center" RotationAngle="0" Text="CPU Load">
                        </TitleAppearance>
                    </YAxis>
                    <Series>
                        <telerik:LineSeries Name="Week 1">
                            <Appearance>
                                <FillStyle BackgroundColor="#5ab7de"></FillStyle>
                            </Appearance>
                            <LabelsAppearance DataFormatString="{0}%" Position="Above">
                            </LabelsAppearance>
                            <LineAppearance Width="1" />
                            <MarkersAppearance MarkersType="Circle" BackgroundColor="White" Size="8" BorderColor="#5ab7de"
                                BorderWidth="2"></MarkersAppearance>
                            <TooltipsAppearance DataFormatString="{0}%"></TooltipsAppearance>
                            <SeriesItems>
                                <telerik:CategorySeriesItem Y="35"></telerik:CategorySeriesItem>
                                <telerik:CategorySeriesItem Y="52"></telerik:CategorySeriesItem>
                                <telerik:CategorySeriesItem Y="18"></telerik:CategorySeriesItem>
                                <telerik:CategorySeriesItem Y="39"></telerik:CategorySeriesItem>
                                <telerik:CategorySeriesItem></telerik:CategorySeriesItem>
                                <telerik:CategorySeriesItem Y="10"></telerik:CategorySeriesItem>
                                <telerik:CategorySeriesItem Y="6"></telerik:CategorySeriesItem>
                            </SeriesItems>
                        </telerik:LineSeries>
                        <telerik:LineSeries Name="Week 2">
                            <Appearance>
                                <FillStyle BackgroundColor="#2d6b99"></FillStyle>
                            </Appearance>
                            <LabelsAppearance DataFormatString="{0}%" Position="Above">
                            </LabelsAppearance>
                            <LineAppearance Width="1" />
                            <MarkersAppearance MarkersType="Square" BackgroundColor="#2d6b99" Size="8" BorderColor="#2d6b99"
                                BorderWidth="2"></MarkersAppearance>
                            <TooltipsAppearance DataFormatString="{0}%"></TooltipsAppearance>
                            <SeriesItems>
                                <telerik:CategorySeriesItem Y="15"></telerik:CategorySeriesItem>
                                <telerik:CategorySeriesItem Y="23"></telerik:CategorySeriesItem>
                                <telerik:CategorySeriesItem Y="50"></telerik:CategorySeriesItem>
                                <telerik:CategorySeriesItem Y="20"></telerik:CategorySeriesItem>
                                <telerik:CategorySeriesItem Y="93"></telerik:CategorySeriesItem>
                                <telerik:CategorySeriesItem Y="43"></telerik:CategorySeriesItem>
                                <telerik:CategorySeriesItem Y="23"></telerik:CategorySeriesItem>
                            </SeriesItems>
                        </telerik:LineSeries>
                    </Series>
                </PlotArea>
            </telerik:RadHtmlChart>

        </div>
        <div runat="server" id="Div2">
            <telerik:RadPanelBar RenderMode="Lightweight" ID="RadPanelBar1" Skin="Web20" runat="server" Width="300">
                <Items>
                    <telerik:RadPanelItem ImageUrl="images/Honda.png" CssClass="pageBreak" runat="server" Height="60" Expanded="True">
                        <Items>
                            <telerik:RadPanelItem runat="server" Text="Accord" />
                            <telerik:RadPanelItem runat="server" Text="Civic" />
                            <telerik:RadPanelItem runat="server" Text="Civic" />
                            <telerik:RadPanelItem runat="server" Text="CR-V" />
                            <telerik:RadPanelItem runat="server" Text="HR-V" />
                            <telerik:RadPanelItem runat="server" Text="Integra" />
                            <telerik:RadPanelItem runat="server" Text="Jazz" />
                            <telerik:RadPanelItem runat="server" Text="Legend" />
                            <telerik:RadPanelItem runat="server" Text="Prelude" />
                        </Items>
                    </telerik:RadPanelItem>
                    <telerik:RadPanelItem ImageUrl="images/Nissan.png" CssClass="pageBreak" runat="server">
                        <Items>
                            <telerik:RadPanelItem runat="server" Text="350Z" />
                            <telerik:RadPanelItem runat="server" Text="370Z" />
                            <telerik:RadPanelItem runat="server" Text="GT-R" />
                            <telerik:RadPanelItem runat="server" Text="Juke" />
                            <telerik:RadPanelItem runat="server" Text="Pulsar" />
                            <telerik:RadPanelItem runat="server" Text="QashQai" />
                            <telerik:RadPanelItem runat="server" Text="X-Trail" />
                        </Items>
                    </telerik:RadPanelItem>
                </Items>
            </telerik:RadPanelBar>
        </div>
    </div>
Marin Bratanov
Telerik team
 answered on 25 Sep 2017
1 answer
48 views
Hi Telerik team,
Please, how can I keep selected one item after selected?
Thanks, best
Daniel
Daniel Aquere
Top achievements
Rank 2
 answered on 25 Sep 2017
7 answers
466 views
Hello,

VisibleRangeStart and VisibleRangeEnd is readonly; is there a way to change programmatically via code these dates?

Thanks.
Manju
Top achievements
Rank 1
 answered on 25 Sep 2017
1 answer
99 views

I am getting the following javascript error when my radmenu loads : Error:Unable to get property 'addEventListener' of undefined or null reference

This causes some (not all) of the children menu items to not show up. Only 2 dropdowns (children) work and the rest do not drop down.

Is there any way to fix this? I have tried so many things but no luck.

Using IE 11    ASP.net 2.0 C# code.

 

thanks,

-may

Vessy
Telerik team
 answered on 25 Sep 2017
Narrow your results
Selected tags
Tags
+? more
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?