Forum Post: RE: How can we total function in HTML report

  • Thread starter Thread starter Gian Torralba
  • Start date Start date
Status
Not open for further replies.
G

Gian Torralba

Guest
Hi Sudhakar, You can summarize the columns using EVAL blocks. Please refer to Chapter 6 page 160 of Rollbase in Action on how to use EVAL blocks. You can achieve this by creating/converting your fields to an expression field and then using the EVAL block to return the SUM of that column field. Formula fields cannot be used in queries so you need to convert it to an expression field. #EVAL[rbv_api.selectNumber("SELECT SUM(expression_field_col) FROM object");] //This will be inside the td element in the report Thanks, Gian

Continue reading...
 
Status
Not open for further replies.
Back
Top