I'm not sure whats the best way to achieve this, I'm developing a music store which will have a catalog of number of independent record labels releases. Typically an album(downloadable product) will belong to an artist, an artist will release under a record label. My first question is what do I use to represent that hierarchy, Categories or Attributes or other? Which is also report friendly .
The report will be per record label and should contain sales figures per artist and album.
Question two: Is it possible/recommended to use external tools like Jasper Reports and how?