x

bullets in front of each data item

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

more ▼

asked Jan 27 '12 at 06:04 AM in Default

NAmola gravatar image

NAmola
134 12 13 15

i am unable to upload the screen shot of my report. i believe i by mistake deleted John's answer :|
Jan 27 '12 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 '12 at 06:52 AM JohnM
no probs :) thanks anyways for taking a look.
Jan 27 '12 at 07:54 AM NAmola
Always. =)
Jan 27 '12 at 08:18 AM JohnM
(comments are locked)
10|1200 characters needed characters left

6 answers: sort voted first

You can use function RunningValue to get this done

RunningValue(Fields!YOURFIELD.Value,Count,”GroupName”)
more ▼

answered Jan 27 '12 at 06:10 AM

Sacred Jewel gravatar image

Sacred Jewel
1.6k 2 4 5

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)
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 '12 at 02:30 PM

grrl_geek gravatar image

grrl_geek
866 2

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

Simply:

  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 '12 at 02:55 PM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.2k 8 11 21

Nice! I hadn't thought of doing it that way.
Feb 02 '12 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x535

asked: Jan 27 '12 at 06:04 AM

Seen: 1942 times

Last Updated: Feb 02 '12 at 10:54 PM