How to setup Padding after clicking ToggleItem

I am trying to format the output result from a Recursive Group dataset.
The dataset is very simple with EmployeeID and ManagerID as recursive and
the latter being the parent id. Table structure is very simple with one
line on the detail level with EmployeeID, EmployeeName, ManagerName & Level
(using Level Function).
The report correctly returns all the records order by Level and Toggle by
EmployeeID. However, I would like to setup Padding when subsequent levels
show up after clicking the ToggleItem. Where would I set that up? Any
required scripts involved (iif...?). I would also like to setup different
color formatting for the different levels, and I assume it could be setup at
the same property setting as the Padding.
Much appreciated!
-Lawrenceyou could use Level() function to set padding and color.
For example, setting left padding to expression
=String.Format("{0}pt",Level() * 10) provides 10 points padding per level.
I would suggest using =Switch() for changing color:
=switch (Level() = 0, "Red", Level() = 1, "Blue", True, Nothing)
switch () takes a variable number of parameters in the form of (evaluation,
if true return, next evaluation ...)--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lawrence" <Lawrence@.discussions.microsoft.com> wrote in message
news:61F57876-20A5-4A81-94DB-3ABA16AD8053@.microsoft.com...
> I am trying to format the output result from a Recursive Group dataset.
> The dataset is very simple with EmployeeID and ManagerID as recursive and
> the latter being the parent id. Table structure is very simple with one
> line on the detail level with EmployeeID, EmployeeName, ManagerName &
Level
> (using Level Function).
> The report correctly returns all the records order by Level and Toggle by
> EmployeeID. However, I would like to setup Padding when subsequent levels
> show up after clicking the ToggleItem. Where would I set that up? Any
> required scripts involved (iif...?). I would also like to setup different
> color formatting for the different levels, and I assume it could be setup
at
> the same property setting as the Padding.
> Much appreciated!
> -Lawrence