How to setup Padding after clicking ToggleItem -- sql server reporting services

Lawrence
7/2/2004 2:17:01 PM

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!

Lev Semenets [MSFT]
7/2/2004 3:02:43 PM

you 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.

[quoted text, click to view]

sql server reporting services : How to setup Padding after clicking ToggleItem