COGNOiSe.com - The IBM Cognos Community

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...

--> 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

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

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

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

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..

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

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

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

thanks for all giving valuable information..

how did you do this eventually?