add header title to the groups in Microsoft reporting

Question

I am very new to Microsoft reporting. I have a table and I need to show the Category Name and the count how many times the category existed in the report so for e.g, I have the following:

CategoryName    Id

Normal          1
High            2
Normal          3
Low             4
Normal          5
Normal          6
Normal          7
Normal          8
Low             9
Low             10
Low             11
High            12

I want to display something like this:

Category   Count

    Normal  6
    Low     4
    High    2

I was able to display the category ( Normal, Low and High) and the associated count with the category. The problem is, I cannot put the title "Category" and "count" at the top because I put the CategoryName and count in the header column and I deleted the data column like I showed in the image below. How can I put the title in the above table.

The image after adding the group filed looks like this:

any help will be greatly appreciated.

Answer 1

Your Problem: Category and Count as Title of your Tablix.

It's pretty easy. Just go to you Header Click on Cell where you wish to put Category. You can write Category just like a TextBox