COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Samrat on 06 Apr 2015 05:05:42 AM

Title: Line break after data item value chage
Post by: Samrat on 06 Apr 2015 05:05:42 AM
Hi all,

I have requirement like below

we have a broker number,policy,region,insured fiield in the report.for single broker number there will many policies and hence report will display may records for one broker and when broker number changes, we need to display blank line and data for new broker will be diplayed after blank line in list.

example

Broker number       policy    region   insured
x                             zzzz      A           asddasd
x                             yyyy      B           sdfsfsdf
x                             vvvv     c             tjjhgjh
<Blankline>
Y                            dfgdg       B           dfgdfg             
y                            fdggyrt    A            ghjtyj
y                             wsrfdg   D             ghher

sorry for junk values in examples.

Please let me know how to achieve above requirement

Thanks,
SM

Title: Re: Line break after data item value chage
Post by: Joker on 06 Apr 2015 09:02:37 AM
Quote from: Samrat on 06 Apr 2015 05:05:42 AM
Hi all,

I have requirement like below

we have a broker number,policy,region,insured fiield in the report.for single broker number there will many policies and hence report will display may records for one broker and when broker number changes, we need to display blank line and data for new broker will be diplayed after blank line in list.

example

Broker number       policy    region   insured
x                             zzzz      A           asddasd
x                             yyyy      B           sdfsfsdf
x                             vvvv     c             tjjhgjh
<Blankline>
Y                            dfgdg       B           dfgdfg             
y                            fdggyrt    A            ghjtyj
y                             wsrfdg   D             ghher

sorry for junk values in examples.

Please let me know how to achieve above requirement

Thanks,
SM



Hi,

--Create a section on Broker Number.
--Add the data item broker number again to the list from list of query data items.
--Unlock the report.
--Cut the data item  and text item from the sectioned part.
--Run the report.

Thanks,

Regards,
Joker