Multiple Values on Point Labels

Hellow all,
Is there a way to show multiple point labels on a pie chart? I have the pie
showing the percentage using the following format :
=Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value, "chart1")
format code: %.0
I want to add the YTD value on a separate line so I will need to add a
return then add some code like Sum(Fields!YTD.Value).
I can get the two values to join by using a + sign but the number run
together with the same format code. I need the first line to show as a
percent and the second on a new line as a whole number.
Has anyone done this or know how to do it? In Excel this was easy but I am
unsure how to do it in SRS.
Thanks,
AnthonyUse the Format function to apply certain format codes to parts of your label
string. E.g.:
=Format(Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value, "chart1"), "P1") &
vbcrlf & Format(Sum(Fields!YTD.Value), "C0")
See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctFormat.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:08E789F2-6DA2-4A6F-ADF4-98BF617C52DE@.microsoft.com...
> Hellow all,
> Is there a way to show multiple point labels on a pie chart? I have the
> pie
> showing the percentage using the following format :
> =Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value, "chart1")
> format code: %.0
> I want to add the YTD value on a separate line so I will need to add a
> return then add some code like Sum(Fields!YTD.Value).
> I can get the two values to join by using a + sign but the number run
> together with the same format code. I need the first line to show as a
> percent and the second on a new line as a whole number.
> Has anyone done this or know how to do it? In Excel this was easy but I
> am
> unsure how to do it in SRS.
> Thanks,
> Anthony|||Robert,
Thanks for all the help!!! I won't get to try this until tomorrow but it
makes sense. I think my biggest problem is I am not a "programmer" by trade.
I am getting pretty good with SQL but I know exactly where I need to look by
using the Transact SQL help that comes with SQL server 2000. Is there a
specific place that I can look that gives me examples of how to code for SRS?
I need to be able to look up functions and such then be able to translate
them. Also what language are you using for most of the examples that you
provide? I think I have the option to use any of the .net languages but I am
not sure. If I had to pick I think Visual Basic would be the best...I know
a little from Access.
Thanks again for all the help!!!
"Robert Bruckner [MSFT]" wrote:
> Use the Format function to apply certain format codes to parts of your label
> string. E.g.:
> =Format(Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value, "chart1"), "P1") &
> vbcrlf & Format(Sum(Fields!YTD.Value), "C0")
> See also:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctFormat.asp
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:08E789F2-6DA2-4A6F-ADF4-98BF617C52DE@.microsoft.com...
> > Hellow all,
> >
> > Is there a way to show multiple point labels on a pie chart? I have the
> > pie
> > showing the percentage using the following format :
> > =Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value, "chart1")
> > format code: %.0
> >
> > I want to add the YTD value on a separate line so I will need to add a
> > return then add some code like Sum(Fields!YTD.Value).
> >
> > I can get the two values to join by using a + sign but the number run
> > together with the same format code. I need the first line to show as a
> > percent and the second on a new line as a whole number.
> >
> > Has anyone done this or know how to do it? In Excel this was easy but I
> > am
> > unsure how to do it in SRS.
> >
> > Thanks,
> > Anthony
>
>|||The RDL expression language is based on VB.NET and has additional built-in
RS specific functions.
Use this as a starting point - it will lead to built-in RS aggregate
functions, various object collections in the ReportObjectModel, etc.:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_6fhv.asp
Besides that, you can use ALL functions available in the VB.NET run-time
library:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vaoriVBRuntimeLibraryKeywords.asp
And by default, you can use everything that is contained within the
following .NET framework namespaces:
* System
* System.Math
* System.Convert
* Microsoft.VisualBasic
Furthermore, you can add custom code or reference custom assemblies (written
in any .NET language).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:A328F9B7-3070-4D9A-8D86-51EA26E906E9@.microsoft.com...
> Robert,
> Thanks for all the help!!! I won't get to try this until tomorrow but it
> makes sense. I think my biggest problem is I am not a "programmer" by
> trade.
> I am getting pretty good with SQL but I know exactly where I need to look
> by
> using the Transact SQL help that comes with SQL server 2000. Is there a
> specific place that I can look that gives me examples of how to code for
> SRS?
> I need to be able to look up functions and such then be able to translate
> them. Also what language are you using for most of the examples that you
> provide? I think I have the option to use any of the .net languages but I
> am
> not sure. If I had to pick I think Visual Basic would be the best...I
> know
> a little from Access.
> Thanks again for all the help!!!
> "Robert Bruckner [MSFT]" wrote:
>> Use the Format function to apply certain format codes to parts of your
>> label
>> string. E.g.:
>> =Format(Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value, "chart1"), "P1") &
>> vbcrlf & Format(Sum(Fields!YTD.Value), "C0")
>> See also:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctFormat.asp
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
>> news:08E789F2-6DA2-4A6F-ADF4-98BF617C52DE@.microsoft.com...
>> > Hellow all,
>> >
>> > Is there a way to show multiple point labels on a pie chart? I have
>> > the
>> > pie
>> > showing the percentage using the following format :
>> > =Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value, "chart1")
>> > format code: %.0
>> >
>> > I want to add the YTD value on a separate line so I will need to add a
>> > return then add some code like Sum(Fields!YTD.Value).
>> >
>> > I can get the two values to join by using a + sign but the number run
>> > together with the same format code. I need the first line to show as a
>> > percent and the second on a new line as a whole number.
>> >
>> > Has anyone done this or know how to do it? In Excel this was easy but
>> > I
>> > am
>> > unsure how to do it in SRS.
>> >
>> > Thanks,
>> > Anthony
>>|||Thanks again this information is very helpful!!!
"Robert Bruckner [MSFT]" wrote:
> The RDL expression language is based on VB.NET and has additional built-in
> RS specific functions.
> Use this as a starting point - it will lead to built-in RS aggregate
> functions, various object collections in the ReportObjectModel, etc.:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_6fhv.asp
> Besides that, you can use ALL functions available in the VB.NET run-time
> library:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vaoriVBRuntimeLibraryKeywords.asp
> And by default, you can use everything that is contained within the
> following .NET framework namespaces:
> * System
> * System.Math
> * System.Convert
> * Microsoft.VisualBasic
> Furthermore, you can add custom code or reference custom assemblies (written
> in any .NET language).
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:A328F9B7-3070-4D9A-8D86-51EA26E906E9@.microsoft.com...
> > Robert,
> >
> > Thanks for all the help!!! I won't get to try this until tomorrow but it
> > makes sense. I think my biggest problem is I am not a "programmer" by
> > trade.
> > I am getting pretty good with SQL but I know exactly where I need to look
> > by
> > using the Transact SQL help that comes with SQL server 2000. Is there a
> > specific place that I can look that gives me examples of how to code for
> > SRS?
> > I need to be able to look up functions and such then be able to translate
> > them. Also what language are you using for most of the examples that you
> > provide? I think I have the option to use any of the .net languages but I
> > am
> > not sure. If I had to pick I think Visual Basic would be the best...I
> > know
> > a little from Access.
> >
> > Thanks again for all the help!!!
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> >> Use the Format function to apply certain format codes to parts of your
> >> label
> >> string. E.g.:
> >> =Format(Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value, "chart1"), "P1") &
> >> vbcrlf & Format(Sum(Fields!YTD.Value), "C0")
> >>
> >> See also:
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctFormat.asp
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> >> news:08E789F2-6DA2-4A6F-ADF4-98BF617C52DE@.microsoft.com...
> >> > Hellow all,
> >> >
> >> > Is there a way to show multiple point labels on a pie chart? I have
> >> > the
> >> > pie
> >> > showing the percentage using the following format :
> >> > =Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value, "chart1")
> >> > format code: %.0
> >> >
> >> > I want to add the YTD value on a separate line so I will need to add a
> >> > return then add some code like Sum(Fields!YTD.Value).
> >> >
> >> > I can get the two values to join by using a + sign but the number run
> >> > together with the same format code. I need the first line to show as a
> >> > percent and the second on a new line as a whole number.
> >> >
> >> > Has anyone done this or know how to do it? In Excel this was easy but
> >> > I
> >> > am
> >> > unsure how to do it in SRS.
> >> >
> >> > Thanks,
> >> > Anthony
> >>
> >>
> >>
>
>

