Data w missing attributes being suppressed? Already made sure suppression is off

[Applemdjs311]

Hi there

Our data is pretty messy, so sometimes Product Description is blank due to old methods. Anyways, when I'm trying to pull a list report it appears that the rows w a missing attribute (like upc=567) are not in my output. I've made sure that suppression is off for each of the columns. What else can I do? I've googled it, but it seems like most solutions are based on numerical values  not character attributes.

Side note, if I pull upc, group, and type - I get all my results. It's only an issue when I want product description too...


Upc*   Group*               type*           Product description
123     Perishable           Fruit            Lucky seedless watermelon
234     Nonperishable      Alcohol        Sky vodka 32oz berry
567     Nonperishable      Candy

*upc, group, and type are required attributes so they are never blank.

[bdbits]

This could be due to the way the joins between the tables are defined in the Framework Manager model (inner versus outer joins). If you cannot have the model changed, you could work around it by splitting the query in two parts with the product descriptions separate, then do an outer join in the report itself.