: 4582 | 108638 | 12353

View Column Total - Option to Remove Grand Total 
New idea submissions, commenting and voting are no longer available on this site. Logins have also been disabled.
Use this IdeaSpace to post ideas about Domino Designer.

: 40
: 41
: 1
: Domino Designer
: designer, view, column, totals
: Conrad Senn235 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 Lewin412 (07 Dec 2007)
this is also a problem when reader fields are used. The docs are hidden, but not the totals
2) Paul Davies12381 (07 Dec 2007)
agreed - simply for Barry's comment above
3) Vit Zachodil43 (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 >>

Use more customization features in ND9 NotesMail
Two-week Calendar view
@Formula library
Drafts - unsent count?
New Hide-When property
Activity Logging for Quickr
"follow-up complete" flag
Remake Resource Reservation template using XPage
Boolean operators on LDAP group based access control
Store IP Address / remote host data in Password Lockout documents
Checking Out-Of-Office status of others
Tool to show unreferenced design elements for easy cleaup
Bring sametime audio and video into the web browser using WebRTC
"Window Title" for views
QuickR application/widgets for Android/iPhone
Create Computed Text with the same text style as the current paragraph
@Function and LotusScript to "View..Customize This View" dialog
Extend the 'User detail' info of a database
Print of calendar in color
Shared Actions belong under Shared Elements
Facelift all web enabled templates with xPages
Please extend WebDAV to include calDAV & cardDAV support for contacts/calendar syncing
Skin-ing Notes Design elemens
Add some views into the "Views" section of the Notes 8.5 mailbox

IdeaJam developed by

Elguji Software Logo