formatting data labels on a line graph

please see my sample image attached. The data labels (shown with red arrow pointers) need to be formatted with commas, but i can't find where to set it. I could set the formatting of numbers on y axis and dates on x axis, but don't know where to set data label formatting.

Please help.

Thanks.
sample-chart.png
patd1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ValentinoVBI ConsultantCommented:
Click one of the labels on the chart.  Now you'll see something like Chart Series Labels selected in the Properties window.  Hit F4 in case you don't see the Properties window.

With the Chart Series Labels selected, one of the properties is called Format.  Enter a valid format in there, such as #,0

For more options, please refer to this article: Formatting Numbers [SSRS]
0
patd1Author Commented:
When I am in design mode, i din't see the the labels or the line. I just see a blank chart area. The line and labels appear when i do preview.

Ho do I see graph line and labels in the design view?

Thanks for your help.
0
ValentinoVBI ConsultantCommented:
I can see the line while in design mode.  Same with the labels.  How did you activate the labels if you're not seeing that line?  By default these are not shown and you need to activate them by right-clicking on the line...

What version of SSRS are you using?  Have you got the latest service packs for both Visual Studio and SQL Server installed?  You are actually using VS (BIDS) to design the report, right?  Ow, and that's a regular Line chart, right?
0
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

patd1Author Commented:
I am using Visual studio 2010 sp1, and  .net version 4.0 on SQ Server 2008 R2.

Can you suggest adding format of data label numbers in the code copied below. I use
<Style >
      <Format>n0</format> 
 </Style> 

Open in new window

for y axis, and it displays my numbers in the correct format(ex: 1,231,345), but when I added this code to Data Labels, it still shows the numbers without commas.

 <ChartData>
          <ChartSeriesCollection>
            <ChartSeries Name="unique_customer_count">
              <ChartDataPoints>
                <ChartDataPoint>
                  <ChartDataPointValues>
                    <Y>=Fields!unique_customer_count.Value</Y>
                  </ChartDataPointValues>
                  <ChartDataLabel>
                    <Style>
                      <FontSize>7pt</FontSize>
                      <FontWeight>Normal</FontWeight>
                    </Style>
                    <UseValueAsLabel>true</UseValueAsLabel>
                    <Visible>true</Visible>
                  </ChartDataLabel>
                  <Style />
                  <ChartMarker>
                    <Type>Diamond</Type>
                    <Style>
                      <Color>Tomato</Color>
                     <Format>n0</format>  --tried this but didn't help,
                    </Style>
                  </ChartMarker>
                  <DataElementOutput>Output</DataElementOutput>
                </ChartDataPoint>
              </ChartDataPoints>
              <Type>Line</Type>
              <Subtype>Smooth</Subtype>
              <Style />
              <ChartEmptyPoints>
              <Style/>               
                <ChartMarker>                 
                   <Style >
                    <Format>n0</format>  --tried this but didn't help,
                </Style>
                </ChartMarker>
                <ChartDataLabel>
                  <Style >
                    <Format>n0</format>  --tried this but didn't help,
                </Style>
                  <Position>Top</Position>
                </ChartDataLabel>
              </ChartEmptyPoints>
              <ValueAxisName>Primary</ValueAxisName>
              <CategoryAxisName>Primary</CategoryAxisName>
              <ChartSmartLabel>
                <CalloutLineColor>Black</CalloutLineColor>
                <MinMovingDistance>0pt</MinMovingDistance>
              </ChartSmartLabel>
            </ChartSeries>
          </ChartSeriesCollection>
        </ChartData>

Open in new window

0
ValentinoVBI ConsultantCommented:
The Style node should be located in a ChartDataLabel node right under the ChartDataPointValues.  If I take the top part of your RDL it goes like this:

 <ChartData>
          <ChartSeriesCollection>
            <ChartSeries Name="unique_customer_count">
              <ChartDataPoints>
                <ChartDataPoint>
                  <ChartDataPointValues>
                    <Y>=Fields!unique_customer_count.Value</Y>
                  </ChartDataPointValues>
                  <ChartDataLabel>
                    <Style>
                      <FontSize>7pt</FontSize>
                      <FontWeight>Normal</FontWeight>
                      <Format>N0</Format>
                    </Style>
                    <UseValueAsLabel>true</UseValueAsLabel>
                    <Visible>true</Visible>
                  </ChartDataLabel>
                  <Style />
                  <ChartMarker>
                    <Type>Diamond</Type>

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
patd1Author Commented:
Thanks. That worked.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.