I’ve been stuck in R5.06A land since the release of 5.07…I was hoping this issue would be fixed in R6, but it hasn’t (see below). Does anyone know of a workaround ??? UHG…
My post from Sept 2001…
http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/cfafb9136b42865685256acb005696a1?OpenDocument
IRIS…PLEASE HELP: I can not believe that in 5.07 the “Don’t show categories with 0 documents” property has been changed to allow grand totals to display in a view on the web. I am unable to move to 5.07 now becuase my entire B2B application will “fall apart”. The B2B application relies heavily on databases with reader names and categories broken down by business unit. The fallout of this change will allow our external business partners to view not only their totals, but the overall totals of my company (which is unacceptable). Please, please, please re-think this change. I’m sure I’m not the only one who will be negatively affected by this release. Can this property be changed (or an additional property added) to give developers the choice of showing or hiding grand totals on the web. Is there any way for me to escalate this request? Will anyone else have a similiar problem? Please reply!!!
Subject: Hide Grand Totals On The Web with R6?
I’ve had a similar problem but found a work around (at least a work around that works for us).
Rather than the user open a view, they open (create in our case with SaveOptions = 0) a document with an embedded view showing only a single category. The category can be soft coded using a hidden field on the form above the embedded view and therefore can vary depending on who opens/creates the document.
Column totals do not display in embedded views, however, I’ve added a separate field under the embedded view that computes for display the totals for the selected category.
Ok so there is a performance hit as the field to display the totals computes much slower then opening a view with column totals, but if the number of documents in each category is small enough then @Sum(…@dblookup …) on the appropriate column is quick enough.
If you could potentially exceed the 64k limit on @dblookup then run a simple bit of script as the document opens to add up the totals in the selected category. Alternatively run an agent every hour that creates a profile document (or totals document) for each category in the view and look-up this document to display the totals.
We actually use a mixture of all these solutions depending on the particular requirement within the app.
Subject: Hide Grand Totals On The Web with R6?
I have made a Q&D solution to this problem.Instead of having the server hiding the grand total, I let the web client handle the problem!
I created a default view form: $$ViewTemplateDefault, containing an embedded view.
In the onLoad event on the form I call this JavaScript:
var myBody = document.getElementsByTagName(“body”).item(0);
var lastTable = myBody.getElementsByTagName(“table”).item(myBody.getElementsByTagName(“table”).length - 1);
var lastRow = lastTable.getElementsByTagName(“tr”).item(lastTable.getElementsByTagName(“tr”).length - 1);
lastRow.style.display = “none”;
This did the trick for me.
Good luck.