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

FrozenColumnsCount issue

26 Answers 444 Views

Grid

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

Joe Anelli asked on 24 Jul 2008, 02:11 PM

So I have a radgrid with say 20 columns that I'm trying to lock the first 3 columns on. This seems to work however the scrolling seems to be a little off. If I drag the scroll bar to the right it never remotely comes close to making it to the last column of the grid and if I click the right arrow one by one it generally will get almost always the to the end of the grid sometimes it will. Is this a bug or am I doing something wrong

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" OnAjaxRequest="RadAjaxManager1_AjaxRequest">
 <AjaxSettings>
 <telerik:AjaxSetting AjaxControlID="RadAjaxManager1">
 <UpdatedControls>
 <telerik:AjaxUpdatedControl ControlID="RadGrid2" LoadingPanelID="RadAjaxLoadingPanel2"/>
 </UpdatedControls>
 </telerik:AjaxSetting>
 </AjaxSettings>
 </telerik:RadAjaxManager>

 <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel2" runat="server" Height="75px" Width="75px" Transparency="1">
 <img alt="Loading..." src='<%= RadAjaxLoadingPanel.GetWebResourceUrl(Page, "Telerik.Web.UI.Skins.Default.Ajax.loading.gif") %>' style="border:0;" />
 </telerik:RadAjaxLoadingPanel>

 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:EDSDConnectionString %>"
 SelectCommand="SELECT * FROM INSPECTOR">
 </asp:SqlDataSource>

 <telerik:RadGrid ID="RadGrid2" runat="server" AllowPaging="True" PageSize="25" DataSourceID="SqlDataSource1"
 GridLines="None" width="800px">
 <MasterTableView AutoGenerateColumns="False" DataKeyNames="inspector_pbid" DataSourceID="SqlDataSource1">
 <RowIndicatorColumn>
 <HeaderStyle Width="20px" />
 </RowIndicatorColumn>
 <ExpandCollapseColumn>
 <HeaderStyle Width="20px" />
 </ExpandCollapseColumn>
 <Columns>
 <telerik:GridBoundColumn DataField="inspector_pbid" DataType="System.Int32" HeaderText="inspector_pbid"
 ReadOnly="True" SortExpression="inspector_pbid" UniqueName="inspector_pbid">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_id_prefix" HeaderText="inspector_id_prefix"
 SortExpression="inspector_id_prefix" UniqueName="inspector_id_prefix">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_id_suffix" DataType="System.Int32"
 HeaderText="inspector_id_suffix" SortExpression="inspector_id_suffix" UniqueName="inspector_id_suffix">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_id" HeaderText="inspector_id" ReadOnly="True"
 SortExpression="inspector_id" UniqueName="inspector_id">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_first_name" HeaderText="inspector_first_name"
 SortExpression="inspector_first_name" UniqueName="inspector_first_name">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_middle_name" HeaderText="inspector_middle_name"
 SortExpression="inspector_middle_name" UniqueName="inspector_middle_name">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_last_name" HeaderText="inspector_last_name"
 SortExpression="inspector_last_name" UniqueName="inspector_last_name">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_suffix" HeaderText="inspector_suffix"
 SortExpression="inspector_suffix" UniqueName="inspector_suffix">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_nick_name" HeaderText="inspector_nick_name"
 SortExpression="inspector_nick_name" UniqueName="inspector_nick_name">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_ssn" HeaderText="inspector_ssn" SortExpression="inspector_ssn"
 UniqueName="inspector_ssn">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_date_of_birth" DataType="System.DateTime"
 HeaderText="inspector_date_of_birth" SortExpression="inspector_date_of_birth"
 UniqueName="inspector_date_of_birth">
 </telerik:GridBoundColumn>
 <telerik:GridCheckBoxColumn DataField="inspector_is_citizen" DataType="System.Boolean"
 HeaderText="inspector_is_citizen" SortExpression="inspector_is_citizen" UniqueName="inspector_is_citizen">
 </telerik:GridCheckBoxColumn>
 <telerik:GridBoundColumn DataField="inspector_ethnicity_type_pbid" DataType="System.Int32"
 HeaderText="inspector_ethnicity_type_pbid" SortExpression="inspector_ethnicity_type_pbid"
 UniqueName="inspector_ethnicity_type_pbid">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_gender" HeaderText="inspector_gender"
 SortExpression="inspector_gender" UniqueName="inspector_gender">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_elearning_status_type_pbid" DataType="System.Int32"
 HeaderText="inspector_elearning_status_type_pbid" SortExpression="inspector_elearning_status_type_pbid"
 UniqueName="inspector_elearning_status_type_pbid">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_elearning_request_date" DataType="System.DateTime"
 HeaderText="inspector_elearning_request_date" SortExpression="inspector_elearning_request_date"
 UniqueName="inspector_elearning_request_date">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_home_airport_code" HeaderText="inspector_home_airport_code"
 SortExpression="inspector_home_airport_code" UniqueName="inspector_home_airport_code">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_email_address" HeaderText="inspector_email_address"
 SortExpression="inspector_email_address" UniqueName="inspector_email_address">
 </telerik:GridBoundColumn>
 <telerik:GridCheckBoxColumn DataField="inspector_has_valid_email" DataType="System.Boolean"
 HeaderText="inspector_has_valid_email" SortExpression="inspector_has_valid_email"
 UniqueName="inspector_has_valid_email">
 </telerik:GridCheckBoxColumn>
 <telerik:GridCheckBoxColumn DataField="inspector_is_direct_deposit" DataType="System.Boolean"
 HeaderText="inspector_is_direct_deposit" SortExpression="inspector_is_direct_deposit"
 UniqueName="inspector_is_direct_deposit">
 </telerik:GridCheckBoxColumn>
 <telerik:GridBoundColumn DataField="inspector_driver_license_number" HeaderText="inspector_driver_license_number"
 SortExpression="inspector_driver_license_number" UniqueName="inspector_driver_license_number">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_driver_license_state_issued" HeaderText="inspector_driver_license_state_issued"
 SortExpression="inspector_driver_license_state_issued" UniqueName="inspector_driver_license_state_issued">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_date_license_expires" DataType="System.DateTime"
 HeaderText="inspector_date_license_expires" SortExpression="inspector_date_license_expires"
 UniqueName="inspector_date_license_expires">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_referred_by" HeaderText="inspector_referred_by"
 SortExpression="inspector_referred_by" UniqueName="inspector_referred_by">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_sign_up_status" HeaderText="inspector_sign_up_status"
 SortExpression="inspector_sign_up_status" UniqueName="inspector_sign_up_status">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_deactivation_type_pbid" DataType="System.Int32"
 HeaderText="inspector_deactivation_type_pbid" SortExpression="inspector_deactivation_type_pbid"
 UniqueName="inspector_deactivation_type_pbid">
 </telerik:GridBoundColumn>
 <telerik:GridCheckBoxColumn DataField="inspector_is_active" DataType="System.Boolean"
 HeaderText="inspector_is_active" SortExpression="inspector_is_active" UniqueName="inspector_is_active">
 </telerik:GridCheckBoxColumn>
 <telerik:GridBoundColumn DataField="inspector_date_created" DataType="System.DateTime"
 HeaderText="inspector_date_created" SortExpression="inspector_date_created" UniqueName="inspector_date_created">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_date_last_logon" DataType="System.DateTime"
 HeaderText="inspector_date_last_logon" SortExpression="inspector_date_last_logon"
 UniqueName="inspector_date_last_logon">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_date_last_modified" DataType="System.DateTime"
 HeaderText="inspector_date_last_modified" SortExpression="inspector_date_last_modified"
 UniqueName="inspector_date_last_modified">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_last_modified_by" HeaderText="inspector_last_modified_by"
 SortExpression="inspector_last_modified_by" UniqueName="inspector_last_modified_by">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn DataField="inspector_password" HeaderText="inspector_password"
 SortExpression="inspector_password" UniqueName="inspector_password">
 </telerik:GridBoundColumn>
 </Columns>
 </MasterTableView>
 <ClientSettings>
 <Scrolling AllowScroll="True" UseStaticHeaders="True" FrozenColumnsCount="3" SaveScrollPosition="true" />
 </ClientSettings>
 </telerik:RadGrid>

