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

Overall and Group Headers and Footers in List Report

Started by Cognos_Jan2017, 27 Aug 2018 12:28:57 PM

Previous topic - Next topic

Cognos_Jan2017

We utilize Subject Headers adding text and Singletons.  Works fine.

Hope there is a Simple solution for ...
For such Reports. as above, if we add a new Data Item to the List Report, it adds
Summary Rows, and removes the previously designed Headers and Footers.

Is there a Simple List setting that allows a Designer to add new Data Item(s)
to a List without removing existing Overall and Group Headers and Footers?

TIA, Bob

Francis aka khayman

you have screen shots? there is a simple list but it seems the report headers and singletons things up and made your report really complicated.

Cognos_Jan2017

Thank you.  I am scheduled to be out of the office until next Tuesday, and won't be accessing the App.

The Headers are "more than simple", designed for text labels and singletons.

The Overall and Group Headers unmerge all cells, then carefully merge some of those cells for proper display when we run as Excel.

The "displayed merged cells" begin w/ a Block.  Within that Block are (sample data) ...
FY17%: 40% Yes: 2 Total: 5
FY18%: 70% Yes: 7 Total: 10

The List Columns contain Yes and No definitions (calculated for the singletons) so the User can see what is occurring at each Business Unit.

Our FY19 begins on 1 Oct 2018.  We want to see all data in the Headers for FY17, FY18, and FY19.  That requires adding more Columns (Data Items) for Yes and No FY19 results.  These Columns are not rendered but stay in the List.

Right now, dragging in new Columns for FY19 inserts Summary Rows and removes existing Overall and Group Headers/ Footers.  Sure, each new FY (if we continue to show all FYs beginning w/ FY17) can author new Headers w/ new text labels and singletons.  Does not take that long, but would like to keep previously designed Headers (and Footers).

Please let me know if you have any questions.  Thank you, Bob

Penny

Perhaps try turning off automatic group and summary behaviour for lists.  Open the report for authoring, but then click on the ... in the top bar near the right (you see the preview (eye), properties, and then the ...)

Click on it and select Options from the dropdown list, then click on the Report tab.  Then uncheck 'Automatic group and summary behaviour for lists'.

I have seen reference to setting this globally but I haven't done this yet.

Hopefully this helps you.


Cognos_Jan2017

Thank you Penny.

I will test this, AND report results here, when I return to the App next Tuesday.

Will be excellent if that works.

TIA, Bob

Cognos_Jan2017

S O L U T I O N

QuotePerhaps try turning off automatic group and summary behaviour for lists.  Open the report for authoring, but then click on the ... in the top bar near the right (you see the preview (eye), properties, and then the ...)                                          
Click on it and select Options from the dropdown list, then click on the Report tab.  Then uncheck 'Automatic group and summary behaviour for lists'.

That WORKS !!!  Makes List design MUCH easier.                              

I need to start adding more "+" in appreciation.                                          
      
THANK you Penny.  Will be adding a "+" for you after posting this.