Hi I am using FileExplorer
I want to show files in a folder which I select using FileUpload control.
Then it says that it is Physical path.It need to set the Virtual path.
Anyone has any ideas about this.

When I Edit the selected record.Dropdown selected index be 0 while i want it as well as i retreive from Data.
My Code is like-

 

<telerik:RadGrid ID="grdAudotex" OnItemDataBound="grdAudotex_ItemDataBound" MasterTableView-NoMasterRecordsText="no records found"

 

OnDeleteCommand="grdAudotex_DeleteCommand" OnUpdateCommand="grdAudotex_UpdateCommand" AllowPaging="true" PageSize="4" OnInsertCommand="grdAudotex_InsertCommand" OnPreRender="grdAudotex_PreRender" OnNeedDataSource="grdAudotex_NeedDataSource" runat="server">

 

<PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>

 

<MasterTableView Width="100%" AutoGenerateColumns="false" EditMode="EditForms" CommandItemDisplay="Top" DataKeyNames="Id" InsertItemPageIndexAction="ShowItemOnCurrentPage">

 

<Columns>

 

<telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderStyle-HorizontalAlign="left" />

<%

 

--<telerik:GridBoundColumn UniqueName="Id" DataField="Id" HeaderText="JobID" Visible="false">

</telerik:GridBoundColumn>--

 

 

%>

<%

 

-- <telerik:GridBoundColumn UniqueName="JobTask" DataField="JobTask" HeaderText="Job Task">

</telerik:GridBoundColumn>--

 

 

%>

 

<telerik:GridDropDownColumn UniqueName="ddlstJobTask" EditFormHeaderTextFormat="Job Task" EditFormColumnIndex="0" ListTextField="JobTask" ListValueField="JobTask" ListDataMember="LABOURTYPE" DataField="JobTask" DropDownControlType="RadComboBox" HeaderText="Job Task"></telerik:GridDropDownColumn>

<%

 

--<telerik:GridBoundColumn UniqueName="Description" DataField="Description" HeaderText="Internal Job Task">

</telerik:GridBoundColumn>--

 

 

%>

 

<telerik:GridDropDownColumn UniqueName="ddlstDescription" EditFormHeaderTextFormat="Internal Job Task" EditFormColumnIndex="0" ListTextField="InternalJobTask" ListValueField="InternalJobTask" DropDownControlType="RadComboBox" ListDataMember="InternalJobTask" DataField="InternalJobTask" HeaderText="Internal Job Task"></telerik:GridDropDownColumn>

<%

 

--<telerik:GridBoundColumn UniqueName="WorkProvider" DataField="Name" HeaderText="WorkProvider">

</telerik:GridBoundColumn>--

 

 

%>

 

<telerik:GridDropDownColumn UniqueName="ddlstWorkProvider" EditFormHeaderTextFormat="WorkProvider" EditFormColumnIndex="0" ListTextField="Name" ListValueField="Name" ListDataMember="Name" DropDownControlType="RadComboBox" DataField="Name" HeaderText="WorkProvider"></telerik:GridDropDownColumn>

 

<telerik:GridBoundColumn HeaderText="JobTaskContainingWord" EditFormHeaderTextFormat="JobTaskContainingWord" EditFormColumnIndex="1" DataField="JobTaskContainingWord" UniqueName="txtJobTaskContainingWord">

 

<ColumnValidationSettings EnableRequiredFieldValidation="true">

 

<RequiredFieldValidator ForeColor="Red" Text="*This field is required">

 

</RequiredFieldValidator>

 

</ColumnValidationSettings>

 

</telerik:GridBoundColumn>

 

<telerik:GridBoundColumn HeaderText="Percentage" EditFormHeaderTextFormat="Percentage" EditFormColumnIndex="1" UniqueName="txtPercentage" DataField="Percentage">

 

</telerik:GridBoundColumn>

 

<telerik:GridButtonColumn ConfirmText="Delete this setting?" ConfirmDialogType="RadWindow"

 

ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete"

 

UniqueName="DeleteColumn">

 

<ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle>

 

</telerik:GridButtonColumn>

 

</Columns>

 

<EditFormSettings ColumnNumber="2">

 

<FormTableItemStyle Wrap="false"></FormTableItemStyle>

 

<FormCaptionStyle CssClass="EditFormHeader"></FormCaptionStyle>

 

<FormMainTableStyle GridLines="None" CellSpacing="0" CellPadding="2" Width="100%"></FormMainTableStyle>

 

<FormTableStyle CellSpacing="0" CellPadding="2" Height="60px"></FormTableStyle>

 

<FormTableAlternatingItemStyle Wrap="False"></FormTableAlternatingItemStyle>

 

<EditColumn ButtonType="ImageButton" InsertText="Insert Order" UpdateText="Update record"

 

UniqueName="EditCommandColumn1" CancelText="Cancel edit">

 

</EditColumn>

 

<FormTableButtonRowStyle HorizontalAlign="Right" CssClass="EditFormButtonRow"></FormTableButtonRowStyle>

 

</EditFormSettings>

 

</MasterTableView>

 

<ClientSettings>

 

<ClientEvents OnRowDblClick="RowDblClick"></ClientEvents>

 

</ClientSettings>

 

</telerik:RadGrid>

and ItemDataBound is like this-

 

 

 

 

 

 

protected void grdAudotex_ItemDataBound(object sender, GridItemEventArgs e)

{

 

 

 

 

 

if (e.Item is GridEditableItem && e.Item.IsInEditMode)

{

 

 

 

 

 

GridEditableItem edititem = (GridEditableItem)e.Item;

 

 

 

 

 

GridEditManager editMan = edititem.EditManager;

 

 

 

 

 

GridDropDownListColumnEditor editor = (GridDropDownListColumnEditor)(editMan.GetColumnEditor("ddlstJobTask"));

 

 

 

 

 

RadComboBox rComboBox = editor.ComboBoxControl;

 

 

 

 

 

var LabourType = (from obj in dc.LABOURTYPEs

 

 

 

 

 

select new

{

obj.Id,

obj.LabourCode,

obj.LabourDescription

}).ToList();

rComboBox.DataSource = LabourType;

rComboBox.DataValueField =

 

 

 

 

 

"Id";

rComboBox.DataTextField =

 

 

 

 

 

"LabourDescription";

rComboBox.DataBind();

 

 

 

 

 

GridDropDownListColumnEditor EditorInternalJob = (GridDropDownListColumnEditor)(editMan.GetColumnEditor("ddlstDescription"));

 

 

 

 

 

RadComboBox cmbInternalJob = EditorInternalJob.ComboBoxControl;

 

 

 

 

 

var InterJobTask = (from objJob in dc.ESTIMATEJOBTYPEs

 

 

 

 

 

select new

{

objJob.JobTypeId,

objJob.JobCode,

objJob.Description

}).ToList();

cmbInternalJob.DataSource = InterJobTask;

cmbInternalJob.DataValueField =

 

 

 

 

 

"JobTypeId";

cmbInternalJob.DataTextField =

 

 

 

 

 

"Description";

cmbInternalJob.DataBind();

 

 

 

 

 

GridDropDownListColumnEditor EditorWorkProvider = (GridDropDownListColumnEditor)(editMan.GetColumnEditor("ddlstWorkProvider"));

 

 

 

 

 

RadComboBox cmbWorkprovider = EditorWorkProvider.ComboBoxControl;

 

 

 

 

 

var WorkProvider = (from objWork in dc.WORKPROVIDERs

 

 

 

 

 

select new

{

objWork.WorkProviderId,

objWork.Name,

}).ToList();

cmbWorkprovider.DataSource = WorkProvider;

cmbWorkprovider.DataValueField =

 

 

 

 

 

"WorkProviderId";

cmbWorkprovider.DataTextField =

 

 

 

 

 

"Name";

cmbWorkprovider.DataBind();

 

 

 

 

 

GridTextBoxColumnEditor EditorPercentage = (GridTextBoxColumnEditor)(editMan.GetColumnEditor("txtPercentage"));

 

 

 

 

 

TextBox txtPercentage1 = EditorPercentage.TextBoxControl;

 

 

 

 

 

GridTextBoxColumnEditor EditorContaingWord = (GridTextBoxColumnEditor)(editMan.GetColumnEditor("txtJobTaskContainingWord"));

 

 

 

 

 

TextBox txtcont = EditorContaingWord.TextBoxControl;

　

}

}

 

