| TID | 2015 ( s2015 ) |
| QuickLink | http://www.stone-ware.com/swql.jsp?kb=s2015 |
| Category | Report Services |
| Summary | Conditional output |
| Details | Can you do conditional formatting on rows? I would like to do either alternating row background color or background color based on the value of a field for that row.
Also, can you do conditional sums? For example, I might want to do two sums at the bottom based on a field in a row being true/false |
| Resolution | 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. |
