For users of IBM Cognos Workspace Advanced (formerly Business Insight Advanced), a popular request is to have the ability to highlight every other row in a list report. This technique has been demonstrated with IBM Cognos Report Studio using the running-count() and mod() functions. The issue is that IBM Cognos Workspace Advanced does not expose all âfunctions that can be used in query calculations, so users think they are not available. This article will demonstrate how to highlight every other row using IBM Cognos Workspace Advanced by entering a ânon-exposed function in the expression editor (the twist!). In order to create the report, the following objects will be used: - List container - Running-count() function (not-exposed) - Mod() function (exposed) - List Columns Body Style ancestry - Conditional Styles - Query calculations Create the query calculation For this exercise, a query calculation will be created to display the numbers 0 or 1 on every other row. If the row has the number 1 on it, it will be filled with color. To accomplish this, the running-count() function will be used to get a sequential list of numbers. The mod() function will be used to divide the running count results by 2, which will result in calculations with a remainder of 0 or 1.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!