crosstab query + matrix control

[zerkat]

I am trying to create a cross tab query with the matrix control in sql reporting services 2005. I am using the below query to populate the matrix. I want the matrix to detail task hours by position. It is working but I don't know how to keep it from repeating the columns (i.e. positions) and it is not listing all the projects:

SELECT Employee.PositionName, Project.ProjectName, SUM(ProjectHours.HoursByProject)
FROM Employee
inner joins to necessary tables here
where clause
Group By Employee.PositionName, Project.ProjectName

Can any one help?

 

[zerkat]

Fixed it - it was my query.