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?
Is this possible?
4 Answers, 1 is accepted
0
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
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.
0
Tayonee
Top achievements
Rank 1
answered on 24 Jun 2014, 06:43 PM
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
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
0
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
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.
0
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
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.