26 Answers, 1 is accepted

answered on 25 Jul 2008, 02:56 PM

First off thank you for the response.

I'm still experiencing the problem in ie6 the horizontal scroll still remains almost the size of the grid and if I click just left of the right arrow over and over it will scroll but the dragging of the scroll bar does not seem to work correctly

It does seem to work in firefox. However I do notice in firefox is that the grid header text will carry over into the next cell when scrolling.

Ideally I need this to work for ie6 as our corporate policy prohibits us from using firefox and ie7 for development at the moment.

Any assistance would be appreciated. Once again thanks

Accepted

answered on 29 Jul 2008, 06:37 AM

Hi Joe,

I reviewed your code again and found some differences. Can you please set HeaderStyle Width of the columns to get fixed layout? Something like this:

    
            <telerik:RadGrid ID="RadGrid1" runat="server" ... 
        
                <MasterTableView /> 
        
                <HeaderStyle Width="200px" /> 
        
                ... 
        
            </telerik:RadGrid>

Let us know whether this helps or if you need further assistance.

All the best,
Konstantin Petkov
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

answered on 13 Mar 2009, 08:24 PM

I am having an issue similar to the one listed above on the current release of the RadGrid. My issue is that I cannot specify a single HeaderStyle for the table since different columns are different widths. Each column does have the ItemStyle and HeaderStyle specified with the appropriate width for that column. The grid we are using has it's width set to 100% instead of the being fixed width. The issue we are seeing is that based on the width of the screen part of the last column is being cut off and scrolling to the right always leaves the last column partially cut off. I have tried setting the grid to being fixed width instead of percent and as long as the width is cutting off one of the columns the last column is usually cut off when scrolling to the right with the first column locked. I noticed in the sample located here: Forzen Column Demo that when you scroll to the far right you will see the Manager column and then empty space. I think that would work for what we need but I cannot seem to get our grid to display that blank space. Any ideas?

