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

How to Insert blank rows for each data Item value

Started by yvswamy, 24 Jul 2012 10:49:52 AM

Previous topic - Next topic

yvswamy

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

LOUM

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.

charon

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