SSRS Report Display Matrix Report (Crosstab) Headings from Related Table

How do you display Headings in your SSRS report crosstab form from a related table? The crosstab column has the code for the classifcation 1, 2, 3, 4, 5, 6, 7 , 9. It needs to display the description from the classification description table linked on the classification column. Image of report and table attached. Also how do you add a grand total on reports. The report wizard puts the total on the top of the report.

## Deliverables

1) Answer to question with working example

## Platform

Sql Server 2005

SSRS

Visual Studio 2005

.NET ASP C# -ohjelmointi tekniikka MySQL PHP Tietojärjestelmäarkkitehtuuri Ohjelmistojen testaus SQL

Projektin tunnus: #3370314

Tietoa projektista