Greetings everyone,
I'm currently facing an issue with grouping in Cognos Report Studio. While I've successfully grouped the first two columns to eliminate redundant items, I'm encountering a problem with the remaining columns. Instead of consolidating into a single row, they are resulting in two separate cells.
Specifically, I am working with items that have zero stock. These should be displayed in a single row, indicating "Y" for zero stock and showing the number of days since they've reached zero. My goal is to ensure all relevant columns are presented in one row without any duplicates.
I appreciate any guidance or insights you may have on resolving this issue. Please find the relevant details in the attached file.
Quote from: Bago on 05 Mar 2025 02:53:44 AMGreetings everyone,
I'm currently facing an issue with grouping in Cognos Report Studio. While I've successfully grouped the first two columns to eliminate redundant items, I'm encountering a problem with the remaining columns. Instead of consolidating into a single row, they are resulting in two separate cells.
Specifically, I am working with items that have zero stock. These should be displayed in a single row, indicating "Y" for zero stock and showing the number of days since they've reached zero. My goal is to ensure all relevant columns are presented in one row without any duplicates.
I appreciate any guidance or insights you may have on resolving this issue. Please find the relevant details in the attached file.
Hi,
The issue here is that the first "Zero in" column has both Y and N values for each item. Is this a value being read in from the data source, or is it being calculated (and if so, what is the expression)? As an interim test (to make 100% sure this is the issue), what do you see if you remove that column from the report? From the sample you attached, it looks like the first "Zero in" column is Y when the first "Days Since Out of Stock" column is not null? You could perhaps change the item to use an expression that looks for this?
Cheers!
MF.