protected void grdAudotex_ItemDataBound(object sender, GridItemEventArgs e)

{

 

if (e.Item is GridEditableItem && e.Item.IsInEditMode)

{

 

GridEditableItem edititem = (GridEditableItem)e.Item;

 

GridEditManager editMan = edititem.EditManager;

 

GridDropDownListColumnEditor editor = (GridDropDownListColumnEditor)(editMan.GetColumnEditor("ddlstJobTask"));

 

RadComboBox rComboBox = editor.ComboBoxControl;

 

var LabourType = (from obj in dc.LABOURTYPEs

 

select new

{

obj.Id,

obj.LabourCode,

obj.LabourDescription

}).ToList();

rComboBox.DataSource = LabourType;

rComboBox.DataValueField =

 

"Id";

rComboBox.DataTextField =

 

"LabourDescription";

rComboBox.DataBind();

 

GridDropDownListColumnEditor EditorInternalJob = (GridDropDownListColumnEditor)(editMan.GetColumnEditor("ddlstDescription"));

 

RadComboBox cmbInternalJob = EditorInternalJob.ComboBoxControl;

 

var InterJobTask = (from objJob in dc.ESTIMATEJOBTYPEs

 

select new

{

objJob.JobTypeId,

objJob.JobCode,

objJob.Description

}).ToList();

cmbInternalJob.DataSource = InterJobTask;

cmbInternalJob.DataValueField =

 

"JobTypeId";

cmbInternalJob.DataTextField =

 

"Description";

cmbInternalJob.DataBind();

 

GridDropDownListColumnEditor EditorWorkProvider = (GridDropDownListColumnEditor)(editMan.GetColumnEditor("ddlstWorkProvider"));

 

RadComboBox cmbWorkprovider = EditorWorkProvider.ComboBoxControl;

 

var WorkProvider = (from objWork in dc.WORKPROVIDERs

 

select new

{

objWork.WorkProviderId,

objWork.Name,

}).ToList();

cmbWorkprovider.DataSource = WorkProvider;

cmbWorkprovider.DataValueField =

 

"WorkProviderId";

cmbWorkprovider.DataTextField =

 

"Name";

cmbWorkprovider.DataBind();

 

GridTextBoxColumnEditor EditorPercentage = (GridTextBoxColumnEditor)(editMan.GetColumnEditor("txtPercentage"));

 

TextBox txtPercentage1 = EditorPercentage.TextBoxControl;

 

GridTextBoxColumnEditor EditorContaingWord = (GridTextBoxColumnEditor)(editMan.GetColumnEditor("txtJobTaskContainingWord"));

 

TextBox txtcont = EditorContaingWord.TextBoxControl;

　

}

}

Hi please suggest me .

I am trying to display things under tabs with radtabstrip.However, the radtabs are not displaying the data they are supposed to display under tabs. Can some one help me with this?

<telerik:RadTabStrip ID="RadTabStrip1" runat="server">
    <Tabs>
       <telerik:RadTab Text="Tab 1" PageViewID="RadPageView1">
        </telerik:RadTab>
        <telerik:RadTab Text="Tab 2" PageViewID="RadPageView2" >
        </telerik:RadTab>
    </Tabs>
    </telerik:RadTabStrip>
    <telerik:RadMultiPage ID="RadMultiPage1" runat="server">
        <telerik:RadPageView ID="RadPageView1" runat="server" >
            <p> Hi</p></telerik:RadPageView>
        <telerik:RadPageView ID="RadPageView2" runat="server" Width="100%">

            PageView 2</telerik:RadPageView>
    </telerik:RadMultiPage>

