COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: yvswamy on 24 Jul 2012 10:49:52 AM

Title: How to Insert blank rows for each data Item value
Post by: yvswamy on 24 Jul 2012 10:49:52 AM
Hi all,

I have data Item called [City], I want to display the values like shown below in a cross tab report.

CITY
Bangalore

Delhi

Mumbai

Hyderabad

I want to give space between each value. Please help me on this
Title: Re: How to Insert blank rows for each data Item value
Post by: LOUM on 08 Aug 2012 03:54:05 PM
What is the space used for? If just to heighten the report look I would adjust the cell padding on the bottom to reflect the apperance you would like.
Title: Re: How to Insert blank rows for each data Item value
Post by: charon on 09 Aug 2012 07:48:17 AM
or use margin respective.
another option, in case you want to get a real row without entries, might be using mod row.
search google, there is a nice workaround for alternating rows in cognos bi crosstabs/lists. indest of formating the rows in different colors your approach is to fill just every second row with city.
you might wanne try to create a data item with sth like
case when
mod row = 1 then city
when mod row = 2 then  '  '
else city
end

duno if that works, just an idea :)
gl