Need SQL Server 2000 pre SP4 hotfix for KB818806

Does anyone have this hot fix and if so, are you willing to share it with
us?
Thanks,
Mary Clark
SQL Server DBAYou need to contact PSS to get this as indicated in the kB - this shouldn't
cost you anything. The reason for this is so that they can keep track of how
many customers are affected by specific issues and because the hotfixes are
not necessarily tested as much as service packs or downloadable hotfixes.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mary Clark" <mclark@.perryjudds.com> wrote in message
news:Oq19iGpQEHA.3140@.TK2MSFTNGP11.phx.gbl...
> Does anyone have this hot fix and if so, are you willing to share it with
> us?
> Thanks,
> Mary Clark
> SQL Server DBA
>|||Thanks...I'll do that.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eTGxWqyQEHA.3732@.TK2MSFTNGP10.phx.gbl...
> You need to contact PSS to get this as indicated in the kB - this
shouldn't
> cost you anything. The reason for this is so that they can keep track of
how
> many customers are affected by specific issues and because the hotfixes
are
> not necessarily tested as much as service packs or downloadable hotfixes.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Mary Clark" <mclark@.perryjudds.com> wrote in message
> news:Oq19iGpQEHA.3140@.TK2MSFTNGP11.phx.gbl...
with[vbcol=seagreen]
>

Need SQL Server 2000 pre SP4 hotfix for KB818806

Does anyone have this hot fix and if so, are you willing to share it with
us?
Thanks,
Mary Clark
SQL Server DBA
You need to contact PSS to get this as indicated in the kB - this shouldn't
cost you anything. The reason for this is so that they can keep track of how
many customers are affected by specific issues and because the hotfixes are
not necessarily tested as much as service packs or downloadable hotfixes.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mary Clark" <mclark@.perryjudds.com> wrote in message
news:Oq19iGpQEHA.3140@.TK2MSFTNGP11.phx.gbl...
> Does anyone have this hot fix and if so, are you willing to share it with
> us?
> Thanks,
> Mary Clark
> SQL Server DBA
>
|||Thanks...I'll do that.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eTGxWqyQEHA.3732@.TK2MSFTNGP10.phx.gbl...
> You need to contact PSS to get this as indicated in the kB - this
shouldn't
> cost you anything. The reason for this is so that they can keep track of
how
> many customers are affected by specific issues and because the hotfixes
are[vbcol=seagreen]
> not necessarily tested as much as service packs or downloadable hotfixes.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Mary Clark" <mclark@.perryjudds.com> wrote in message
> news:Oq19iGpQEHA.3140@.TK2MSFTNGP11.phx.gbl...
with
>

need help!!! how to fix pie slices in SQL Reporting Services?

would it be possible to have a uniform color for pie slices..
i mean if im going to made 3 charts with the same categories, it should have uniform color....

For example:
Chart1
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

Chart2
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

Chart3
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

So then, how can i pick color for pie slices in Excel and SQL Reporting Services? I need it ASAP!!! Thanks in advance :)

Please check the following article and sample: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx

One part of the article describes how to define and use a custom color palette (this is what you are looking for). In your case, you would just make all the pie charts call the same function to get the color values.

Alternatively (but this is more work and less efficient), you could use an IIF function call on every datapoint to dynamically determine the colors. E.g. =iif(Fields!Region.Value = "America", "Green", iif(Fields!Region.Value = "India", "Blue", .... ))

-- Robert|||

How do i set the color of the datapoint in a pie chart.

Regards,

Karen

|||

I got that to work but i have one problem if my values contain

40%,30%, 30% the color repeats for the second 30% and 30% how can i get a different color for each of the 30%.

Any help will be appreciated.

Regards

Karen

need help!!! how to fix pie slices in SQL Reporting Services?

would it be possible to have a uniform color for pie slices..
i mean if im going to made 3 charts with the same categories, it should have uniform color....

For example:
Chart1
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

Chart2
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

Chart3
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

So then, how can i pick color for pie slices in Excel and SQL Reporting Services? I need it ASAP!!! Thanks in advance :)

Please check the following article and sample: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx

One part of the article describes how to define and use a custom color palette (this is what you are looking for). In your case, you would just make all the pie charts call the same function to get the color values.

Alternatively (but this is more work and less efficient), you could use an IIF function call on every datapoint to dynamically determine the colors. E.g. =iif(Fields!Region.Value = "America", "Green", iif(Fields!Region.Value = "India", "Blue", .... ))

-- Robert|||

How do i set the color of the datapoint in a pie chart.

Regards,

Karen

|||

I got that to work but i have one problem if my values contain

40%,30%, 30% the color repeats for the second 30% and 30% how can i get a different color for each of the 30%.

Any help will be appreciated.

Regards

Karen

need help!!! how to fix pie slices in SQL Reporting Services?

would it be possible to have a uniform color for pie slices..
i mean if im going to made 3 charts with the same categories, it should have uniform color....

For example:
Chart1
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

Chart2
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

Chart3
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

So then, how can i pick color for pie slices in Excel and SQL Reporting Services? I need it ASAP!!! Thanks in advance :)

Please check the following article and sample: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx

One part of the article describes how to define and use a custom color palette (this is what you are looking for). In your case, you would just make all the pie charts call the same function to get the color values.

Alternatively (but this is more work and less efficient), you could use an IIF function call on every datapoint to dynamically determine the colors. E.g. =iif(Fields!Region.Value = "America", "Green", iif(Fields!Region.Value = "India", "Blue", .... ))

-- Robert|||

How do i set the color of the datapoint in a pie chart.

Regards,

Karen

|||

I got that to work but i have one problem if my values contain

40%,30%, 30% the color repeats for the second 30% and 30% how can i get a different color for each of the 30%.

Any help will be appreciated.

Regards

Karen