Thanks.

I have java script code that searches the itunes appstore based off of the text entered into the autocomplete box. I want to manage all the autcomplete entries manually through javascript. My problem is that the asp.net runtime runs into a null object reference error when it tries to look for my data source. This may be because the json query to the appstore take a second or two so the entries to the the autocomplete box come in a little late. Is there any way around this error? Should I use a different telerik control? Thanks for the feedback.
 

Hello,

many of Telerik's controls have OnClientLoad event, but not RadHtmlChart. 
When I want to load data on the client side after the chart is loaded, I have to add another (invisible) control and attach load function to that control's OnClientLoad or find another workaround. Is there any particular reasons not having that event in RadHtmlChart?

Thanks

Hellow

How to set the radmenu orientation in javascript?

Thanks
Anly

Hellow

I am not adding an imageurl to radmenu items. But there is some space dedicated for rendering the menu icons. How can I trim these spaces?

Thanks
Anly

Hi!

I use Treelist (AllowLoadOnDemand = "True") if I know where there are no nested elements, how do I specify that they do not need to draw?

Hello.

When I expand the icon for a set of standards, leave the results expanded, and then do a second standard search for a different standard the results are already partially expanded which are supposed to be not expanded as noted in attached pictures.

in code-hind

        /// <summary>
        /// Handler for the Search Button
        /// </summary>
        protected void SearchHandler(object sender, CriteriaController criteriaController)
        {
            if (radTreeResults.Visible)
            {
                if (DtGrid == null) DoSearch();

//DataView dv = new DataView(DtGrid, "ParentID is null", "", DataViewRowState.CurrentRows);                
                //radTreeResults.DataSource = dv;
                radTreeResults.DataSource = DtGrid;
                radTreeResults.DataBind();
            } 
            else
                radTreeResults.Visible = true;
        }
        
        protected void TreeListDataSourceNeeded(object sender, EventArgs e)
        {
            if (DtGrid == null) DoSearch(); 
            radTreeResults.DataSource = DtGrid;
        }
        protected void radTreeResults_ItemDataBound(object sender, TreeListItemDataBoundEventArgs e)
        {
            if (e.Item is TreeListDataItem)
            {
                TreeListDataItem item = e.Item as TreeListDataItem;
                item.FindControl("lnkExpandAll").Visible = item.CanExpand;
                item.FindControl("lnkCollapseAll").Visible = item.CanExpand;
                if (item.Expanded)
                {
                    item.FindControl("lnkCollapseAll").Visible = item.Expanded;
                    item.FindControl("lnkExpandAll").Visible = false;
                }
            }
        }     

        protected void radTreeResults_ItemCommand(object sender, TreeListCommandEventArgs e)
        {
            if (e.CommandName == RadTreeList.ExpandCollapseCommandName)
            {
                if ((e.Item as TreeListDataItem).HierarchyIndex.NestedLevel == 0 && e.CommandArgument.ToString() == "ExpandAll")
                {
                    e.Canceled = true;
                    if (!(e.Item as TreeListDataItem).Expanded)
                    {
                        radTreeResults.ExpandItemToLevel((e.Item as TreeListDataItem), 10);
                    }
                    else
                    {
                        radTreeResults.CollapseAllItems();
                    }
                }
            }
        }

