This looks like a presentation requirement rather than a data requirement.

You could pull the whole of the table into Excel and use Pivot tables.

If you need to show details about each level (e.g. product name, price, description) then underneath details of the model (colour,size, etc) then a report in SSRS would be most appropriate but you would still pull a single dataset with the product data repeated for each model row. The presentation could be done just as easily in Crystal Reports, Access Reports, QlikView, Tableau or any number of other reporting packages.

As already stated XML would be a generic solution for this data if you need to make it portable.

Aaron