Auto Group and Summarize Property

[abdulquddus_mca]

Hi !

Was wondering if there is any such property or method to set the Auto group and summarize proerty to No in Query Studio report.

In Report studio by default its Yes and we can change in properties...

Whereas i couldnt find in the Query Studio report.

Any comments guys


Abdul

[tupac_rd]

Run Report -> Advanced Options -> uncheck the box for Automatically summarize detail values, suppressing duplicates

it is in 8.4, I am thinking it is same for other C8 versions,

[MFGF]

it is in 8.4, I am thinking it is same for other C8 versions.

Yes - you are absolutely correct - it is the same in all versions of Query Studio (going right back to ReportNet).

[abdulquddus_mca]

iam using cognos 8.4..

Sorry I couldnt find that option...

Can u please give more explanation...


Thanks guys,
Abdul

[MFGF]

iam using cognos 8.4..

Sorry I couldnt find that option...

Can u please give more explanation...


Thanks guys,
Abdul

It's exactly as tupac_rd said. 
1. In Query Studio, click on the 'Run report' link in the blue menu area in the top left corner.
2. Click on the 'Advanced Options' link on the left.
3. Uncheck the 'Automatically summarize detail values, suppressing duplicates' checkbox.

MF.

[chegney]

Run Report -> Advanced Options -> uncheck the box for Automatically summarize detail values, suppressing duplicates

it is in 8.4, I am thinking it is same for other C8 versions,

The problem I have with this setting is that leaving it checked automatically summarizes, but does not automatically group before summarizing. Report studio will automatically group duplicate rows before summarizing. Query Studio appears to do the opposite and summarize before automatically grouping. This can cause issues with reporting a higher amount that what might be expected.