Is there a way to set auto group and summarize to NO by default. I know this can be done in Cognos 10 as per the link below ... however while that file exists in C11 I can't seem to get it to work. Has anyone tried this in Cognos 11?
http://www-01.ibm.com/support/docview.wss?uid=swg21616444
Are you talking about the following.
Top right of report studio click "..."
Click "options"
3rd tab "report"
5th check box down.
Untick "Automatic group and summary behavior for lists"
Ok I see the problem. If you use Notepad++ on the cognos analytics directory to search for the test autosummary within files you get a huge amount of entries coming back. No smoking gun though.
All i can say is the check box field is _2RH_chkAutoListGroupSummaryBehavior, found this through F12 on IE
Possibly can be set somewhere under D:\Program Files\ibm\cognos\analytics\webcontent\bi\schemas\rspec
Found the text ID IDS_AutoListGroupSummaryBehavior. Though unfortunately still no obviously set true to false anywhere.
Thanks for your reply .. I have resolved as follows:
Automatic Group and Summary Behavior for Lists
Current Behavior
Click More
Options
Report
Automatic Group and Summary Behavior for Lists is checked off
Desired Behavior
Click More
Options
Report
Automatic Group and Summary Behavior for Lists is NOT checked off
Action
File name --> profile_titan.xml
Location --> D:\Program Files\ibm\cognos\analytics\webcontent\bi\pat\profiles
Set the following
from --> <setting name="AutoListGroupSummaryBehavior" defaultValue="true"/>
to ----> <setting name="AutoListGroupSummaryBehavior" defaultValue="false"/>
Our report authors have tested successfully.
Thanks
Denise
Didn't work for me. I tried both settings and restarted the services.
I'm on 11.0.9
All good. Will persist with the manual approach.
It worked for us on 11.0.7 without having to restart the services. We are planning to go to 11.0.9 in the near future so I guess I will be looking for a way to do it again .. :(