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

Line break after data item value chage

Started by Samrat, 06 Apr 2015 05:05:42 AM

Previous topic - Next topic

Samrat

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


Joker

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