Formatting point labels on a stacked column chart

I have a stacked column chart with two series. The chart by default is
showing point labels in the middle of the bar for each series for each
category on X-axis. I also need to have a label at the top of each
stacked column repesenting sum of Y values for each X value. So if one
series Y value is 5 and second 10 for a particular X value, I need to
show both point labels and a third label at the top of the column
showing 15. Thank you for any feedback.Alibronek,
On the data tab of the chart properties add a new value to the chart, with
the expression of field1 + field2. On the appearance tab check the plot data
as line. This will give you a line above the bars, if you play around with
the markers and style you should be able to hide the line and only show the
markes.
AK Code Rat
"Alibronek" wrote:
> I have a stacked column chart with two series. The chart by default is
> showing point labels in the middle of the bar for each series for each
> category on X-axis. I also need to have a label at the top of each
> stacked column repesenting sum of Y values for each X value. So if one
> series Y value is 5 and second 10 for a particular X value, I need to
> show both point labels and a third label at the top of the column
> showing 15. Thank you for any feedback.
>sql

Formatting labels in chart

Hello,

I have one report with chart. And labels of X axis at this chart are too long. How can I format them to show, for example, only 3 first symbols of titles?
As far as I understand, to solve this problem I should use Format property. But I know only about formatting date and numbers, not strings.
Can you help me?

Thank you.

I have a similar problem. The labels are little too long and are shown alternatively on 2 different lines.

Is it possible to have the labels angled at 45 degrees or something?

Thanks for any help!!!

|||To shorten labels i use "substring" in the sql-query..

select label, substring(label,1,5) as shortlabel, value from table (MSSQL)
select label, substr(label,1,5) as shortlabel, value from table (Oracle)

|||

in the Label property do the following.

= Code.getThreeCharsFromMyLabel(Fields!LabelField.Value)

In the code section of the report you could write a function named "getThreeCharsFromMyLabel" that accepts the label string and returns a Substring of the label.

and thats it u get what u want...... :)

|||

Note: you could also just use the =Left(..., 3) function to get the first 3 characters: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctleft.asp

-- Robert

sql

format of point labels

Can I display number values with their corresponding percentage values in pie
charts like I can in Excel? (Ex. 45, 7.7%) If so, how? I've gotten either
one or the other to appear, but not both at the same time.You would need to write an expression to concatenate the calculated values.
E.g.:
=Sum(Fields!x.Value) & ", " & Format(Sum(Fields!x.Value) /
Sum(Fields!x.Value, "DataSetName"), "P1")
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"dataGirl" <dataGirl@.discussions.microsoft.com> wrote in message
news:8025F487-40B6-46E8-97D4-FABA0507B9EB@.microsoft.com...
> Can I display number values with their corresponding percentage values in
> pie
> charts like I can in Excel? (Ex. 45, 7.7%) If so, how? I've gotten
> either
> one or the other to appear, but not both at the same time.

format a date in a chart

I have a line graph that has a date label for the X-axis. The date labels
show as this ugly formated date, something like 12/15/2005 11:37:00 AM. Is
there any way to format the X-label so that it will only show the 12/15/2005?
Thanks.In Studio: Chart Properties>X Axis>Format code: d
or in XML:
<CategoryAxis>
<Axis>
<Style>
<Format>d</Format>
"Leon Chuck Gosslin" <Leon Chuck Gosslin@.discussions.microsoft.com> wrote in
message news:B18F0C63-6C8C-42C3-932B-A3FDEDBEB23E@.microsoft.com...
>I have a line graph that has a date label for the X-axis. The date labels
> show as this ugly formated date, something like 12/15/2005 11:37:00 AM.
> Is
> there any way to format the X-label so that it will only show the
> 12/15/2005?
> Thanks.
>

Form type reports... Possible?

I need to create data reporting forms that does not necesserily have
repeating rows, but are composed of field names (test labels) and values
(read/calculated from database fields) scattered on page (similar to a manual
data entry form). I can do this with Cristal Reports but is this possible
with the SQL Server Reportsing Services? Thank you very much for your
opinions.
DDAbsolutely - just set up you dataset (or datasets) and drag the fields from
the field browser directly onto the page. Add labels and you're done!
"Dursun" wrote:
> I need to create data reporting forms that does not necesserily have
> repeating rows, but are composed of field names (test labels) and values
> (read/calculated from database fields) scattered on page (similar to a manual
> data entry form). I can do this with Cristal Reports but is this possible
> with the SQL Server Reportsing Services? Thank you very much for your
> opinions.
> DD