If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos List report issue

Started by Cognosuser2019, 02 May 2019 11:30:36 AM

Previous topic - Next topic

Cognosuser2019

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.



MFGF

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

Cognosuser2019

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

MFGF

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