This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



~Fred Bretoopulobu
May 14, 2013, 11:05 AM
47 Posts
topic has been resolvedResolved

Column Totals

  • Category: Styles and Themes
  • Platform: Windows
  • Release: 8.5.3
  • Role: Developer
  • Tags: Color column totals
  • Replies: 2

I am looking for a way to put a different color for the totals in a view.


  

In the View properties of the Notes client, I selected the color in the "Column total text" in the Rows section of the style tab which will give me exactly what I want.


  

My XPage contains a layout which has a custom control. The custom control contains a regular view (not a Data view).  In this view, there is a column "Total" which contains a field from a document.

Each document is part of a specific category and there is a total for this category.  Here is the look I would like


  

Category     For         Date          Total

> Cat1                                         Total in color

                    User1     aDate        total

                    User2     aDate        total

>Cat2                                          Total in color  

                    User1     aDate        total

                       User2     aDate        total

I can choose a color in the properties for the View Column but I will set the color for all Total and that is not what I want.

Any idea?

~Naomi Dwojumilyakoi
May 14, 2013, 1:07 PM
110 Posts
Re: Column Totals
1. In the custom control, go to the All Properties of the viewpanel > look for 'data (var)' property > give it a value (say 'ventry')

2. Go to the All Properties of the 'total' column  > look for  'styling (style)' property > compute the following code into it:

if(ventry.isCategory()||ventry.isTotal())
    "color:rgb(0,0,255)";

I select (0,0,255) which is blue for example. Change to whatever color you want.  Also, I only test in Notes Client browser. Not sure if it'll work on others.
~Fred Bretoopulobu
May 14, 2013, 1:12 PM
47 Posts
Re: Column Totals
Thanks a lot, it working like a charm :-)

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal