[SOLVED] How to suppress the value suppression of a section in a list

[hanfrie]

As a Cognos report newbie I cannot find a solution for the following requirement, always show the section data on a report.
I created a sample report based on the "Go Sales (query)" (Sales (query) / Branch), showing Sales.Quantity per City and sectioned on 'Country' and 'Province or state', filtered on Country = 'United States'.

Country: United States
Province or state: California
City                Quantity
Los Angeles     3,072,042

Province or state: Florida
City                Quantity
Miami             1,386,862

Province or state: Massachusetts
City                Quantity
Miami             2,860,514


The effect of the sectioning on 'Country' and 'Province or state' is that the repeating value of Country (United States) is not repeated on the report. But what I want is just that. So that it looks like this:

Country: United States
Province or state: California
City                Quantity
Los Angeles     3,072,042

Country: United States
Province or state: Florida
City                Quantity
Miami             1,386,862

Country: United States
Province or state: Massachusetts
City                Quantity
Miami             2,860,514

How can this be accomplished?

Thanks for your reply.

[Robl]

You can't change the sectioning, but you can change what is shown in each section header.
All you need to do add the Country data item into the province section header.

You'll need to unlock the report then just drag the report item from the country heade, or drag it in from the data items.

You'll need to delete the country section header, or hide the value in it to prevent it showing twice at the top depending on exactly how you want the report to look.
You might also need to add a table to the province section header so you can format the items in there neatly.

[hanfrie]

Thanks Robl, that is working exactly is requested.