Sunday, July 1, 2012

How to make a crosstab look like a list (crosstab with column headers)


Requirement

It is requested to turn crosstab with traditional layout into crosstab with column headers. Please see screenshot below

Please download the report specification from detail review


Implementation in detail

Step 1: Drag Crosstab to Crosstab report after header

Step 2: Drag Crosstab to Crosstab the left of the first crosstab space

Step 3: unlock cell and make text item for titles

Step 4: Highlight cells and make define contents as Yes

Step 5: Drag query item Year into cell

Step 5: Select the first row, or original header and define box Type as None

Step 6: Decorate the newly define header as below

2 comments:

  1. nice post very helpful

    ReplyDelete
  2. This is great! Now how do you add columns in the crosstab after you "hide" or not render the column headers?

    ReplyDelete