SQL OR CRYSTAL HELP
Posted on 2014-12-23
I'm trying to create a report that has a table that lists part numbers and a table that lists an attribute name and a third table that lists the attribute value. There are up to 7 different attribute names but each part number usually has between zero and four attributes. When I create a CR that shows the part number and the attribute name and value, a part that has four different attributes will show up four different times, one for each attribute. I want to somehow display all attributes 1's in one column, 2's in a second column and so forth, with the part number listed only once. The attributes have a UID (1-7) but they also have a name. Ultimately, I would like to create a new view for this as I seem to always need this info. I'm not too familiar with SQL so don't really know how to do that. How can I get this info all on one line in a report?