Multiple value on y axis in chart?

Friends, I would like to put employee name and type of leave on the y-axis and on the x-axis the date, so that users can select the date start and end and employee/employees and see the chart or leaves.

But how to do that?

My fields are: Name, LeaveDescription and Date.

The data with me is for each employee, for each date, leave codes are there.

You would drag and drop name and leave description to the category fields (y-axis) and date to data fields (x-axis).|||

Dear ??€?§Q?,

It gives me this error:

More than one data set, data region, or grouping in the report has the name 'chart1_CategoryGroup1'. Data set, data region, and grouping names must be unique within a report.

Please help me.

Thanks,

|||Are you trying to drag and drop the same field twice to the same axis? Find where chart1_CategoryGroup1 is being added multiple times to a dataset, data region or grouping...|||

Dear ??€?§Q?,

Yeah that worked. Thanks.

But the thing is that, It gives me description on x axis and not on y.

Multiple value on y axis in chart?

Friends, I would like to put employee name and type of leave on the y-axis and on the x-axis the date, so that users can select the date start and end and employee/employees and see the chart or leaves.

But how to do that?

My fields are: Name, LeaveDescription and Date.

The data with me is for each employee, for each date, leave codes are there.

You would drag and drop name and leave description to the category fields (y-axis) and date to data fields (x-axis).|||

