Interview Questions   Tutorials   Discussions   Programs   

Cognos - What is applying colors to alternate rows in a list report?

asked mar September 30, 2014 01:00 PM  

What is applying colors to alternate rows in a list report?


1 Answers

answered By vishnoiprem   0  

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.

   add comment

Your answer

Join with account you already have



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!