answered on 16 Mar 2009, 11:10 AM

Hello Adam,

Can you please verify that you are using the latest version 2009.1.311 of RadControls for ASP.NET AJAX in your project and specified TableLayout = Fixed for the MasterTableView when defining fixed widths for the grid columns? Thus the last column should not be cut off. You may also review the relevant online demo which illustrates frozen columns usage:

http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/frozencolumns/defaultcs.aspx

and use it for further reference.

Best regards,
Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 16 Mar 2009, 08:54 PM

I have checked and we are testing with version 2009.1.311.35. I tried playing with the TableLayout setting and it didn't seem to help. I have a code sample that I can send. It is a bit large to post in here as it includes code for setting the Item and Header Templates. We have to create grouped headers which we do in the code behind. It is specifically when one of these "grouped" columns is on the grid that we have the scrolling issue. I have even tried adding a fixed width "empty" column to the end of the grid and depending on the size of the browser, sometimes the column is visible (although not full width) and sometimes you don't even know this column is on the grid. Let me know where to send the sample too and I will email it out.

answered on 16 Feb 2010, 07:48 PM

clipped-column-at-end.jpg

I followed instructions as per this thread and current verison of Q3 2009 2009.3.1314.35

    
            <telerik:RadGrid CssClass="topGrid" EnableEmbeddedSkins="false" runat="server" ID="gridView" AutoGenerateColumns="false" DataSourceID="dsPlanGoals" AllowSorting="true" AllowPaging="false">  
        
                    <PagerStyle Position="Top" /> 
        
                    <MasterTableView AllowSorting="true" DataKeyNames="Campaign_ID, BaselineTrx, BaselineMst, MB_Trx, Data_Year, Data_Month">  
        
                        <Columns> 
        
                            <telerik:GridTemplateColumn HeaderText="Brand" HeaderStyle-CssClass="headerTh" ItemStyle-CssClass="brand" HeaderStyle-Width="100" ItemStyle-Width="100" > 
        
                                <ItemTemplate> 
        
                                    <asp:Literal ID="lblRecordType" runat="server" Visible='<%# (int)Eval("RecordType") == 1 %>' Text='<%# Eval("Brand_Name") %>' />                          
        
                                    <asp:Literal ID="Label2" runat="server" Visible='<%# (int)Eval("RecordType") != 1 %>' Text='Competitors' />                                                  
        
                                </ItemTemplate> 
        
                            </telerik:GridTemplateColumn>                 
        
                            <telerik:GridTemplateColumn  HeaderStyle-CssClass="rightScroll"  ItemStyle-CssClass="rightScroll"  HeaderStyle-Width="110" ItemStyle-Width="110">  
        
                                <HeaderTemplate> 
        
                                    <table style="width:100%" cellpadding="0" cellspacing="0">   
        
                                        <tr> 
        
                                            <td colspan="2">Baseline</td> 
        
                                        </tr> 
        
                                        <tr> 
        
                                            <td class="left">Trx</td> 
        
                                            <td class="right">Mst</td> 
        
                                        </tr> 
        
                                    </table>                      
        
                                </HeaderTemplate> 
        
                                <ItemTemplate> 
        
                                    <table style="width:100%" cellpadding="0" cellspacing="0">   
        
                                        <tr> 
        
                                            <td><%# Eval("BaselineTrx", "{0:n0}")%></td>  
        
                                            <td><%# Eval("BaselineMst", "{0:n2}")%></td>  
        
                                        </tr> 
        
                                    </table> 
        
                                </ItemTemplate> 
        
                            </telerik:GridTemplateColumn>                              
        
                        </Columns> 
        
                    </MasterTableView> 
        
                    <ClientSettings Scrolling-AllowScroll="true" Scrolling-UseStaticHeaders="true"  Scrolling-FrozenColumnsCount="2"  /> 
        
                </telerik:RadGrid> 
        
                  <div class="tileSubHeader">District Goals</div>    
        
                <telerik:RadGrid CssClass="btmGrid"  EnableEmbeddedSkins="false" runat="server" ID="gridViewDistricts" AutoGenerateColumns="false" DataSourceID="dsPlanDistrictGoals"  AllowSorting="true" AllowPaging="false" > 
        
                    <MasterTableView AllowPaging="false" DataKeyNames="Campaign_ID, District_Name, Trx, Mst, MB_Trx, Data_Year, Data_Month" AllowSorting="false">  
        
                        <ItemStyle CssClass="row" /> 
        
                        <AlternatingItemStyle CssClass="alt" /> 
        
                        <Columns>     
        
                            <telerik:GridTemplateColumn HeaderStyle-CssClass="headerTh" ItemStyle-CssClass="merged" HeaderStyle-Width="25" ItemStyle-Width="25" >                  
        
                                <ItemTemplate> 
        
                                    <asp:CheckBox runat="server" ID="chkTargeted" CssClass="targeted" Visible='<%# (bool)Eval("InDistrict") %>'  Checked='<%# Eval("Campaign_Flag_Indicator") %>' /> 
        
                                </ItemTemplate> 
        
                            </telerik:GridTemplateColumn> 
        
                            <telerik:GridTemplateColumn HeaderStyle-CssClass="headerTh" ItemStyle-CssClass="merged" HeaderStyle-Width="80" ItemStyle-Width="80">                  
        
                                <ItemTemplate> 
        
                                    <asp:HyperLink runat="server" ID="physLink" Text="PHYS Link" Visible='<%# Eval("InDistrict") %>' NavigateUrl='<%# string.Format("javascript:showDistrictPhysicians({0}, \"{1}\", {2}, {3})", Eval("Campaign_ID"), Eval("District_Name"), Eval("Start_Data_Key"), Eval("End_Data_Key")) %>' />                          
        
                                    <asp:HyperLink runat="server" ID="distLink" Text='DIST Link' Visible='<%# Eval("InDistrict") %>' NavigateUrl='<%# string.Format("javascript:showDistrictChart({0}, \"{1}\", {2}, {3},{4})", Eval("Campaign_ID"), Eval("District_Name"), Eval("Start_Data_Key"), Eval("End_Data_Key"), Eval("Brand_ID")) %>' />                          
        
                                </ItemTemplate> 
        
                            </telerik:GridTemplateColumn> 
        
                            <telerik:GridBoundColumn HeaderText="District" DataField="District_Name" HeaderStyle-CssClass="headerTh" ItemStyle-CssClass="merged" HeaderStyle-Width="80" ItemStyle-Width="80" />                  
        
                            <telerik:GridTemplateColumn HeaderText="Brand" HeaderStyle-CssClass="headerTh" ItemStyle-CssClass="brand" HeaderStyle-Width="90" ItemStyle-Width="90">  
        
                                <ItemTemplate> 
        
                                    <asp:Literal ID="lblRecordType" runat="server" Visible='<%# (int)Eval("RecordType") == 1 %>' Text='<%# Eval("Brand_Name") %>' />                          
        
                                    <asp:Literal ID="Label2" runat="server" Visible='<%# (int)Eval("RecordType") != 1 %>' Text='Competitors' />                          
        
                                </ItemTemplate> 
        
                            </telerik:GridTemplateColumn>     
        
                            <telerik:GridTemplateColumn HeaderStyle-CssClass="rightScroll" ItemStyle-CssClass="rightScroll"  HeaderStyle-Width="110" ItemStyle-Width="110">  
        
                                <HeaderTemplate  > 
        
                                    <table style="width:100%" cellpadding="0" cellspacing="0">   
        
                                        <tr> 
        
                                            <td colspan="2" class="top">Baseline</td> 
        
                                        </tr> 
        
                                        <tr> 
        
                                            <td class="left">Trx</td> 
        
                                            <td class="right">Mst</td> 
        
                                        </tr> 
        
                                    </table>                      
        
                                </HeaderTemplate> 
        
                                <ItemTemplate> 
        
                                    <table style="width:100%" cellpadding="0" cellspacing="0">   
        
                                        <tr> 
        
                                            <td><%# Eval("Trx", "{0:n0}") %></td>  
        
                                            <td><%# Eval("Mst", "{0:n2}")%></td>  
        
                                        </tr> 
        
                                    </table> 
        
                                </ItemTemplate> 
        
                            </telerik:GridTemplateColumn>               
        
                        </Columns> 
        
                    </MasterTableView>

