text source

[mustafa]

Hello,

I am creating a cross-tab where the rows will show the children of a particular hierarchy.  However on the report output i want to take change the name of the children by using a sub-string expression.  Does anyone know how to do this or if you can?


thanks

mus

[blom0344]

Use the caption() function against the member before using the substring() function.
Steps:

Set the expression definition to:

substring(caption([great_outdoors_company].[Products].[Product line]),1,20).