Reporting Services is a great tool for reporting on hierarchial data. This hierarchial data will form the foundation of our data architecture for the report. It is very important that we structure our dataset (that our report will consume) in a manner that satisfies our business requirement as well as...