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
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,
Quote from: tupac_rd on 24 Jun 2010 02:06:15 PMit 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).
iam using cognos 8.4..
Sorry I couldnt find that option...
Can u please give more explanation...
Thanks guys,
Abdul
Quote from: abdulquddus_mca on 08 Jul 2010 12:58:48 PM
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.
Quote from: tupac_rd on 24 Jun 2010 02:06:15 PM
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.