answered on 06 Apr 2011, 10:44 PM

frozenafter.JPG

exporttoexcel.JPG

Was this problem resolved? If not, I was having the same issue where it's getting cut-off when i scroll to the right. I'm using version 2010.3.1109.20 for the controls.

I performed some testing by adding columns as I go. I've found out that the problem starts when the column count is more than 15. Hope this helps.

I've got another issue when exporting the data into excel, the headers are reversed.

See attached images.

Thanks...

Joey

answered on 12 Apr 2011, 10:07 AM

Hello Joey,

The problem with frozen columns is resolved in Q2 2010 version of RadControls for ASP.NET AJAX. Please download the latest version of RadControls for ASP.NET AJAX and let me know if the issue still persists.
http://www.telerik.com/support/kb/aspnet-ajax/general/updating-radcontrols-for-asp-net-to-another-version-or-license.aspx

Additionally, if the problem with exporting persists I will ask you to send us the problematic code. Thus I could check it out and see what could have gone wrong and how to solve it.

Best wishes,
Pavlina
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

answered on 12 Apr 2011, 07:52 PM

reference.JPG

I've installed and followed the steps to install the hotfix but to no avail. The problem still persists.

Attached is an image thats display what current version I'm using. This is also running on .NET 2.0 framework.

Let me know.