in .aspx

 <telerik:RadTreeList ID="radTreeResults" runat="server" ParentDataKeyNames="ParentID" Visible="False"
            DataKeyNames="StandardID" Skin="Office2010Silver"  Width="100%" Height="100%"
            AutoGenerateColumns="False" OnNeedDataSource="TreeListDataSourceNeeded" 
            OnItemCommand="radTreeResults_ItemCommand" OnItemDataBound="radTreeResults_ItemDataBound" ShowTreeLines="false">
            <ClientSettings Scrolling-AllowScroll="true" Scrolling-UseStaticHeaders="true">
                <Resizing ResizeMode="AllowScroll" AllowColumnResize="true" EnableRealTimeResize="true" />
                <Scrolling AllowScroll="true" UseStaticHeaders="true" SaveScrollPosition="true" ScrollHeight="560px" />
                <ClientEvents OnTreeListCreated="TreeListCreated" />
            </ClientSettings>
            <Columns>
                <telerik:TreeListSelectColumn HeaderStyle-Width="40px" UniqueName="SelectColumn">
                </telerik:TreeListSelectColumn>
                <telerik:TreeListTemplateColumn HeaderStyle-Width="120px" DataField="NameDisplayText"
                    UniqueName="NameDisplayText" HeaderText="Name" >
                    <ItemTemplate>
                        <asp:LinkButton ID="lnkExpandAll" runat="server" CommandName="ExpandCollapse"
                            CommandArgument="ExpandAll" Text="+" Visible="true"></asp:LinkButton>
                        <asp:LinkButton ID="lnkCollapseAll" runat="server" CommandName="ExpandCollapse"
                            CommandArgument="CollapseAll" Text="-" Visible="false"></asp:LinkButton>
                        <asp:HyperLink ID="lnkStandardName" runat="server" Target="_blank" NavigateUrl='<%#"~/Record/StandardsPage.aspx?xID=" + Eval("EncryptedID") %>'
                            Visible="True" Style="color: Blue;" StandardID='<%# Eval("EncryptedID") %>' StandardName='<%# Eval("StandardName") %>' ><%# Eval("NameDisplayText")%></asp:HyperLink>                        
                    </ItemTemplate>
                </telerik:TreeListTemplateColumn>
                <telerik:TreeListBoundColumn HeaderStyle-Width="300px" DataField="StandardText" UniqueName="StandardText"
                    HeaderText="Text" />
                <telerik:TreeListBoundColumn HeaderStyle-Width="45px" DataField="Grade" UniqueName="Grade"
                    HeaderText="Grade" />
                <telerik:TreeListBoundColumn HeaderStyle-Width="100px" DataField="Subject" UniqueName="Subject"
                    HeaderText="Subject" />
                <telerik:TreeListBoundColumn HeaderStyle-Width="100px" DataField="Course" UniqueName="Course"
                    HeaderText="Course" />
                <telerik:TreeListBoundColumn HeaderStyle-Width="100px" DataField="Level" UniqueName="Level"
                    HeaderText="Level" />
                <telerik:TreeListBoundColumn HeaderStyle-Width="50px" DataField="ItemCount" UniqueName="ItemCount"
                    HeaderText="Items" />
                <telerik:TreeListBoundColumn HeaderStyle-Width="75px" DataField="ResourceCount" UniqueName="ResourceCount"
                    HeaderText="Resources" />
            </Columns>
        </telerik:RadTreeList>

