COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: bbtresoo on 20 May 2014 05:38:48 PM

Title: Embedded column in a List or Crosstab
Post by: bbtresoo on 20 May 2014 05:38:48 PM
Hi Guys,

Do Anyone know how can I get this kind of display in my report or a Document talking about that? it will be very appreciated.
Here is what i'm looking for

In my list or crosstab 

For instance
                     COLUMN1                                     Measure1                         Measure 2

                   Cash Equivalents (level1)                   V1                                  v2
                          Money Market (level2)                v3                                   v4
                          Cash (Level2)
                                  .
                                  .
                                  .
                      Fixed Income (level1)                     v5                                    v6
                            Government(level2)                  v7                                    v8
                                   Corporates (level3)            v9                                    v10


Hope that I've been the more explicit as possible. Even a link  will be very helpul  ;)
Thank you in advance for your feedback
Title: Re: Embedded column in a List or Crosstab
Post by: ToriBurns on 20 May 2014 08:58:39 PM
You can use a table. Unlock the report by clicking the lock icon on the menu above. I guess on the formatting toolbar. Then you can drag a table inside a crosstab cell. On the first column of the table you can set a width that will serve as a tab to indent your data. Then on the second column you can drag your data item. If this is what you want, hope it helps. :)
Title: Re: Embedded column in a List or Crosstab
Post by: bbtresoo on 20 May 2014 09:59:24 PM
Quote from: ToriBurns on 20 May 2014 08:58:39 PM
You can use a table. Unlock the report by clicking the lock icon on the menu above. I guess on the formatting toolbar. Then you can drag a table inside a crosstab cell. On the first column of the table you can set a width that will serve as a tab to indent your data. Then on the second column you can drag your data item. If this is what you want, hope it helps. :)

tks a lot .i'll try it. if you have any link related to this topic please feel free to send it to me. by the way do you know  if there's any technical name for this method. tks a lot
Title: Re: Embedded column in a List or Crosstab
Post by: ToriBurns on 20 May 2014 10:16:26 PM
You're welcome. :)

I don't know if there's a technical name for it. Can't also find a link that will help or will serve as your guide. But, here is something, somehow related. http://www.ironsidegroup.com/2013/02/05/report-studio-cookbook-unlock-concise-list-reports/ (http://www.ironsidegroup.com/2013/02/05/report-studio-cookbook-unlock-concise-list-reports/) Hope it helps. If you have a question feel free to ask me. :)

Title: Re: Embedded column in a List or Crosstab
Post by: bbtresoo on 22 May 2014 02:45:02 PM
Quote from: ToriBurns on 20 May 2014 10:16:26 PM
You're welcome. :)

I don't know if there's a technical name for it. Can't also find a link that will help or will serve as your guide. But, here is something, somehow related. http://www.ironsidegroup.com/2013/02/05/report-studio-cookbook-unlock-concise-list-reports/ (http://www.ironsidegroup.com/2013/02/05/report-studio-cookbook-unlock-concise-list-reports/) Hope it helps. If you have a question feel free to ask me. :)

Hi Tori , I found out how to get what I'm looking for, I played with List page header and some paddings to indent data.Tks again for your support.
Title: Re: Embedded column in a List or Crosstab
Post by: ToriBurns on 22 May 2014 08:30:49 PM
Oh yeah! You can use padding. I forgot.  ::) But it's not working on ipad. Glad to hear that you already solved your problem. You're welcome. :)