Thanks.....

Joey

answered on 15 Apr 2011, 04:48 PM

Hi,

Can you please check whether setting fixed widths for your grid columns (through their HeaderStyle -> Width property) or TableLayout = Fixed for the master table makes a difference? Note that the default table layout for the grid with scrolling enabled is auto and this may cause the unwanted effect when you enable the frozen columns functionality.
In order to display all columns when using frozen columns you should increase the Header Style Width of the last column in RadGrid. Thus you should be able to navigate to the leftmost column as expected to see the information in it.

I am looking forward for your reply.

Regards,
Pavlina
the Telerik team

answered on 18 Apr 2011, 08:07 PM

Still not working. I tried your suggestions but to no avail. Below is the html code:

******************************************************************

telerik:RadGrid ID="RadGrid1" AllowSorting="True" OnNeedDataSource="RadGrid1_NeedDataSource" ShowFooter="True"

AllowPaging="True" runat="server" Width="100%" AllowMultiRowSelection="False" ShowGroupPanel="True"

Skin="Sitefinity" ExportSettings-ExportOnlyData="true"

ExportSettings-IgnorePaging="true"

ExportSettings-OpenInNewWindow="true" GridLines="none" AutoGenerateColumns="False" ShowStatusBar="true">

<telerik:GridGroupByExpression>

<telerik:GridGroupByField FieldName="AgentName" HeaderText="Agent Name" FieldAlias="AgentName" />

</SelectFields>

<telerik:GridGroupByField FieldName="AgentName" FieldAlias="AgentName" />

</GroupByFields>

</telerik:GridGroupByExpression>

</GroupByExpressions>

