In this Example we will use the Strategy Tutorial Project using a Time Dimension Attribute going across along with the metrics where any other non-Time dimension attribute going vertically, without repeating Attribute values.
The goal is to get the below Grid result in a Report Services Document:
The requirement can achieved using conditional formatting on the Report Services Document.
Example:
Created a Report Service Document in Strategy Tutorial as shown below:
Before the conditional formatting is applied, it will look like this when executed. The year attribute repeats for every region.
Created a conditional formatting on the year textbox to Hide the year textbox when the region is not the first element.
Run the document, the year will not repeat for every region. It only shows up once for the first element of region as shown below:
