I need to add bullets in front of each data item in my report. The data items are variable in number for each group. Kindly help. Thanks in advance!!
asked Jan 27 '12 at 06:04 AM in Default
You can use function RunningValue to get this done
answered Jan 27 '12 at 06:10 AM
If you want a bullet point in front of every value, another option would be to build an expression in the text box that uses an ASCII character. For example: =Chr(211) & " " & Fields!FieldName.Value
answered Feb 02 '12 at 02:30 PM
One possible way is to use the expressoin as @grrl_geek suggested.
However, when yo do this all the numbers will be converted to a string and you will have no easy control over the value how it will look like. Also you will have to modify all the expressions one by one (if you want to have the bullets in multiple text boxes/cells.
From my point of view the easiest way and easiest to maintain is to use a Number Format of the textbox or cell in tablix or in whatever other component supporting Format Strings.
Using the format string allows you to set this behavior for multiple text boxes/cells at once without taking care about expression in it. Simply build one Format String, Select multiple textboxes/cells then in the properties window find Category Number under which is Format Property.. Set appropriate format string and you are done. Everything in single step without affecting any calculation or expression.
Only note.. You cannot use a predefined formats. (I mean like N2 etc).
You can choose bullet by using a Character Map.
answered Feb 02 '12 at 02:55 PM