I have a couple of questions regarding XPages and some Client Side JavaScript I'd like to write, but I am having some issues.

 

If I am using a View Control or a Repeat Control and I am returning a dollar amount, lets call it total budget. Is there a way to add a computed field after the view control that will loop through all the documents in the view and perform a calculation so I can pull total budget and average budget amounts. Currently I have only had luck with redoing the search and then looping through the documents. This is takes too much time since I basically have to run the search over again, for each column I want to total. Just seems like there should be an easy way, to grab the view column and total it.

 

This may be a little more complex, but sort of basing it off the same concept as above. I have a SQL connection that runs a stored procedure. Currently I am using a repeat control and I am populating some information from Domino and would like to populate some from the SQL information. I am running a stored procedure and its returning values that look like this: value1^value2^value3^value4

I can access that information just fine, until I make that computed field not visible. Is there a way to make that data for each row of the repeat control accessible? I would hate to have to run SQL for each value for each row, seems excessive.

For instance, repeat control brings back 20 people. I would like to run the SQL 1x per row, then parse that data. As opposed to running it 4x per row.

 

Thanks for any help. Please let me know if you have any questions.

Thanks.