Is it possible to create a letter type report within SSRS?
yes it is possible. You can add company header date time and all the good things you want. You can have company letter head as a jpg or some sort of image etc.
Great! This will be great because I need to create a matrix table (pivot like) and this will be awesome! It is starting to look like it will work.