COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Arsenal on 29 Mar 2007 08:38:25 PM

Title: Text after column heading and then the rows to be displayed
Post by: Arsenal on 29 Mar 2007 08:38:25 PM
Hi all,

I have a unique query, I would like to believe :P

Basically, suppose you have a report like this:

product Quantity  Price
      A    |    50     |  $100
     B     | 60        |   $200
            |             |
and so on

is it possible to make the report look like this?


product Quantity  Price
  Cognos Approved   
     
      A    |    50     |  $100
     B     | 60        |   $200
            |             |

i.e. use text (in the above example it's Cognos Approved) just after the column headings, and before the rows start?

I tried with repeaters, without any success
Title: Re: Text after column heading and then the rows to be displayed
Post by: MFGF on 30 Mar 2007 04:39:54 AM
Hi,

Sounds like a job for the List Page Header.  Just go to the toolbar and press the 'List Headers & Footers' button, and from here you can turn on a List Page Header.  This will add a header cell below the column headings, and you can populate this with whatever text you like.

Does that give you what you need?

MF.
Title: Re: Text after column heading and then the rows to be displayed
Post by: Arsenal on 30 Mar 2007 05:19:24 PM
MFGF,

Once again, your suggestion worked like a charm. THANKS

I'm beginning to think that I may have to ship over a part of my salary every month to Cognoise ;D
Title: Re: Text after column heading and then the rows to be displayed
Post by: COGNOiSe administrator on 31 Mar 2007 10:08:52 PM
Just buy him a beer at the conference if both of you are coming ...
Title: Re: Text after column heading and then the rows to be displayed
Post by: Arsenal on 01 Apr 2007 01:45:31 AM
What conference?
???
Title: Re: Text after column heading and then the rows to be displayed
Post by: COGNOiSe administrator on 01 Apr 2007 10:09:19 AM
The Cognos User Conference in May in Orlando, FL.
Title: Re: Text after column heading and then the rows to be displayed
Post by: Arsenal on 01 Apr 2007 11:58:41 AM
I wasn't aware of such a conference.

Let me try getting some info, since i would be very interested in attending
Title: Re: Text after column heading and then the rows to be displayed
Post by: Darek on 01 Apr 2007 03:50:56 PM
Don't be shy to stop by our booth and say hello!
Title: Re: Text after column heading and then the rows to be displayed
Post by: MFGF on 03 Apr 2007 03:25:16 AM
Sorry Arsenal/Darek, but I will not be able to make the long trek across the Atlantic to Orlando in May.  My employer has other things for me to be doing at the time.  I'd love to go and meet up with a few friends over a beer - perhaps another year.

Thanks for the offer  :)

MF.
Title: Re: Text after column heading and then the rows to be displayed
Post by: Arsenal on 03 Apr 2007 09:58:42 PM
1500 freakin dollars to attend

Anything that carries the Cognos name on it sure as hell doesn't come cheap :-\