COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: actcognosuser on 07 Dec 2019 05:44:54 PM

Title: How to add blank space between list rows.
Post by: actcognosuser on 07 Dec 2019 05:44:54 PM
Hi,

The list report is grouped by Region and Company. How do i add a blank row( like a space to  visually distinguish between the company names?)

Region                   Company       Employee           Contact
----------------------------------------------------------------------------------------------
North America         ABC                 Emp1              34353545
                                                      Emp2              12121212
                                                      Emp3               54545454
                                                      Emp4              45454545
                                 --------------------------------------------------------------------
                                   NEED BLANK ROW OR SPACING BETWEEN COMPANY NAMES
                                  --------------------------------------------------------------------
                               XYZ                  Emp5
                                                      Emp6
                                                      Emp7
                                                      Emp8
Title: Re: How to add blank space between list rows.
Post by: Andrei I on 07 Dec 2019 08:07:51 PM
You can Group By Region, Company.
Then you should get a row for each Group level
Title: Re: How to add blank space between list rows.
Post by: actcognosuser on 08 Dec 2019 01:31:42 PM
Grouping by Region And Company doesn't add a space between company name rows.

How do I add a blank row between company 1 and company 2?
Title: Re: How to add blank space between list rows.
Post by: CognosPaul on 08 Dec 2019 08:26:33 PM
If the grouping doesn't automatically create the group subtotal row, use "List headers and footers" and create the footer on the company group row.
Title: Re: How to add blank space between list rows.
Post by: Andrei I on 09 Dec 2019 02:31:55 PM
See attached screenshot