evend
asked on
Crystal Highlight Expert
I have to highlight a product that qualifies for multiple qualifications (attributes). When I highlight for say low fat, if that product also qualifies for say healthy, it will highlight one and add a second to the report.
How can I just show the one I want highlighted?
Thanks!
How can I just show the one I want highlighted?
Thanks!
ASKER
A joined table.
Products with attributes.
I would like to show all products but just highlight products that are associated with a specific attribute.
However, some products are associated with multiple attributes. Hence why products multiply on the report.
I think??
Products with attributes.
I would like to show all products but just highlight products that are associated with a specific attribute.
However, some products are associated with multiple attributes. Hence why products multiply on the report.
I think??
For the sample data I provided, what should be reported?
mlmcc
mlmcc
ASKER
If I want to see all products 1-4 but say highlight only 1 and 3 because they are 'FAT'.
Product 1 has FAT and HEALTHY
Product 2 has HEALTHY
Product 3 has FAT
Product 4 has HEALTHY and Attribute 3
Product 1 has FAT and HEALTHY
Product 2 has HEALTHY
Product 3 has FAT
Product 4 has HEALTHY and Attribute 3
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you have one record with all the attributes or do you a joined table with the attributes so you have multiple records.?
DO you only want to show for a given attribute or do you want to show all records but only the attributes that meet your highlight criteria?
Product 1 has FAT and HEALTHY
Product 2 has HEALTHY
Product 3 has FAT
Product 4 has HEALTHY and Attribute 3
What should the report show?
mlmcc