If you are unable to create a new account, please email support@bspsoftware.com

 

How to insert list cell/ one row between list column header and list column body

Started by Prajam, 20 Mar 2013 03:09:05 AM

Previous topic - Next topic

Prajam

HI all,
I am new to cognos report studio,
There is a requirement that i have a list report , here the requirement is need to insert a one field/query item in between list column title and list column body. Need immediate help.

Actual format:                                                                     Required format:

col1             col2            col3                                     col1             col2              col3
---------------------------------                                       -----------------------------------------
<#col1#> <#col2#> <#col3#>                                            <#quert item1#>           
                                                                                 -------------------------------------------
                                                                                 <#col1#>     <#col2#>    <#col3#>   
                                   


thanks in advance...

blom0344

--> List Columns Title Style
--> Structure --> Headers and Footers --> List Header and Footers -->  Overall Header
This ads a row below the existing list header with  'Summary' in it.  Then use the split cell option to generate as many columns as exist below the existing list header

blom0344

You changed your post when I wrote my reply, which rather changes everything.  What would query item be?  If you simply use a dataitem the list will use the first value encountered to put below the header

Prajam

query item is the prompt value i have taken..
i.e need to insert the prompt selection value in between the list header nd body

blom0344

That is not a query item, but  the paramDisplayValue of the parameter concerned. (Can be used in a report expression)

Prajam

yes u r right.... since im very new to cognos, not able to catch exact tech. word
So can u pls give the solution for this..

blom0344

You can populate a list header with a report expression very much like using a dataitem label. The solution is therefore similar

Prajam

First thanks for spending ur valuable time on this issue,
Can u bit more elaborate, becoz when i tried , it creating overall header i.e above list column header.

Thanks i advance

RKMI

Hi,

After you create a overall header, click on the overall header line and the properties for list cell will be displayed, you will need to change the textsource to report expression as suggested in the previous post and move forward. I would also suggest you to go thru the report studio guide or ibm cognos 8 cookbook available on the web. They have good information to learn from if you are so new. There are also helpful videos on youtube I suggest you watching a few.

Thank,
RK