bullets in front of each data item


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!!

more ▼

asked Jan 27, 2012 at 06:04 AM in Default

avatar image

134 14 14 18

i am unable to upload the screen shot of my report. i believe i by mistake deleted John's answer :|

Jan 27, 2012 at 06:28 AM NAmola

No, your good. I realized that my answer was incorrect, thus I removed it. You specified SSRS and I failed to see that.

Jan 27, 2012 at 06:52 AM JohnM

no probs :) thanks anyways for taking a look.

Jan 27, 2012 at 07:54 AM NAmola

Always. =)

Jan 27, 2012 at 08:18 AM JohnM
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

You can use function RunningValue to get this done


more ▼

answered Jan 27, 2012 at 06:10 AM

avatar image

Sacred Jewel
1.7k 3 7 10

thanks sacred jewel. what is "GroupName"?

Jan 27, 2012 at 06:44 AM NAmola

just figured it out. was not able to add bullets but numbered them. thanks!!

Jan 27, 2012 at 07:53 AM NAmola
(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Feb 02, 2012 at 02:30 PM

avatar image

866 1 3 7

(comments are locked)
10|1200 characters needed characters left

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.


  1. Select properties of a textbox/cell

  2. Select Number and choose any format you want

  3. Switch to Custom format and put a bullet character in front of the format string

  4. You are done. You will have bullet in front of your values

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.

more ▼

answered Feb 02, 2012 at 02:55 PM

avatar image

Pavel Pawlowski
22.7k 10 15 26

Nice! I hadn't thought of doing it that way.

Feb 02, 2012 at 10:54 PM grrl_geek
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 27, 2012 at 06:04 AM

Seen: 6849 times

Last Updated: Feb 02, 2012 at 10:54 PM

Copyright 2017 Redgate Software. Privacy Policy