I'm trying to bind date column to RadGrid with auto generated columns. binding works fine but the filter options (contains, equal,..) does not showing up when i click on the filter icon, it just cause a post back. How ever if i bind the date column as a string then it's starts working. whats the issue here?

 <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

        <script type="text/javascript">
        

            function doFilter(sender, eventArgs) {
                if (eventArgs.keyCode == 13) {
                    eventArgs.cancelBubble = true;
                    eventArgs.returnValue = false;
                    if (eventArgs.stopPropagation) {
                        eventArgs.stopPropagation();
                        eventArgs.preventDefault();
                    }
                    var masterTableView = $find("<%= gridSearchL3.ClientID %>").get_masterTableView();
                    var index = sender.parentNode.cellIndex; //index of the current column 
                    var columns = masterTableView.get_columns();
                    var uniqueName = columns[index].get_uniqueName();
                    masterTableView.filter(uniqueName, sender.value, Telerik.Web.UI.GridFilterFunction.Contains);
                }
            }

            
        var columnUniquName = ""; 

            function removeCssClass(className, element) {
                element.className = element.className.replace(className, "").replace(/^\s+/, '').replace(/\s+$/, '');
            }

            function addCssClass(className, element) {
                if (element.className.indexOf(className) < 0) {
                    element.className = element.className + " " + className;
                }
            }
            function onRowClick(sender, eventArgs) {
                var radGrid = sender;
                var index = eventArgs.get_itemIndexHierarchical();
                var dataItem = radGrid.get_masterTableView().get_dataItems()[index];
                var row = dataItem.get_element();
                var checkBox = row.children[0].children[0];
                if (!checkBox.checked) {
                    checkBox.checked = true;
                    addCssClass("rgSelectedRow", row);
                }
                else {
                    checkBox.checked = false;
                    removeCssClass("rgSelectedRow", row);
                }

                CheckHeaderCheckBoxIfNeeded(radGrid);
            }

            function changeAllowPaging() {
                var grid = $find("<%= gridSearchL3.ClientID %>");
                var pagerRow = grid.get_masterTableView().get_element().tFoot;
                pagerRow.style.display = "none";
                grid.MasterTableView.set_pageSize(grid.MasterTableView.PageSize * grid.MasterTableView.PageCount)
                return false;

            } 

            function CheckHeaderCheckBoxIfNeeded(radGrid) {
               
                var checkHeaderCheckBox = true;
                var dataItems = radGrid.get_masterTableView().get_dataItems();
              
                for (var i = 0; i < dataItems.length; i++) {
                    var dataItem = dataItems[i];
                    var row = dataItem.get_element();
                    var ckeckBox = row.children[0].children[0];
                    if (!ckeckBox.checked) {
                        checkHeaderCheckBox = false;
                    }
                }

                SelectCheckBox(checkHeaderCheckBox);
            }

            function setSelectedAfterPostback(rowIDs, rowCount) {
                var arrRowIDs = rowIDs.split(",");
                for (var i = 0; i < arrRowIDs.length - 1; i++) {
                    var row = document.getElementById(arrRowIDs[i]);
                    var checkBox = row.children[0].children[0];
                    checkBox.checked = true;
                    addCssClass("rgSelectedRow", row);
                }
                if (rowCount == arrRowIDs.length - 1) {
                    SelectCheckBox(true);
                }
            }

            function CheckBoxCheckedOnClient(rowID, chechBoxId) {
                var row = document.getElementById(rowID);
                var ckeckBox = document.getElementById(chechBoxId);
                if (ckeckBox.checked) {
                    addCssClass("rgSelectedRow", row);
                }
                else {
                    removeCssClass("rgSelectedRow", row);
                }
                var radGrid = $find("<%= gridSearchL3.ClientID %>");
                CheckHeaderCheckBoxIfNeeded(radGrid);
            }

            function SelectCheckBox(isChecked) {
                var checkBoxID = document.getElementById("<%= HiddenField.ClientID %>").value;
                var checkBox = document.getElementById(checkBoxID);
                checkBox.checked = isChecked;
            }

            function CheckUnCheckAll(id) {
                var sender = document.getElementById(id);
                var grid = $find("<%=gridSearchL3.ClientID %>");
                var dataItems = grid.get_masterTableView().get_dataItems();
                for (var i = 0; i < dataItems.length; i++) {
                    var dataItem = dataItems[i];
                    var row = dataItem.get_element();
                    var checkBox = row.children[0].children[0];
                    if (sender.checked) {
                        checkBox.checked = true;
                        addCssClass("rgSelectedRow", row);
                    }
                    else {
                        checkBox.checked = false;
                        removeCssClass("rgSelectedRow", row);
                    }
                }
            }

               function getColumnCliecked(cu) {  
                columnUniquName = cu;  
                
    }  

            function getPDF(docNum, rev,dochTID) {

                WebService.getFilePath(docNum, rev,dochTID, OnPDFSucceed, OnPDFFailed);
            }

            function OnPDFSucceed(result) {
                //alert(result);
                openPDF(result);
            }

            function OnPDFFailed(err) {
                alert(err);
            }

            function openPDF(file) {
                window.open("OpenPDF.aspx?File=" + file);
            }

            
        </script>

    </telerik:RadCodeBlock>

