Sometimes I'd like to have breakdowns of Saint classifications in a report but I don't want all the rows of same data. Example below deal with products, but this could apply to all SAINTS.
For example, if I have a product report showing visits, I'd like to also show some of the classifications. For example, some folks like the product number while others want the description. It would make the report easier to read and would allow for more dynamic sorting. If you had a product type in the report you could sort on that then visits and still have the product number.
Example is below. This would really only work with the key since there's a guaranteed one-to-one relationship.
Product Number | Product Name | Visits |
---|
ABC1 | Green shoes | 25 |
ABC2 | Red Shoes | 10 |
XYZ | Ugly Shoes | 2 |
What I'd get currently:
Product Number | Visits |
---|
ABC1 | 25 |
Green Shoes | 25 |
ABC2 | 10 |
Red Shoes | 10 |