tags:

views:

113

answers:

0

Hi,

I am using telerik radgrid in my project. I have empty spaces on my column names. When I am trying to do groupby I am getting error. Is there any way that i can groupby column names even if i have spaces in column names. I cant change the column names in sql server. I am calling storeproc so i cant even change the query in program. And I am not using mastertableview. I am directly binding the columns to the radgrid.

Please let me know if there is any solution. Here is My radgrid.

<telerik:RadGrid ID="gvTrackers" Height="550px" runat="server" CallbackMode="true" 
        Serialize="true" FolderStyle="styles/style_11" AllowPaging="true" AllowSorting="True" 
        GridLines="None" AutoGenerateColumns="true" ShowGroupPanel="True" EnableHeaderContextMenu="true" 
        EnableHeaderContextFilterMenu="true" AllowMultiRowSelection="true" AllowFilteringByColumn="True" 
        OnNeedDataSource="gvTrackers_NeedDataSource" OnItemCreated="gvTrackers_ItemCreated" 
        OnExcelMLExportStylesCreated="gvTrackers_ExcelMLExportStylesCreated" OnExcelMLExportRowCreated="gvTrackers_ExcelMLExportRowCreated" 
        OnItemCommand="gvTrackers_ItemCommand"> 
        <HeaderStyle Height="80px" BackColor="#004000" Font-Size="8pt" Font-Bold="True" ForeColor="White" 
            HorizontalAlign="Center" BorderColor="White" BorderWidth="0px" /> 
        <ExportSettings IgnorePaging="true" ExportOnlyData="true"> 
        <Pdf AllowModify="false" AllowPrinting="true" PageWidth="16in" /> 
        </ExportSettings> 
        <MasterTableView AllowMultiColumnSorting="true" CommandItemDisplay="Top"> 
            <CommandItemSettings ShowExportToWordButton="true" ShowExportToExcelButton="true" 
                ShowExportToCsvButton="true" ShowExportToPdfButton="true" ShowAddNewRecordButton="false" /> 
        </MasterTableView> 
        <ClientSettings ReorderColumnsOnClient="True" AllowDragToGroup="True" AllowColumnsReorder="True"> 
            <Scrolling AllowScroll="true" UseStaticHeaders="true" /> 
            <Selecting AllowRowSelect="True"></Selecting> 
            <Resizing AllowRowResize="True" AllowColumnResize="True" EnableRealTimeResize="True" 
                ResizeGridOnColumnResize="False"></Resizing> 
        </ClientSettings> 
        <GroupingSettings ShowUnGroupButton="true" /> 
        <PagerStyle Mode="NextPrevAndNumeric" HorizontalAlign="Right" Font-Bold="true" AlwaysVisible="true" /> 
    </telerik:RadGrid> 

One more question. Is there anyway that i can get print option to the radgrid. Like if press print button it should the all columns from the radgrid directly without exporting to any format file. Is there any option in radgrid.

Thanks

Prasad