Conditional Output
Conditional Output
Conditional Formatting on Rows
You can use our row choose.. right click on the table row to see it to do alternating colors. If you want conditional formatting based on values, you can use the JavaScript block (drag it down from the menu at the top) and do it with a little scripting, or you can design your query using functions to output a field that has the color.. then set the bgcolor equal to that @@db:fieldname@@ variable.
Conditional Sums
Same types of tricks work.. scripting is an option to maintain counters yourselves, however, most people prefer massaging the query with functions. So use some logic in the query to say " if some field = true then output the numeric field that will be added, else output 0". Then do a sum on that field in the report. That way, no scripting is required.