A hidden gem in XML – row level formatting
As you now know, a Cognos report is an XML definition. When you create or update a report in Report Studio, the corresponding XML tags are added to or modified in the report specification. However, it is possible to directly add or modify XML tags that are not visible from the Studio as an object or property.
In this recipe, we will see how to define crosstab row level formatting in the XML to reduce development and maintenance time.
Assume that there is a crosstab report with many measures on columns. The business wants to highlight the rows that belong to costly products (>25 units). Instead of defining conditional formatting for every column, we will modify the XML here to directly define row level formatting.
Getting ready
Create a report with product name on rows and various measures on columns, shown as follows:
How to do it...
In this recipe, we will see how to define crosstab row level formatting in the XML, which can save a lot of time during...