View Column Total - Option to Remove Grand Total 
Use this IdeaSpace to post ideas about Domino Designer.

: 40
: 41
: 1
: Domino Designer
: designer, view, column, totals
: Conrad Senn230 06 Dec 2007
: / Email
I sometimes have the need to not see the grand totals on View Columns.  The client would much rather just see the Categorized totals.  Have a check box in designer in the column box where Totals are specified to show or not show grand total.

1) Barry Lewin1021 (07 Dec 2007)
this is also a problem when reader fields are used. The docs are hidden, but not the totals
2) Paul Davies13558 (07 Dec 2007)
agreed - simply for Barry's comment above
3) Vit Zachodil49 (28 Jan 2012)
There exists one solution since R6. It is posible to set the same colors for View background a for Column Totals. E.g.: If background of View is White and Column Totals is White and there is no color for Alternate rows in View properties, then all Totals values seems invisible.

Make copy of first Categorized Column, change the new 1-st sorted Column with Categories to Type "Standard" and hide it.
Add new hidden 2-nd column (standard not sorted) with foreground Color value, e.g.: (128:0:0).
The original Categorized column is now 3-rd without any changes.
Add 4-th hidden column with Color value: (-1:-1:-1) . This column ends previously color set in 2-nd column.

The color of Category and Column Total will be the same. Unfortunately, it is only a visual trick. The Totals stay there and are visible in Exports, Copy as Table, or printing on Black&White printers.


Welcome to IdeaJam

You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam™ works with:

  • IBM Connections
  • IBM Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.

Learn more about IdeaJam >>

IdeaJam developed by

Elguji Software Logo