|
Hi 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!!
(comments are locked)
|
|
You can use function RunningValue to get this done thanks sacred jewel. what is "GroupName"?
Jan 27 '12 at 06:44 AM
NAmola
just figured it out. was not able to add bullets but numbered them. thanks!!
Jan 27 '12 at 07:53 AM
NAmola
(comments are locked)
|
|
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
(comments are locked)
|
|
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. Simply:
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. Nice! I hadn't thought of doing it that way.
Feb 02 '12 at 10:54 PM
grrl_geek
(comments are locked)
|


i am unable to upload the screen shot of my report. i believe i by mistake deleted John's answer :|
No, your good. I realized that my answer was incorrect, thus I removed it. You specified SSRS and I failed to see that.
no probs :) thanks anyways for taking a look.
Always. =)