Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
118 views

I'm trying to fix up a page so that the RadGrid has working filters. This has been fine on other pages, but the presence of a GridBoundColumn with a join in the DataField, and a GridCalculatedColumn is making this difficult.

My findings:
 - Originally, EnableLinqExpressions ("ELE") was set to "false", but this meant that filtering didn't work
 - ELE = false and removing the Calculated field --> Filtering works
 - ELE = false and removing the Joined filed --> Filtering is broken
 - ELE = true --> I get a Telerik.Web.UI.ParseException: ')' or ',' expected. No clear column as the culprit, error seems derived from the GridyDynamicQueryable.Select()
 - ELE = true and removing Calculated field --> Filtering works
 - ELE = true and removing Joined field --> Filtering works

And my boiled-down code:

<telerik:RadGrid ID="rgdInvoices" runat="server" DataSourceID="ldsInvoices" AutoGenerateColumns="false"
    AllowFilteringByColumn="true" EnableLinqExpressions="true" ShowFooter="true">
        <MasterTableView DataKeyNames="InvoiceID" EditMode="InPlace">
            <Columns>
                <telerik:GridBoundColumn UniqueName="BookingName" DataField="WEB_Booking.JobName" HeaderText="Job Name"
                    AutoPostBackOnFilter="true" ShowFilterIcon="false" />
 
                <telerik:GridNumericColumn UniqueName="SubTotal" DataField="SubTotal" ReadOnly="true"
                    HeaderText="Sub Total" NumericType="Currency" FilterControlWidth="120px"
                    Aggregate="Sum" FooterAggregateFormatString="{0:c}" />
                 
                <telerik:GridCalculatedColumn UniqueName="GST" HeaderText="GST" DataType="System.Decimal"
                    DataFormatString="{0:c}" DataFields="SubTotal" Expression="{0}*0.1" Aggregate="Sum"
                    FooterAggregateFormatString="{0:c}" />
            </Columns>
        </MasterTableView>
    </telerik:RadGrid>

It seems to me that there's an error with the code of a filtering function when a Join and Calculated field are being used. I also don't want to have to denormalise my database, but if I can't find a resolution soon, I'll have to do that.



Pavlina
Telerik team
 answered on 06 Feb 2014
2 answers
107 views
HI Team,

Currently we are using telerik version 2013.Q3.11114 ( Q3 2013 SP1)

I need to export the PDF with landscape Orientation. can you please help to do it.

But you are mention in  Q3 2013 SP1 version  Release History,
there is one property named 'PageOrientation' is added to the PDF export in side the Redgrid.

but i never see the PageOrientation of PDF exporting in side Redgrird

Please find the attachment for better understand.

Please Do needful.

Thanks
Narendra
Patipati
Top achievements
Rank 1
 answered on 06 Feb 2014
1 answer
167 views
Hello ,

We are facing few issues with RadEditor.
 

We are facing 3 issues with some RadEditor tools
 marked in Image # 1.

 Steps to produce alignment Issue:(other two marked
issues are direct issues)

1)Select some text in RadEditor having back ground color Image # 2

2)Make selected text as center align(Click on center
alignment tool), then the background color become white. This is our issue.

