Advanced Report Design - Professional SQL Server 2005 Reporting Services - page 217

=Count(Fields!EmployeeID.Value, “table1_Details_Group_Employees”, Recursive)
Finally, you want each row's padding to be progressively greater based on the group level. Using the
Level() function you can apply some simple math to the padding property value to get the desired
result. Since padding values are expressed as a string value, you will concatenate the value pt to the end
of a calculated numeric value.
Click on the first cell in the detail row to select the EmployeeName text box and in the properties win-
dow set the Padding_Left property to:
=Level(“table1_Details_Group_Employees “) * 20 & “pt”
This will set the padding for the first level (level 0) to 0 points, the second to 20 points, and the third to
40 points, and so on. I've dressed up the header row using bold text, a border, and text alignment and
added a title text box. Save the report and then select the Preview tab to view the results. The generated
report should appear as shown in Figure 6-44.
Figure 6-44