displaying a hierarchy in a crosstab

I'm trying to display an org-chart-type hierarchy in a crosstab. I've got the dimension ordered properly via dimension attribute, but I can't figure out a way to indent the dimension label. It has spaces pre-pended to the name to indent appropriately, but they're getting stripped out, giving me a flat hierarchy.

Anyone know of any tricks I can use to get the crosstab to not strip leading spaces from a dimension label? I can put a non-space character in front of the spaces which keeps them from getting wacked, but the non-space character isn't going to make it by quality control :-)

Thanks in advance.

Find more posts tagged with

Comments

mwilliams

Hi jsherriff,

Is there any way you can show an image of what it should look like? Or attach a sample report I can run with non space characters in the place of the spaces, that way I can see exactly what you're trying to do. Thanks.

jsherriff

Michael,
Thanks. I didn't follow up because we decided to forgo this and just display them ordered but "flat". We were looking for a way to do something like:

Value
TopMost

5
.....Child of TM

3
.....Another Child

3
..........Child of Another

2
Sibling to TM

4

Spaces isn't going to work in the html obviously, but perhaps there's a way to indent the text per-cell based on another dimension attribute?

mwilliams

jsherriff,

I had an example that created a hierarchy look with a forced space rather than just a ' ', but I lost a lot of examples when my computer was upgraded from XP to Vista, so I don't think I have it. If I come across it, I'll let you know. It wasn't with a crosstab, but I would assume the element would work the same.