<telerik:GridBoundColumn DataField="AgentNumber" HeaderText="Agent #" SortExpression="AgentNumber" UniqueName="AgentNumber" HeaderButtonType="TextButton" Aggregate="Count" FooterText="Totals: ">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgentName" HeaderText="Agent Name" SortExpression="AgentName" UniqueName="AgentName" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridNumericColumn UniqueName="Premium" HeaderText="Premium" DataField="Premium" DataType="System.Double" SortExpression="Premium" NumericType="Currency" HeaderButtonType="TextButton" Groupable="False" Aggregate="Sum" FooterAggregateFormatString="{0:C}">

</telerik:GridNumericColumn>

<telerik:GridBoundColumn DataField="PolicyNumber" HeaderText="Policy #" SortExpression="PolicyNumber" UniqueName="PolicyNumber" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Plan" HeaderText="Plan" SortExpression="Plan" UniqueName="Plan" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PolicyStatus" HeaderText="Status" SortExpression="PolicyStatus" UniqueName="PolicyStatus" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="IssueState" HeaderText="Issued State" SortExpression="IssueState" UniqueName="IssueState" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="IssuedDate" HeaderText="Issued Date" SortExpression="IssuedDate" UniqueName="IssuedDate" DataFormatString="{0:MM/dd/yyyy}" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PaidDate" HeaderText="Paid Date" SortExpression="PaidDate" UniqueName="PaidDate" DataFormatString="{0:MM/dd/yyyy}" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="EffectiveDate" HeaderText="Effective Date" SortExpression="EffectiveDate" UniqueName="EffectiveDate" DataFormatString="{0:MM/dd/yyyy}" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="EntryDate" HeaderText="Entry Date" SortExpression="EntryDate" UniqueName="EntryDate" DataFormatString="{0:MM/dd/yyyy}" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="IssueAge" HeaderText="Issued Age" SortExpression="IssueAge" UniqueName="IssueAge" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="BillMode" HeaderText="Mode" SortExpression="BillMode" UniqueName="BillMode" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="BillType" HeaderText="Billing Type" SortExpression="BillType" UniqueName="BillType" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="InsuredName" HeaderText="Insured Name" SortExpression="InsuredName" UniqueName="InsuredName" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="InsuredAddr" HeaderText="Street Address" SortExpression="InsuredAddr" UniqueName="InsuredAddr" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="InsuredCity" HeaderText="City" SortExpression="InsuredCity" UniqueName="InsuredCity" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="InsuredState" HeaderText="State" SortExpression="InsuredState" UniqueName="InsuredState" HeaderButtonType="TextButton">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn UniqueName="InsuredZip" GroupByExpression="InsuredZip Group By InsuredZip" SortExpression="InsuredZip" HeaderText="Zip Code">

#IIf(Not (Eval("InsuredZip") Is DBNull.Value) And Convert.ToInt64(Eval("InsuredZip")) > 99999, String.Format("{0:#####-####}", Convert.ToInt64(DataBinder.Eval(Container.DataItem, "InsuredZip"))), DataBinder.Eval(Container.DataItem, "InsuredZip").ToString())%>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="InsuredPhone" GroupByExpression="InsuredPhone Group By InsuredPhone" SortExpression="InsuredPhone" HeaderText="Phone">

#IIf(Not (Eval("InsuredPhone") Is DBNull.Value), String.Format("{0:(###) ###-####}", Convert.ToInt64(DataBinder.Eval(Container.DataItem, "InsuredPhone"))), String.Empty)%>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<CommandItemSettings ShowExportToWordButton="True" ShowExportToExcelButton="True"

ShowExportToCsvButton="True" ShowExportToPdfButton="True"

ShowAddNewRecordButton="False" ExportToPdfText="Export to Pdf" />

</MasterTableView>

</ClientSettings>

</telerik:RadGrid>
******************************************************************

Look forward to your reply.

Thanks...

Joey

answered on 20 Apr 2011, 03:22 PM

test-page-2.zip

Hello Joey,

I followed your scenario and prepared a simple working project that is working as expected. Please give it a try and let me know if it helps to resolve the problem you are facing.

Additionally, note that you should not set ItemStyle-Width property for your last column(InsuredPhone). Only HeaderStyle-With should be used for column widths.

Greetings,
Pavlina
the Telerik team