We are seeing issue with list report after upgrade from 10.2 to 11.
Data is getting displayed in multiple rows. We want it to be in one row. Please see the attached screenshot.
Can anyone help with this? The actual hours should show up in one row.
Quote from: Cognosuser2019 on 02 May 2019 11:30:36 AM
We are seeing issue with crosstab report after upgrade from 10.2 to 11.
Data is getting displayed in multiple rows. We want it to be in one row. Please see the attached screenshot.
Can anyone help with this? The actual hours should show up in one row.
What is going on in the report? Are there any calculations? Any items in the query not being displayed? It's difficult to say where the issue might be from just a screenshot. Can you provide more detail?
Cheers!
MF.
Thank you for your response. This is resolved. I had to play around with the aggregation. Changed the detailed aggregation on Sun to Sat columns to "Maximum" and Summary aggregation to "None". Then turned on the Auto Summarize and group to "Yes".
Quote from: Cognosuser2019 on 03 May 2019 09:27:33 AM
Thank you for your response. This is resolved. I had to play around with the aggregation. Changed the detailed aggregation on Sun to Sat columns to "Maximum" and Summary aggregation to "None". Then turned on the Auto Summarize and group to "Yes".
Ah! You had the Auto Group and Summarize property of the query set at "No"? That probably explains it :)
Cheers!
MF.