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.
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.