• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • Last Modified:

Reporting services - report field headings required

Hi, I'm using SQL 2005 Reporting Services and I've created a matrix report. I just have an issue with the formatting - I can't seem to be able to find how to add row or column text labels (text field headings) to the report. Please could someone assist. Thanks!
0
avdvyver
Asked:
avdvyver
1 Solution
 
Megan BrooksSQL Server ConsultantCommented:
When you add a matrix data region to the report, you should initially see a matrix with a data cell that reads "Data," a row group that reads "Rows" on the left, and a column group that reads "Columns" on the top. There is also an empty text box to the upper left of the data cell. Row and column groups are how you specify text boxes that are filled with data related to rows or columns of the matrix.

You can edit a row or column group by right-clicking within the group's text box and selecting "Edit group..." You can also select "Insert group" from the context menu to add another column or row, which I think is what you want to do. There are other places you can do this as well--right click in different places and you will see.

You can view and organize all of the row and column groups by right-clicking in the right place and selecting Properites and then the Groups tab. If the matrix is being displayed as a grid, you will need to right-click in the upper left hand corner cell. Otherwise you will need to right-click in the border rectangle.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now