Showing posts with label property. Show all posts
Showing posts with label property. Show all posts

Wednesday, March 21, 2012

Formatting numbers in charts

Is there a property or hack that would allow for the numbers (for each
series) in a piechart to appear OUTSIDE the "pie" itself. In other words the
numbers displayed outside the series with lines or arrows pointing to the
corresponding "piece?"
the intent of course is to allow users to see the number when the series is
too small to fit the number inside the chart
thanks?"Outside" labels for pie and doughnut charts were added in RS 2000 SP1.
Check the Readme file of SP1 / SP2:
http://download.microsoft.com/download/5/1/3/513534ae-a0e7-44e6-9a04-ba3c549a5f5f/sp2Readme_EN.htm#_chart_enhancements
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"neokortex" <neokortex@.discussions.microsoft.com> wrote in message
news:C6F25E23-7719-41E7-9DFD-A103501D1AA6@.microsoft.com...
> Is there a property or hack that would allow for the numbers (for each
> series) in a piechart to appear OUTSIDE the "pie" itself. In other words
> the
> numbers displayed outside the series with lines or arrows pointing to the
> corresponding "piece?"
> the intent of course is to allow users to see the number when the series
> is
> too small to fit the number inside the chart
> thanks?|||This works by the way...although oddly the changes are not visible in the VS
IDE..only after it was uploaded to the server
thanks
"Robert Bruckner [MSFT]" wrote:
> "Outside" labels for pie and doughnut charts were added in RS 2000 SP1.
> Check the Readme file of SP1 / SP2:
> http://download.microsoft.com/download/5/1/3/513534ae-a0e7-44e6-9a04-ba3c549a5f5f/sp2Readme_EN.htm#_chart_enhancements
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "neokortex" <neokortex@.discussions.microsoft.com> wrote in message
> news:C6F25E23-7719-41E7-9DFD-A103501D1AA6@.microsoft.com...
> > Is there a property or hack that would allow for the numbers (for each
> > series) in a piechart to appear OUTSIDE the "pie" itself. In other words
> > the
> > numbers displayed outside the series with lines or arrows pointing to the
> > corresponding "piece?"
> >
> > the intent of course is to allow users to see the number when the series
> > is
> > too small to fit the number inside the chart
> >
> > thanks?
>
>|||Yes, outside labels are not shown at design time - only in preview or when
rendering on the server.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"neokortex" <neokortex@.discussions.microsoft.com> wrote in message
news:B7135406-41AD-4A8F-A161-B242C13EA033@.microsoft.com...
> This works by the way...although oddly the changes are not visible in the
> VS
> IDE..only after it was uploaded to the server
> thanks
> "Robert Bruckner [MSFT]" wrote:
>> "Outside" labels for pie and doughnut charts were added in RS 2000 SP1.
>> Check the Readme file of SP1 / SP2:
>> http://download.microsoft.com/download/5/1/3/513534ae-a0e7-44e6-9a04-ba3c549a5f5f/sp2Readme_EN.htm#_chart_enhancements
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "neokortex" <neokortex@.discussions.microsoft.com> wrote in message
>> news:C6F25E23-7719-41E7-9DFD-A103501D1AA6@.microsoft.com...
>> > Is there a property or hack that would allow for the numbers (for each
>> > series) in a piechart to appear OUTSIDE the "pie" itself. In other
>> > words
>> > the
>> > numbers displayed outside the series with lines or arrows pointing to
>> > the
>> > corresponding "piece?"
>> >
>> > the intent of course is to allow users to see the number when the
>> > series
>> > is
>> > too small to fit the number inside the chart
>> >
>> > thanks?
>>

Monday, March 19, 2012

Formatting Date in SRS

I am trying to format a date value as XX/XX/XX when I place a "d" in the format property it formats it as XX/XX/XXXX any ideas on how to change it to XX/XX/XX?

thanks in advance

use dd/MM/yy

Friday, March 9, 2012

Formating Date Attibute in AS 2005

Hello everybody,

i'm trying to format a date attribute in AS 2005. I try to use the format property in the dimension designer but it does not work. It will be very hard for me to create another field of date in the data source view. My Cube have have about 100 field of type DATE.

Could you help?

Try searcing this forum for "format string". See if any get any useful information from previous discussions. You will find quite a few on the matter.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Wednesday, March 7, 2012

Format String for SSN

I need to format a char(9) field as ###-##-####. What format string do I
use in the Format property of the Text Box?Try
= Format(Convert.ToDouble(<your field>), "###-##-####")
It is a .NET hack but it works.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"John Taylor" <jtaylor@.uab.edu> wrote in message
news:O3j#WptfEHA.3928@.TK2MSFTNGP11.phx.gbl...
> I need to format a char(9) field as ###-##-####. What format string do I
> use in the Format property of the Text Box?
>|||Thanks! If you think that's a hack, I would hate for you to see the rest of
my code! : )
John
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:%231qNXEufEHA.712@.TK2MSFTNGP09.phx.gbl...
> Try
> = Format(Convert.ToDouble(<your field>), "###-##-####")
> It is a .NET hack but it works.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "John Taylor" <jtaylor@.uab.edu> wrote in message
> news:O3j#WptfEHA.3928@.TK2MSFTNGP11.phx.gbl...
> > I need to format a char(9) field as ###-##-####. What format string do
I
> > use in the Format property of the Text Box?
> >
> >
>