Issue persist in chrome and safari browsers only. (Image # 3)


 

Telerik Version we are using is : 2013.1.417.35

 

Please provide us some solution for this issue ASAP.

Ianko
Telerik team
 answered on 06 Feb 2014
3 answers
110 views
Hi,
How to handle preview event of editor,
In that event I want to perform replace some text coming from db.

thank you
Shinu
Top achievements
Rank 2
 answered on 06 Feb 2014
1 answer
65 views
I m trying to Bind DetailTable as per your demo example but unable to do that.
DetailTable is Expanding but does not show any data while datasource is available.



protected void RadGrid_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
    {
        if (!e.IsFromDetailTable)
        {
            try
            {
                DemomailViewings.DataSource = ViewingHelperX.GetViewingsForCurrentUser(UserID, DateStart, DateEnd, Session_ID);
            }
            catch (Exception ex)
            {
                // log error
            }        
        }
    }

    public void RadGrid_DetailTableDataBind(object source, Telerik.Web.UI.GridDetailTableDataBindEventArgs e)
    {      
        try
        {
            if (e.DetailTableView.Name == "GroupViewing")
            {
                GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;
                int ContactID = Convert.ToInt32(dataItem.GetDataKeyValue("ContactID"));
                e.DetailTableView.DataSource = ContactHelper.GetContacts(ContactID);
            }
        }
        catch (Exception ex)
        {
            // log error
        }        
    }





 <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
                <AjaxSettings>
                    <telerik:AjaxSetting AjaxControlID="RadGrid">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="RadGrid"></telerik:AjaxUpdatedControl>
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                </AjaxSettings>
            </telerik:RadAjaxManager>

               <telerik:RadGrid ID="RadGrid" runat="server" Width="95%" ShowHeadersWhenNoRecords="true"
                    ShowStatusBar="true" AutoGenerateColumns="False"
                    PageSize="50" AllowSorting="True" AllowMultiRowSelection="False" AllowPaging="True"
               
                OnDetailTableDataBind="RadGrid_DetailTableDataBind" OnNeedDataSource="RadGrid_NeedDataSource">
                    <PagerStyle Mode="NumericPages"></PagerStyle>
                    <MasterTableView Width="100%" DataKeyNames="ContactID" AllowSorting="True" HierarchyLoadMode="ServerOnDemand">
                    <DetailTables>
                            <telerik:GridTableView AutoGenerateColumns="false" runat="server" Name="GroupViewing" DataKeyNames="Id" AllowFilteringByColumn="false"
                             AllowSorting="false">
                                <ParentTableRelation>
                                    <telerik:GridRelationFields DetailKeyField="Id" MasterKeyField="ContactID" />
                                </ParentTableRelation>
                                <PagerStyle Visible="false" />
                                <Columns>
                                    <telerik:GridBoundColumn DataField="FirstName" HeaderText="First Name" />
                                    <telerik:GridBoundColumn DataField="AccountId" HeaderText="Company Name" />
                                    <telerik:GridBoundColumn DataField="Title" HeaderText="Title" />
                                    <telerik:GridBoundColumn DataField="Phone" HeaderText="Phone" />
                                </Columns>
                            </telerik:GridTableView>
                        </DetailTables>
                        <Columns>

                            <telerik:GridTemplateColumn SortExpression="InGroup" HeaderText="Group Viewing">
                                <ItemTemplate>
                                    <asp:Image ID="grpImage" runat="server" />
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <telerik:GridBoundColumn ShowSortIcon="true" SortExpression="FirstName" DataField="FirstName"
                                HeaderText="FirstName">
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn ShowSortIcon="true" SortExpression="LastName" DataField="LastName"
                                HeaderText="LastName">
                            </telerik:GridBoundColumn>
                            <telerik:GridTemplateColumn SortExpression="email" UniqueName="Email" HeaderText="Email">
                                <ItemTemplate>
                                    <a id="contactLink" style="cursor: pointer" runat="server"></a>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <telerik:GridBoundColumn ShowSortIcon="true" SortExpression="Title" AllowSorting="true"
                                DataField="Title" HeaderText="Title">
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="Phone" SortExpression="Phone" AllowSorting="true"
                                HeaderText="Phone">
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn ShowSortIcon="true" SortExpression="CompanyName" AllowSorting="true"
                                DataField="CompanyName" HeaderText="CompanyName">
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn ShowSortIcon="true" AllowSorting="true" DataField="SessionTitle"
                                SortExpression="title" HeaderText="Video Viewed">
                            </telerik:GridBoundColumn>
                            <telerik:GridDateTimeColumn ShowSortIcon="true" AllowSorting="true" SortExpression="SentDate"
                                DataFormatString="{0:MM/dd/yyyy}" DataField="SentDate" HeaderText="Sent Date">
                            </telerik:GridDateTimeColumn>
                            <telerik:GridDateTimeColumn ShowSortIcon="true" AllowSorting="true" SortExpression="ViewedDate"
                                DataFormatString="{0:MM/dd/yyyy}" DataField="ViewedDate" HeaderText="ViewedDate">
                            </telerik:GridDateTimeColumn>
                            <telerik:GridBoundColumn ShowSortIcon="true" AllowSorting="true" DataField="DurationText"
                                SortExpression="Duration" HeaderText="Duration">
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn ShowSortIcon="true" AllowSorting="true" SortExpression="location"
                                DataField="location" HeaderText="Location">
                            </telerik:GridBoundColumn>
                        </Columns>
                    </MasterTableView>

                </telerik:RadGrid>


Princy
Top achievements
Rank 2
 answered on 06 Feb 2014
6 answers
91 views
Sir,
 I have a grid , in in itemcreated event
i put the below code
this.rgVessel.MasterTableView.FilterExpression = "([SELECTED] = True' OR" + this.rgVessel.MasterTableView.FilterExpression;

but
([SELECTED] = True'  is not working , only the current filter is working.
but the filterexperssion contains the two column filter.
please help immediately.

by,

Seban
Seban
Top achievements
Rank 1
 answered on 06 Feb 2014
6 answers
2.1K+ views
Hi All,
I have a RadGrid like below.  While databinding it by using NeedDataSource event, the paging is not working . i.e results are displaying correctly on first load, but on clicking paging buttons,   radgrid binds again and no paging  nothing happens.
Please suggest .
  
Here is the complete code I am using.


HTML CODE
<telerik:RadGrid ID="PhaseView" PageSize="50" runat="server" Width="2000px"
       OnNeedDataSource="PhaseView_NeedDataSource"
       OnDataBound="PhaseView_DataBound" AllowCustomPaging="false"
       OnPageIndexChanged="PhaseView_PageIndexChanged"
                         AutoGenerateColumns="false" AllowPaging="true" AllowSorting="true" AllowFilteringByColumn="true"
                        GridLines="None" ShowGroupPanel="true"  
                        AllowMultiRowSelection="true"  >
                        <MasterTableView DataKeyNames="MessageID" IsFilterItemExpanded="False" GroupLoadMode="Client"
                            CommandItemDisplay="Top">
                            <CommandItemSettings ShowExportToCsvButton="true" ShowAddNewRecordButton="false"
                                ShowRefreshButton="false" ShowExportToExcelButton="true" />

                            <Columns>
                                <telerik:GridBoundColumn DataField="ProjectID" DataFormatString="{0:d}" HeaderText="Project ID"
                                    SortExpression="ProjectID" UniqueName="ProjectID">
                                </telerik:GridBoundColumn>
                                <telerik:GridHyperLinkColumn DataNavigateUrlFields="ProjectID" DataNavigateUrlFormatString="ProjectDetails.aspx?ProjectID={0}"
                                    DataTextField="ProjectName" DataType="System.String" HeaderText="Project Name"
                                    SortExpression="ProjectName" UniqueName="ProjectName">
                                </telerik:GridHyperLinkColumn>
                                <telerik:GridBoundColumn DataField="CustomerName" HeaderText="Customer Name" SortExpression="CustomerName"
                                    UniqueName="CustomerName">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="RegionName" HeaderText="Region" SortExpression="RegionName"
                                    UniqueName="RegionName">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="ProjectManagerName" HeaderText="Project Manager"
                                    SortExpression="ProjectManagerName" UniqueName="ProjectManagerName">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Phase Name" DataField="Phase" UniqueName="TagName"
                                    SortExpression="Phase">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="CreatedBy" DataField="CreatedBy" UniqueName="CreatedBy"
                                    SortExpression="CreatedBy">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="EmailCreatedDate" HeaderText="EmailCreatedDate"
                                    SortExpression="EmailCreatedDate" UniqueName="EmailCreatedDate">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="MessageSubject" HeaderText="MessageSubject" SortExpression="MessageSubject"
                                    UniqueName="MessageSubject">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="From" HeaderText="From" SortExpression="From"
                                    UniqueName="From">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TO" HeaderText="TO" SortExpression="TO">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="CC" DataField="CC" UniqueName="CC" SortExpression="CC">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </MasterTableView>
                        <ClientSettings AllowDragToGroup="True" AllowColumnHide="True" AllowRowHide="True"
                            AllowColumnsReorder="True" ReorderColumnsOnClient="True" ColumnsReorderMethod="Reorder">
                        </ClientSettings>
                        <HeaderContextMenu EnableAutoScroll="True">
                        </HeaderContextMenu>
                    </telerik:RadGrid>

.cs Code

 protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (Page.IsPostBack == false)
                {
                    loadgrid();
                }
            }
            catch (Exception ex)
            {
                BusinessLogic.Debug.InsertLogEntry(ex);
            }
            finally
            {
                AuthObj = null;
            }
        }



 protected void loadgrid()
        {
            Messages objMessage = new Messages();
            try
            {
                PhaseView.DataSource = objMessage.GetEmailReportData_New();  // this function returns a DataTable
                // PhaseView is the ID of RadGrid Control
                PhaseView.DataBind();
            }
            catch (Exception ex)
            {
                BusinessLogic.Debug.InsertLogEntry(ex);
            }
        }


 protected void PhaseView_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
        {
            Messages objMessage = new Messages();
            DataTable dt = new DataTable();
            try
            {
                    PhaseView.DataSource = objMessage.GetEmailReportData_New();       // this function returns a DataTable
            }
            catch (Exception ex)
            {
                BusinessLogic.Debug.InsertLogEntry(ex);
            }
            finally
            {
                objMessage = null;
            }
        }


 protected void PhaseView_PageIndexChanged(object sender, GridPageChangedEventArgs e)
        {  
            loadgrid();
        }

        protected void PhaseView_DataBound(object sender, EventArgs e)
        {

        }





Princy
Top achievements
Rank 2
 answered on 06 Feb 2014
3 answers
138 views
Hi,

When using the grid to input content through the edit form templates for example.
How are people validating the input against script attacks and such.

Cheers,

Jon
Princy
Top achievements
Rank 2
 answered on 06 Feb 2014
1 answer
254 views
I have a radgrid. inside the radgrid I have checkBox.

If I check or uncheck any checkbox in the grid  it it rasises checkbox checked event. I want to find out the row Id of that particular checkbox that is checked.How can I do that in vb.net?? 

I dont want to loop through all the items in the grid and find out what is checked, I just want the one that is checked or unchecked at that time.

Thank you.
Princy
Top achievements
Rank 2
 answered on 06 Feb 2014
2 answers
52 views
What the hell??? I updated my Telerik AJax ASP .Net tools and Reporting to the latest version today using the Telerik Control Panel and it totally wiped all the Telerik tools from my Visual Studio 2012! I have nothing now!!!

This is the second time this has happened to me with Telerik. I'm sick of this crap. Has anyone else experienced the same problem during upgrade?
Steve
Top achievements
Rank 1
 answered on 06 Feb 2014
Narrow your results
Selected tags
Tags
+? more
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?