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