Hiding Rows based on cell values

5 posts, 0 answers
  1. Tayonee
    Tayonee avatar
    52 posts
    Member since:
    Nov 2006

    Posted 18 Jun 2014 Link to this post

    I can't seem to find any relevant discussions on this topic, but I am wondering if it is possible to hide rows in the generated output (for example highlighted in yellow in the attached file) if certain conditions are met. For example, if one or the other of the values in the column labeled "Difference" is negative, I would want to hide the highlighted row.

    Is this possible?
  2. Eyup
    Admin
    Eyup avatar
    3005 posts

    Posted 23 Jun 2014 Link to this post

    Hello Tayonee,

    Generally, you can check the sample provided in the following blog for accessing and modifying the color of the cells, the content of which matches some condition:
    http://blogs.telerik.com/blogs/13-12-03/aspnet-pivot-table-made-easy

    However, hiding them may break the pivot grid layout. You can send us sample screenshots or video demonstrating the desired behavior.

    Regards,
    Eyup
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Tayonee
    Tayonee avatar
    52 posts
    Member since:
    Nov 2006

    Posted 24 Jun 2014 in reply to Eyup Link to this post

    Hi Eyup,

    Thanks for the reply. I have managed to get the formatting to work as intended, but, as you say, I just don't see a way to hide entire rows from the output because maybe it would break things. Just to clarify, I have added a screenshot here which shows what I am talking about. 

    What I am trying to accomplish is that all rows that have a 0 for the "Difference", either in "Total Hours" or "Service Count" shold not display the row. In fact, I have the colorization working the extent that in the attached screesnot, the only rows that should be showing would be the ones colored red or green.

    I am just trying to figure out any way to accomplish this.

    Thanks,
    Mike
  5. Eyup
    Admin
    Eyup avatar
    3005 posts

    Posted 27 Jun 2014 Link to this post

    Hello Mike,

    I will forward this query to our developers whether this requirement is achievable in some basic scenarios. I will let you know about the result when I get a response.

    Regards,
    Eyup
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  6. Eyup
    Admin
    Eyup avatar
    3005 posts

    Posted 02 Jul 2014 Link to this post

    Hello Mike,

    Thank you for your patience, however, I am afraid the reply of the dev team is negative and this requirement is not supported since it may break the pivot grid layout as mentioned. There can be many scenarios and this requirement diverges with the main idea of the control to calculate and present all of the data in meaningful manner.

    Please let us know if new questions arise.

    Regards,
    Eyup
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017