Dear ??€?§Q?,

It gives me this error:

More than one data set, data region, or grouping in the report has the name 'chart1_CategoryGroup1'. Data set, data region, and grouping names must be unique within a report.

Please help me.

Thanks,

|||Are you trying to drag and drop the same field twice to the same axis? Find where chart1_CategoryGroup1 is being added multiple times to a dataset, data region or grouping...|||

Dear ??€?§Q?,

Yeah that worked. Thanks.

But the thing is that, It gives me description on x axis and not on y.

Multiple value on y axis in chart?

Friends, I would like to put employee name and type of leave on the y-axis and on the x-axis the date, so that users can select the date start and end and employee/employees and see the chart or leaves.

But how to do that?

My fields are: Name, LeaveDescription and Date.

The data with me is for each employee, for each date, leave codes are there.

You would drag and drop name and leave description to the category fields (y-axis) and date to data fields (x-axis).|||

Dear ??€?§Q?,

It gives me this error:

More than one data set, data region, or grouping in the report has the name 'chart1_CategoryGroup1'. Data set, data region, and grouping names must be unique within a report.

Please help me.

Thanks,

|||Are you trying to drag and drop the same field twice to the same axis? Find where chart1_CategoryGroup1 is being added multiple times to a dataset, data region or grouping...|||

Dear ??€?§Q?,

Yeah that worked. Thanks.

But the thing is that, It gives me description on x axis and not on y.

multiple series on line chart

Hello,

I want to display more than one series on a line chart. I'm producing a resultset from a stored procedure which is like this:

Type Value Date

TypeA 0.07 01/06/2006

TypeB 0.08 01/06/2006

TypeC 0.08 01/06/2006

TypeA 0.08 02/06/2006

TypeB 0.09 02/06/2006

TypeC 0.09 02/06/2006

TypeA 0.09 03/06/2006

TypeB 0.10 03/06/2006

TypeC 0.11 03/06/2006

I want a seperate series for each of TypeA, TypeB, TypeC . Is it possible to doctor the resultset to give each Type (and Value) as unique columns? Or is there another way? Or do I have to shell out for Dundas Charts :) !

Thanks in advance for any help.

Sorry, I'm new to RS - I had overlooked the 'Series' area on the layout tab. Can it just be a matter of dropping the 'Type' field there? I'm not at my desk just now but will try in the morning - if someone feels like confirming meantime that would be great.|||

Dragging the 'Type' field from the dataset onto the series area on the layout tab gives me curves for TypeA, TypeB,TypeC. However the dates on the horizontal axis are all wrong 'Year' and 'Month' groups are OK but 'Days' are back to front (I have 3 category groups) - I need this because sometimes the dataset crosses more than 1 year. Anyone ?

|||All problems solved. In case anyone has similar problems - the issue was the dataset - the dates were not uniform for each Type ie.each series had a different set of dates.Once I got the dates matching everything was OK.

Multiple scales

Is it possible to have multiple scales in a chart?
if not is their a formula for getting all the values in the chart to show up
as big as possible?Both the X Ais and Y Axis can have a min scale and max scale, is this what
you want? If not, could you please tell us what the exact problem you have
encountered and what your exact purpose is?
Regards,
Kevin
"Leon" <leon@.poolmedia.se> wrote in message
news:FDE0CB4F-7BE7-4660-861A-7AABDC3BBF8D@.microsoft.com...
> Is it possible to have multiple scales in a chart?
> if not is their a formula for getting all the values in the chart to show
> up
> as big as possible?
>