<telerik:RadGrid ID="gridSearchL3" runat="server" AllowPagg="True"  
             GridLines="None" Skin="Office2007" Height="415px" 
             OnExcelMLExportRowCreated="gridSearchL3_ExcelMLExportRowCreated" OnExcelMLExportStylesCreated="gridSearchL3_ExcelMLExportStylesCreated"
            OnGridExporting="gridSearchL3_GridExporting"  oninit="gridSearchL3_Init" OnNeedDataSource="RadGrid1_NeedDataSource"
            Font-Names="Eras Medium ITC" Font-Size="Small" PageSize="50" 
             AllowFilteringByColumn="True" onitemcreated="gridSearchL3_ItemCreated" 
            OnPageIndexChanged="gridSearchL3_PageIndexChanged"
          OnPageSizeChanged="gridSearchL3_PageSizeChanged"
             onselectedindexchanged="gridSearchL3_SelectedIndexChanged" 

             AllowSorting="True" ShowStatusBar="True" AllowPaging="True" CellSpacing="0" oncolumncreated="gridSearchL3_ColumnCreated1" 
                >
               <FilterItemStyle Font-Names="Eras Medium ITC" Font-Size="XX-Small" />
               <GroupingSettings CaseSensitive="False" />
            <ExportSettings Excel-Format="ExcelML" ExportOnlyData="True" 
                FileName="PinC Group" IgnorePaging="True" OpenInNewWindow="True">
                <Excel Format="ExcelML" />
            </ExportSettings>
            <ClientSettings>
                <ClientEvents OnRowClick="onRowClick" OnRowSelected="RowSelected" />
                <Selecting AllowRowSelect="True" />
                <Scrolling AllowScroll="True" UseStaticHeaders="True" />
                    
            </ClientSettings>
            <AlternatingItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <GroupHeaderItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <SortingSettings EnableSkinSortStyles="false" /> 
            <MasterTableView ClientDataKeyNames="Document #,Revision,hID,ID" Font-Names="Eras Medium ITC" 
                   Font-Size="X-Small">
           
                <CommandItemSettings  ExportToPdfText="Export to Pdf" />
                 
                <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
                </RowIndicatorColumn>
                <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
                </ExpandCollapseColumn>
                <Columns>
                    <telerik:GridTemplateColumn AllowFiltering="false" UniqueName="template">
                        <ItemTemplate>
                            <asp:CheckBox ID="CheckBox1" runat="server" AutoPostBack="true" 
                                OnCheckedChanged="ToggleRowSelection" />
                        </ItemTemplate>
                        <HeaderTemplate>
                            <asp:CheckBox ID="CheckBoxHeader" runat="server" AutoPostBack="true" 
                                OnCheckedChanged="Header_checkedChange" />
                        </HeaderTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridButtonColumn CommandName="Select" Text="View" 
                        UniqueName="LinkColumn">
                    </telerik:GridButtonColumn>
                   </Columns>
                <EditFormSettings>
                    <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                    </EditColumn>
                </EditFormSettings>
                <ItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
                <PagerStyle Mode="NextPrevNumericAndAdvanced" />
                <FilterItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            </MasterTableView>
            <EditItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <FooterStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <HeaderStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <FilterItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <CommandItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <ActiveItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <ItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <PagerStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" 
                   HorizontalAlign="Left" Mode="NextPrevNumericAndAdvanced" />
               <SelectedItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <FilterMenu Font-Names="Eras Medium ITC" Font-Size="X-Small" 
                Skin="Office2007" EnableRoundedCorners="True">
               </FilterMenu>
               <HeaderContextMenu Font-Names="Eras Medium ITC" Font-Size="X-Small" 
                   Skin="Simple">
               </HeaderContextMenu>
               </telerik:RadGrid>

My SQL Query.

select distinct h.DocumentRevisionID 'ID',h.DocumentHeaderID 'hID', h.DocumentNumber 'Document #', h.DocumentTitle 'Document Title',h.Revision as 'Revision',CASE CONVERT(date,[RevisionDate],103)  WHEN '01/01/1991' Then '' else CONVERT(date,[RevisionDate],103) end as 'Rev Date'   from tblDocumentHeader h