We are using Report Studio 1.1 and have several multi-select objects in our reports. When our users run the reports in Excel, they will want to see all the information for one item in one cell, but Cognos puts each item into different cells and thus creates a problem when using the sorting function in Excel.
Example:
Item #1 in our application has 3 different items selected, each one will have one row in Excel (in this case-3 rows)
FR
P2P
O2c
We've been told that there is nothing we can do to have Cognos put all three items in one cell in Excel.
Hope this is clear--I'm new to all of this.
Example:
Item #1 in our application has 3 different items selected, each one will have one row in Excel (in this case-3 rows)
FR
P2P
O2c
We've been told that there is nothing we can do to have Cognos put all three items in one cell in Excel.
Hope this is clear--I'm new to all of this.