Customized color in Column chart?

I am using MS Reporting 2000 for Report where in one of the report I am
using column chart. Now I would like to give customized color to each column
in this chart but don't know how to implement it.
Please help me out from this situation!
Thanks,
SachinBasically the only way I have figured it outs is by going to the chart
properties>data tab>edit your value>appearance tab>click series style button
at bottom> fill tab. Once there you can eithere choose a different color
for all the bars or if you want a specific color for each bar showing up you
have to click on the expression button and write a iif statement stating
those colors. If you have any more questions let me know.
"Sachin Punatar" <Sachin Punatar@.discussions.microsoft.com> wrote in message
news:D685EB20-4E10-4214-B62D-7FC932E019EE@.microsoft.com...
>I am using MS Reporting 2000 for Report where in one of the report I am
> using column chart. Now I would like to give customized color to each
> column
> in this chart but don't know how to implement it.
> Please help me out from this situation!
> Thanks,
> Sachin
>|||Ben,
Thanks a tone for your reply.
This is absolutely right. But in my case i am using MS Reporting 2000 where
i am not able to have series style option in Appearance tab in data section.
To come out from this issue I have created one SetColor fuction in code
window of Report property but i am not sure how and where to call this
function so that it will create custom color for series. See Below example:
Public Function SetColor(N As String) As String
Select Case N
Case "Incurred"
Return "#fa8072"
Case "Billable"
Return "#eee8aa"
Case "Billed"
Return "#c0ffc0"
Case "Collected"
Return "#4169e1"
End Select
End Function
Now what i tried to call this function from Data-->Values-->Edit-->Value
property. And i am still not able to get appropriate output.
Please let me know is there any other work around for this.
Thanks in advance.
Sachin Punatar
"Ben Watts" wrote:
> Basically the only way I have figured it outs is by going to the chart
> properties>data tab>edit your value>appearance tab>click series style button
> at bottom> fill tab. Once there you can eithere choose a different color
> for all the bars or if you want a specific color for each bar showing up you
> have to click on the expression button and write a iif statement stating
> those colors. If you have any more questions let me know.
> "Sachin Punatar" <Sachin Punatar@.discussions.microsoft.com> wrote in message
> news:D685EB20-4E10-4214-B62D-7FC932E019EE@.microsoft.com...
> >I am using MS Reporting 2000 for Report where in one of the report I am
> > using column chart. Now I would like to give customized color to each
> > column
> > in this chart but don't know how to implement it.
> >
> > Please help me out from this situation!
> >
> > Thanks,
> > Sachin
> >
>
>|||Sachin Punatar wrote:
> > "Sachin Punatar" <Sachin Punatar@.discussions.microsoft.com> wrote in message
> > news:D685EB20-4E10-4214-B62D-7FC932E019EE@.microsoft.com...
> > >I am using MS Reporting 2000 for Report where in one of the report I am
> > > using column chart. Now I would like to give customized color to each
> > > column
> > > in this chart but don't know how to implement it.
> > >
> > > Please help me out from this situation!
> > >
> > > Thanks,
> > > Sachin
Give this a try:
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
(Courtesy of Brian Welcker)
Sean G.|||Sean -
Thanks for your favorable reply.
I have tried out with similar way as it was mentioned in below article:
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
But I am not able to set customized color for each column in the chart.
Please let me know if this requires SP1 or SP2 in my machine.
Because when I tried to call custom function written in code window of
Report property, it returns nothing. I have wrote "code.SetColor(values)" in
Data-->Values-->Edit--> Value tab but i dont think that it is calling custom
funciton properly. I strongly have doubts that it willl require SP1 or SP2 on
my machine.
Please verify and clear my doubts on this.
Seeking for your help.
Thanks in advance,
Sachin Punatar
"SeanGerman@.gmail.com" wrote:
> Sachin Punatar wrote:
> > > "Sachin Punatar" <Sachin Punatar@.discussions.microsoft.com> wrote in message
> > > news:D685EB20-4E10-4214-B62D-7FC932E019EE@.microsoft.com...
> > > >I am using MS Reporting 2000 for Report where in one of the report I am
> > > > using column chart. Now I would like to give customized color to each
> > > > column
> > > > in this chart but don't know how to implement it.
> > > >
> > > > Please help me out from this situation!
> > > >
> > > > Thanks,
> > > > Sachin
>
> Give this a try:
> http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
> (Courtesy of Brian Welcker)
>
> Sean G.
>sql

Customising Legends for chart

Hi to all,

A query about legends in a chart, is it possible to customise legends in chart? I have used formula fields as the value of a pie chart and apparently the legend shows "@." infront of the fieldname... I'd like to have my own legend name for reading friendliness.

Thanks.

-HenryAnd for your information I am using Crystal Report included with VS.net 2003.

Cheers.

-Henry|||i'm having the same problem..

anyone der to help?|||Hi Cynthia, it has been many years since I have post my question... But I think I don't have a solution. I believe a full version of Crystal Report allow renaming field name.|||ok. where can i get the full version of Crystal report? is it consider an additional component to integrate into visual studio?

Custom Series Color Problem

I am using SP1 and am trying to use the new custom color feature for chart
series.
The problem is that I want to specify a transparent color (Alpha = 50%).
Is there any way of doing this? It seems that you can only enter colors that
have RGB values, not ARGB values. (The System.Drawing.Color.FromArgb function
does not work in an expression).
At the moment, I am using the Semi-Transparent palette, but would like to
choose the colors myself as opposed to having them chosen for me.
--
cjARGB colors are not supported.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"CJ" <CJ@.newsgroup.nospam> wrote in message
news:E7870F65-DE71-4D39-9D47-748EB3FE7444@.microsoft.com...
>I am using SP1 and am trying to use the new custom color feature for chart
> series.
> The problem is that I want to specify a transparent color (Alpha = 50%).
> Is there any way of doing this? It seems that you can only enter colors
> that
> have RGB values, not ARGB values. (The System.Drawing.Color.FromArgb
> function
> does not work in an expression).
> At the moment, I am using the Semi-Transparent palette, but would like to
> choose the colors myself as opposed to having them chosen for me.
> --
> cj|||Will this be available in a future version?
"Lev Semenets [MSFT]" wrote:
> ARGB colors are not supported.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "CJ" <CJ@.newsgroup.nospam> wrote in message
> news:E7870F65-DE71-4D39-9D47-748EB3FE7444@.microsoft.com...
> >I am using SP1 and am trying to use the new custom color feature for chart
> > series.
> > The problem is that I want to specify a transparent color (Alpha = 50%).
> > Is there any way of doing this? It seems that you can only enter colors
> > that
> > have RGB values, not ARGB values. (The System.Drawing.Color.FromArgb
> > function
> > does not work in an expression).
> > At the moment, I am using the Semi-Transparent palette, but would like to
> > choose the colors myself as opposed to having them chosen for me.
> > --
> > cj
>
>|||It is on the wishlist for a future version.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"CJ" <CJ@.newsgroup.nospam> wrote in message
news:B6B8C17A-19FC-4A5A-BDA3-24C7E5A962B4@.microsoft.com...
> Will this be available in a future version?
> "Lev Semenets [MSFT]" wrote:
> > ARGB colors are not supported.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "CJ" <CJ@.newsgroup.nospam> wrote in message
> > news:E7870F65-DE71-4D39-9D47-748EB3FE7444@.microsoft.com...
> > >I am using SP1 and am trying to use the new custom color feature for
chart
> > > series.
> > > The problem is that I want to specify a transparent color (Alpha =50%).
> > > Is there any way of doing this? It seems that you can only enter
colors
> > > that
> > > have RGB values, not ARGB values. (The System.Drawing.Color.FromArgb
> > > function
> > > does not work in an expression).
> > > At the moment, I am using the Semi-Transparent palette, but would like
to
> > > choose the colors myself as opposed to having them chosen for me.
> > > --
> > > cj
> >
> >
> >

Custom Series Color in SP1 Charts

I'm trying to figure out how to create a custom series color in a bar chart,
and am unable to find documentation on it.
I read a post here on trying the Choose() function in the fill color portion
of the series value, but my chart goes gray in the layout mode, and then in
the preview mode it just shows the default colors.
Any documentation on this I can read?Keep in mind that expressions cannot be evaluated in design mode.
From the SP1 Readme about chart enhancements:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
"If you use an expression for fill color, the chart elements will be white
in Layout view, but will display properly when the report is run."
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:1AA68AB0-128E-44B2-8519-6357D7EBD465@.microsoft.com...
> I'm trying to figure out how to create a custom series color in a bar
chart,
> and am unable to find documentation on it.
> I read a post here on trying the Choose() function in the fill color
portion
> of the series value, but my chart goes gray in the layout mode, and then
in
> the preview mode it just shows the default colors.
> Any documentation on this I can read?|||That makes sense,
But still having an issue of what function to use in the fill color field.
I have
=IIf( Fields!descriptn.Value = "Self", "white","Transparent")
But it seems to ingore it.
"Robert Bruckner [MSFT]" wrote:
> Keep in mind that expressions cannot be evaluated in design mode.
> From the SP1 Readme about chart enhancements:
> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
> "If you use an expression for fill color, the chart elements will be white
> in Layout view, but will display properly when the report is run."
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Matt" <Matt@.discussions.microsoft.com> wrote in message
> news:1AA68AB0-128E-44B2-8519-6357D7EBD465@.microsoft.com...
> > I'm trying to figure out how to create a custom series color in a bar
> chart,
> > and am unable to find documentation on it.
> >
> > I read a post here on trying the Choose() function in the fill color
> portion
> > of the series value, but my chart goes gray in the layout mode, and then
> in
> > the preview mode it just shows the default colors.
> >
> > Any documentation on this I can read?
>
>|||There might be multiple issues here:
* A chart is similar to a matrix. Therefore a "cell" (datapoint) in a chart
can actually contain multiple rows depending on the groupings applied. Using
Fields!description.Value will always return the first value if multiple rows
are present.
If series groupings are present in the chart, you have to use
=First(Fields!description.Value, "NameOfInnermostSeriesGrouping") to get the
correct datapoint value in your expression. You might also want to check
this thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=15f4e34b-345a-4876-8cbe-734b9e4dfa53&sloc=en-us
* Transparent is not a valid color. The only exceptions are currently the
chart area and the plot area fill colors (it's on the wishlist for
extensions in a future release).
Since transparent is not valid color, it gets ignored and the default color
(from the palette) applies. If you want to "hide" entire
datapoints/categories, you can filter them. If you have a solid plotarea
background color you could also assign the plotarea color to hide
datapoints.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:917930D0-5D0E-4231-A6BD-1B58602D4D9F@.microsoft.com...
> That makes sense,
> But still having an issue of what function to use in the fill color field.
> I have
> =IIf( Fields!descriptn.Value = "Self", "white","Transparent")
> But it seems to ingore it.
> "Robert Bruckner [MSFT]" wrote:
> > Keep in mind that expressions cannot be evaluated in design mode.
> > From the SP1 Readme about chart enhancements:
> >
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
> > "If you use an expression for fill color, the chart elements will be
white
> > in Layout view, but will display properly when the report is run."
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Matt" <Matt@.discussions.microsoft.com> wrote in message
> > news:1AA68AB0-128E-44B2-8519-6357D7EBD465@.microsoft.com...
> > > I'm trying to figure out how to create a custom series color in a bar
> > chart,
> > > and am unable to find documentation on it.
> > >
> > > I read a post here on trying the Choose() function in the fill color
> > portion
> > > of the series value, but my chart goes gray in the layout mode, and
then
> > in
> > > the preview mode it just shows the default colors.
> > >
> > > Any documentation on this I can read?
> >
> >
> >|||We create one particular line chart in which the number of lines will be
different based on what the user selects when printing the report. They graph
the performance of their portfolio to that of 1-5 different indices. So the
chart will have between 2 and 6 different lines on it.
In the data tab of the chart, we have one item listed under values, one
under category groups, and one under series groups.
Everything works great. Our problem is that when there are so many lines
that the chart uses a Green and LightGreen color for two of the lines, our
client can't tell those two colors apart and wants us to use a different
color than LightGreen.
We have tried to use the various suggestions seen in this and other blogs to
customize the color but it doesn't work.
Can anyone help us? I can provide more info if needed.
This is what we have tried under
Edit Value=>Appearance=>Series Style=>Fill=>Color=>Expression:
=Choose(Fields!uv_port_type.Value,"Red","Blue","Green","Yellow","Purple","Orange")
=CStr(Choose(Fields!uv_port_type.Value,"Red","Blue","Green","Yellow","Purple","Orange"))
= Choose(First(Fields!uv_port_type.Value,
"dsUnitValues"),"Red","Blue","Green","Yellow","Purple","Orange")
= CStr(Choose(First(Fields!uv_port_type.Value,
"dsUnitValues"),"Red","Blue","Green","Yellow","Purple","Orange"))
(We also tried "IIF" statements.)
Thank you!
Jen
"Robert Bruckner [MSFT]" wrote:
> There might be multiple issues here:
> * A chart is similar to a matrix. Therefore a "cell" (datapoint) in a chart
> can actually contain multiple rows depending on the groupings applied. Using
> Fields!description.Value will always return the first value if multiple rows
> are present.
> If series groupings are present in the chart, you have to use
> =First(Fields!description.Value, "NameOfInnermostSeriesGrouping") to get the
> correct datapoint value in your expression. You might also want to check
> this thread:
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=15f4e34b-345a-4876-8cbe-734b9e4dfa53&sloc=en-us
> * Transparent is not a valid color. The only exceptions are currently the
> chart area and the plot area fill colors (it's on the wishlist for
> extensions in a future release).
> Since transparent is not valid color, it gets ignored and the default color
> (from the palette) applies. If you want to "hide" entire
> datapoints/categories, you can filter them. If you have a solid plotarea
> background color you could also assign the plotarea color to hide
> datapoints.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Matt" <Matt@.discussions.microsoft.com> wrote in message
> news:917930D0-5D0E-4231-A6BD-1B58602D4D9F@.microsoft.com...
> > That makes sense,
> >
> > But still having an issue of what function to use in the fill color field.
> >
> > I have
> >
> > =IIf( Fields!descriptn.Value = "Self", "white","Transparent")
> >
> > But it seems to ingore it.
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > Keep in mind that expressions cannot be evaluated in design mode.
> > > From the SP1 Readme about chart enhancements:
> > >
> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
> > > "If you use an expression for fill color, the chart elements will be
> white
> > > in Layout view, but will display properly when the report is run."
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Matt" <Matt@.discussions.microsoft.com> wrote in message
> > > news:1AA68AB0-128E-44B2-8519-6357D7EBD465@.microsoft.com...
> > > > I'm trying to figure out how to create a custom series color in a bar
> > > chart,
> > > > and am unable to find documentation on it.
> > > >
> > > > I read a post here on trying the Choose() function in the fill color
> > > portion
> > > > of the series value, but my chart goes gray in the layout mode, and
> then
> > > in
> > > > the preview mode it just shows the default colors.
> > > >
> > > > Any documentation on this I can read?
> > >
> > >
> > >
>
>|||I found the following on SQLJunkies.. Seems to work:
--
Need a custom palette for your charts? Embed the function below into your
report, and set the Data > Values > Appearance > Series Style > Fill to the
custom function =Code.SetColor. Replace the nnnn's below with the hex codes
you need. See http://www.321webmaster.com/colorconverter.php for an RGB to
hex converter online. And hug the Reporting Services developers for adding
custom color functionality into SP1.
Function SetColor As String
Static ColorCode as Integer
ColorCode = ColorCode + 1: If ColorCode > 5 then ColorCode = 1
Select Case ColorCode
Case 1:
SetColor = "#00nnnn" ' Bluish
Case 2:
SetColor = "#78nnnn" ' Greenish
Case 3:
SetColor = "#E2nnnn" ' Reddish
Case 4:
SetColor = "#00nnnn" ' Navyish
Case 4:
SetColor = "#CCnnnn" ' Yellowish
Case 5:
SetColor = "#00nnnn" ' Light Blueish
Case Else:
SetColor = "#000000" ' Black (placeholder)
End Select
End Function
--
I have a where I need to show an average value in bar graph, but how many
values went into that average is also important. I pull back a percentage in
the query and then created a function that based on a percentage, returns a
color. Added =Code.FunctionName(pct) to the series fill and voila!
George
"Jen Rubin" wrote:
> We create one particular line chart in which the number of lines will be
> different based on what the user selects when printing the report. They graph
> the performance of their portfolio to that of 1-5 different indices. So the
> chart will have between 2 and 6 different lines on it.
> In the data tab of the chart, we have one item listed under values, one
> under category groups, and one under series groups.
> Everything works great. Our problem is that when there are so many lines
> that the chart uses a Green and LightGreen color for two of the lines, our
> client can't tell those two colors apart and wants us to use a different
> color than LightGreen.
> We have tried to use the various suggestions seen in this and other blogs to
> customize the color but it doesn't work.
> Can anyone help us? I can provide more info if needed.
> This is what we have tried under
> Edit Value=>Appearance=>Series Style=>Fill=>Color=>Expression:
> => Choose(Fields!uv_port_type.Value,"Red","Blue","Green","Yellow","Purple","Orange")
> => CStr(Choose(Fields!uv_port_type.Value,"Red","Blue","Green","Yellow","Purple","Orange"))
> = Choose(First(Fields!uv_port_type.Value,
> "dsUnitValues"),"Red","Blue","Green","Yellow","Purple","Orange")
> = CStr(Choose(First(Fields!uv_port_type.Value,
> "dsUnitValues"),"Red","Blue","Green","Yellow","Purple","Orange"))
> (We also tried "IIF" statements.)
> Thank you!
> Jen
>
> "Robert Bruckner [MSFT]" wrote:
> > There might be multiple issues here:
> > * A chart is similar to a matrix. Therefore a "cell" (datapoint) in a chart
> > can actually contain multiple rows depending on the groupings applied. Using
> > Fields!description.Value will always return the first value if multiple rows
> > are present.
> > If series groupings are present in the chart, you have to use
> > =First(Fields!description.Value, "NameOfInnermostSeriesGrouping") to get the
> > correct datapoint value in your expression. You might also want to check
> > this thread:
> > http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=15f4e34b-345a-4876-8cbe-734b9e4dfa53&sloc=en-us
> >
> > * Transparent is not a valid color. The only exceptions are currently the
> > chart area and the plot area fill colors (it's on the wishlist for
> > extensions in a future release).
> > Since transparent is not valid color, it gets ignored and the default color
> > (from the palette) applies. If you want to "hide" entire
> > datapoints/categories, you can filter them. If you have a solid plotarea
> > background color you could also assign the plotarea color to hide
> > datapoints.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Matt" <Matt@.discussions.microsoft.com> wrote in message
> > news:917930D0-5D0E-4231-A6BD-1B58602D4D9F@.microsoft.com...
> > > That makes sense,
> > >
> > > But still having an issue of what function to use in the fill color field.
> > >
> > > I have
> > >
> > > =IIf( Fields!descriptn.Value = "Self", "white","Transparent")
> > >
> > > But it seems to ingore it.
> > >
> > > "Robert Bruckner [MSFT]" wrote:
> > >
> > > > Keep in mind that expressions cannot be evaluated in design mode.
> > > > From the SP1 Readme about chart enhancements:
> > > >
> > http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
> > > > "If you use an expression for fill color, the chart elements will be
> > white
> > > > in Layout view, but will display properly when the report is run."
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "Matt" <Matt@.discussions.microsoft.com> wrote in message
> > > > news:1AA68AB0-128E-44B2-8519-6357D7EBD465@.microsoft.com...
> > > > > I'm trying to figure out how to create a custom series color in a bar
> > > > chart,
> > > > > and am unable to find documentation on it.
> > > > >
> > > > > I read a post here on trying the Choose() function in the fill color
> > > > portion
> > > > > of the series value, but my chart goes gray in the layout mode, and
> > then
> > > > in
> > > > > the preview mode it just shows the default colors.
> > > > >
> > > > > Any documentation on this I can read?
> > > >
> > > >
> > > >
> >
> >
> >

Custom Semi-Transparent bar charts?

I know that SSRS 2005 has a built-in semi-transparent color chart palette, but I'd like to define my own custom color semi-transparent palette.

Brian Welker's blog (https://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx) has a terrific post on how to create your own custom color palette, but it generates solid colors. How can it be tweaked to create semi-transparent colors? Is there another function that needs to be created to define the transparency of the color palette?

Thanks in advance,

Pete

Sorry, semi-transparency cannot be achieved by defining your own custom color palette.

There are CustomReportItem-based chart add ins available for RS from third parties (such as Dundas and ChartFX) which will enable that kind of functionality in RS 2005.

-- Robert

|||

Bummer.

Can images be used in charts? (I doubt it, but thought I'd inquire.)

Thanks,
Pete

|||

Yes, you can use an image as a background image for the chart plotarea (select the chart and look for the BackgroundImage property in the VS properties window).

-- Robert

|||

I should have made my followup question clearer. I meant to ask if images can be used in the actual charting of values, for example to use an image of coins for bar charts whereby the bars on the chart are actually a "stack" of the coins. Or to use an image that gets "stretched" on the bars of a bargraph.

--Pete

|||

I believe the plug-in from Dundas ("Dundas Charts for Reporting Services") supports this, but you would need to check with them. It is not supported out of the box with the built-in charts.

-- Robert

|||

Transparency is more than possible with ANY system palette or custom palette.
The trick (work-around whatever) lies in modifying the 'alpha' component of the colour for each series in the chart AFTER they have had their colour assigned to them.

ie. i used the code

//set the transparency of the series
if(_abstractChart.Options.Transparency > 0) {
//get the transparency as a percentage
double transPerc = _abstractChart.Options.Transparency / 100.00;
//Alpha value 255 is opaque, 0 is transparent. set the transparency as a % of 255
int alphaValue = (int) (255 * (1-transPerc));
_chart.ApplyPaletteColors();
foreach(Series series in _chart.Series) {
series.Color = Color.FromArgb(alphaValue, series.Color.R, series.Color.G, series.Color.B);
}
}

where
-abstractChart.Options.Transparency is the integer value (between 0 and 100 inclusive) denoting the transparent %.
-_chart is a Dundas.Charting.WebControl.Chart

in my C# application, a percentage value is retrieved from the user from an aspx form. I subtract the tranparent component of the alpha value from the max (255) to get the Opacity, which is what i set in the colour. Giving the user 101 grades of tranparency (no pun intended).

HOWEVER, i actually have a problem. Though this method works fine for bar chart, radar, area line charts, it DOES NOT work for pie charts. The semi-transparent palette works for pie charts, but this method does not.

Perhaps someone with more knowledge of the dundas system could use my solution in the right place to achieve transparency for pie charts?

please?

I thought maybe using this method in Customize, PrePaint or PostPaint event would work. Havent had the chance to try it yet.
Cheers

|||

Okay, i figured it out.
A bar chart has one series object in the Dundas.Charting.WebControl.Chart.Series[] of the chart for every bar, so setting the colour of the series would apply to the bar which that series plots.
A pie chart has one series object for the whole chart, and the slices are individual datapoints within that series.
The solution quite simply is to add another level to the loop which iterates through every datapoint of the current series.
If processing time is a concern there should be a check present for whether the second loop is necessary (so far i have only found it necessary within PIE charts)
if(abstractChart.Options.Transparency > 0) {
//get the transparency as a percentage
double transPerc = abstractChart.Options.Transparency / 100.00;
//Alpha value 255 is opaque, 0 is transparent. set the transparency as a % of 255
int alphaValue = (int) (255 * (1-transPerc));
chart.ApplyPaletteColors();
foreach(Series series in chart.Series) {
if(abstractChart.GetChartType != ChartType.Pie) {
series.Color = Color.FromArgb(alphaValue, series.Color.R, series.Color.G, series.Color.B);
}
else{
foreach(DataPoint dp in series.Points) {
dp.Color = Color.FromArgb(alphaValue, dp.Color.R, dp.Color.G, dp.Color.B);
}
}
}
}
Where
-abstractChart.Options.Transparency is the integer value (between 0 and 100 inclusive) denoting the transparent %.
-_chart is a Dundas.Charting.WebControl.Chart
-abstractChart.ChartType is an identifier for the type of chart we are plotting (Abstract Chart is one of MY classes, as is ChartType)

By the way, this code is called after the chart object has been created, but before returning from the method which created the chart object.
IE.
public Dundas.Charting.WebControl.Chart MakeChart(){
Dundas.Charting.WebControl.Chart chart = new Dundas.Charting.WebControl.Chart();
..
..
..
..
<transparency code>
..
..
..
return chart;
}
any questions?
LiLbUg@.ozemate.com

|||

just an out of topic question: sorry because i need an answer really fast hope you understand....

Hi everyone,

I just inquiring if the 'My subscription' toolbar at the upper right portion of the report manager can be removed? or shall we say hide... If possible, how to remove please help...

Another question is when you click the show details button, the option to delete and move appears but it is initially disabled...is there a way also to hide the move button?

thank you very much...hope to have any response or advice as soon as possible...thanks

|||

Hello Thor:

Interesting... I'm a little confused, though. Is your code affecting the Dundas charting component or are you suggesting a way to create charting transparency in reporting services without the need for a third party add-in like Dundas (or ChartFX)?

Thanks,

Pete

|||

hey pete

yeh, not sure what you mean, theres alot of syllables in some of those words.
To try to answer your question; i'm using dundas, and the code i supplied directly changes the colour value for datapoint objects/series objects inside a DUNDAS chart. IE i assign a new colour for each datapoint/series in the code, in this case the new colour is the same as the old one (which is assigned from the palette) except the alpha value has been changed.
effectively, any palette can therefore have transparency applied to it, retaining the oiginal colours of the palette.
SO... i think the answer to your question is that this code NEEDS dundas and i affect the instance of the dundas charting component to create transparency.
but technically this should work for any charting tool that allows you to modify the colour of the datapoints in a series after they have been assigned a colour and before they are drawn.
ps. last time i ran my app. it changed the colour for the whole pie chart to the colour of the first datapoint. i think this code would have to be in the PrePaint event (its worked there before).
ill post again when i know for sure.

...Edit...
just read the top post again, and realised you're not using dundas. for some reason i thought this was all about dundas.
anyways, this should work for that charting thing you use IF you can change the colours of the series / datapoints at the right time. Might take some experimenting to figure out where, or even if you can do it.

sql

Custom palette in pie chart

Hi there!
I'v been trying to figure this out for a while, I have a Pie chart for
which I want to set the colors of the pies to my own defined colors.
The source dataset may contain 0 to 15 values, I've tried the folowing
solutions but none seem to work.
When column bouncetype is "HARD_BOUNCE" the pie should be green, etc...
=Switch
(
First(Fields!BounceType.Value,
"MailMessageBounceByType")="HARD_BOUNCE","GREEN",
First(Fields!BounceType.Value, "MailMessageBounceByType")="UNKNOWN","BLUE",
First(Fields!BounceType.Value,
"MailMessageBounceByType")="SPAM_NOTIFICATION","RED"
)
And also an iif statement.
=Iif(First(Fields!BounceType.Value,
"MailMessageBounceByType")="HARD_BOUNCE","GREEN",
Iif(First(Fields!BounceType.Value, "MailMessageBounceByType")="UNKNOWN",
"Red","Blue"))
Any ideas?If I have understoood correctly what you need is to set up colors in your
pie chart setting a color per group.
So, right click on the chart > Properties > Data Tab > Edit your value >
Appeareance tab > Series style > fill > Color > and the put the expression:
= iif(Fields!BounceType.Value, "HARD_BOUNCE","GREEN",
iif(Fields!BounceType.Value, "Red","Blue"))
"Peter Larsson" <scapecom@.hotmail.com> escribió en el mensaje
news:ellRTIHIIHA.3400@.TK2MSFTNGP03.phx.gbl...
> Hi there!
> I'v been trying to figure this out for a while, I have a Pie chart for
> which I want to set the colors of the pies to my own defined colors.
> The source dataset may contain 0 to 15 values, I've tried the folowing
> solutions but none seem to work.
> When column bouncetype is "HARD_BOUNCE" the pie should be green, etc...
> =Switch
> (
> First(Fields!BounceType.Value,
> "MailMessageBounceByType")="HARD_BOUNCE","GREEN",
> First(Fields!BounceType.Value,
> "MailMessageBounceByType")="UNKNOWN","BLUE",
> First(Fields!BounceType.Value,
> "MailMessageBounceByType")="SPAM_NOTIFICATION","RED"
> )
> And also an iif statement.
> =Iif(First(Fields!BounceType.Value,
> "MailMessageBounceByType")="HARD_BOUNCE","GREEN",
> Iif(First(Fields!BounceType.Value, "MailMessageBounceByType")="UNKNOWN",
> "Red","Blue"))
> Any ideas?|||Hi Monica, thanks for your reply!
Well, that's exactly what I did. ;)
I solved it though, by putting code in the Code-Tab, it's a smoother
solution I think.
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
Regards,
Peter Larsson
Mónica wrote:
> If I have understoood correctly what you need is to set up colors in your
> pie chart setting a color per group.
> So, right click on the chart > Properties > Data Tab > Edit your value >
> Appeareance tab > Series style > fill > Color > and the put the expression:
> = iif(Fields!BounceType.Value, "HARD_BOUNCE","GREEN",
> iif(Fields!BounceType.Value, "Red","Blue"))
>
> "Peter Larsson" <scapecom@.hotmail.com> escribió en el mensaje
> news:ellRTIHIIHA.3400@.TK2MSFTNGP03.phx.gbl...
>> Hi there!
>> I'v been trying to figure this out for a while, I have a Pie chart for
>> which I want to set the colors of the pies to my own defined colors.
>> The source dataset may contain 0 to 15 values, I've tried the folowing
>> solutions but none seem to work.
>> When column bouncetype is "HARD_BOUNCE" the pie should be green, etc...
>> =Switch
>> (
>> First(Fields!BounceType.Value,
>> "MailMessageBounceByType")="HARD_BOUNCE","GREEN",
>> First(Fields!BounceType.Value,
>> "MailMessageBounceByType")="UNKNOWN","BLUE",
>> First(Fields!BounceType.Value,
>> "MailMessageBounceByType")="SPAM_NOTIFICATION","RED"
>> )
>> And also an iif statement.
>> =Iif(First(Fields!BounceType.Value,
>> "MailMessageBounceByType")="HARD_BOUNCE","GREEN",
>> Iif(First(Fields!BounceType.Value, "MailMessageBounceByType")="UNKNOWN",
>> "Red","Blue"))
>> Any ideas?
>

Custom names for summary fields

Using Crystal Reports 8.5 I have created a report which displays a pie chart of the column totals in a report. Unfortunately the names of the summary fields are used as labels for the pie chart slices and they are ugly - things like "sum qryOrders.OrderValue". Is there a way to replace these labels with my own choice of text?From the deafening silence, the answer appears to be 'No'. In case anyone else has the same issue, here is a workaround. Suppress the display of pie slice labels. Suppress the display of the chart legend. Create your own legend box using the basic drawing tools - filled rectangles - and add your own text labels.|||For the sake of future Googlers; I too was having this problem, and I had given up when I realized that if you sort "in specified order", you can then set up your "Named Groups" such that the "Group Name" is the name that you wish to have displayed.

For example, the formula for one of my named groups is "@.Allocation" "is equal to" "International Equity", and the name of the group is "Int'l Equity".

Works like a charm, sorry I'm too late to help you.|||Well, within a couple of minutes of posting, I realized that this only works if you have only one field to show a value for. So, it's not going to work where I really need it to, but still, it's useful elsewhere.

Custom Code in Chart - background color

I have the following very simple code block that I wrote for a chart.
public function bdr_chartcolor(xType as string) as string
IF xType = "IR"
return "White"
ELSE
return "Blue"
END IF
end function
HOW and WHERE do I implement it to set the charts background color? Many
properties of objects have EXPRESSION as an option, HOWEVER, there is no
EXPRESSION as a type for a chart's background color in the properties.Chart area, Fill.
"MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
wrote in message news:22B72235-5282-4095-951F-9B9DCF89E0B3@.microsoft.com...
>I have the following very simple code block that I wrote for a chart.
> public function bdr_chartcolor(xType as string) as string
> IF xType = "IR"
> return "White"
> ELSE
> return "Blue"
> END IF
> end function
> HOW and WHERE do I implement it to set the charts background color? Many
> properties of objects have EXPRESSION as an option, HOWEVER, there is no
> EXPRESSION as a type for a chart's background color in the properties.|||Sorry,
plot area, fill.
There are two, the area outside the chart plot area and the area inside the
chart plot area.
Use Code.bdf_chartcolor(...) in the expression editor.
"MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
wrote in message news:22B72235-5282-4095-951F-9B9DCF89E0B3@.microsoft.com...
>I have the following very simple code block that I wrote for a chart.
> public function bdr_chartcolor(xType as string) as string
> IF xType = "IR"
> return "White"
> ELSE
> return "Blue"
> END IF
> end function
> HOW and WHERE do I implement it to set the charts background color? Many
> properties of objects have EXPRESSION as an option, HOWEVER, there is no
> EXPRESSION as a type for a chart's background color in the properties.

Custom Charts...

Does reporting services currently allow me to write my own particular chart
that will appear inline int he report as the stock reports do?
reports and reports, but I would like to have some specific views that arent
in the chart selection.
Thanks in advance
Weston WeemsThere are several options:
* RS 2000:
You could draw your chart in a custom assembly and retrieve the value via
the Image.Value expression. Note: the custom assembly would be responsible
to retrieve all the data needed to draw the chart.
If you search the archives of this newsgroup you should find some related
postings from me and other people about how to do this.
* RS 2005:
In addition to what you can do on RS 2000, you could take advantage of the
new CustomReportItem feature and write your own custom processing control.
In this case, you could leverage the capabilities of the RS processing
engine to retrieve, group, sort, filter the data for you and the custom
processing control can read the already processed data through an object
model and then draw the chart image and return it as Image "rendering item".
More information and samples about this will be available when SQL Server
2005 is going to be released.
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Weston Weems" <wweems@.NOSPAMno-span-gmail.com> wrote in message
news:%23lzKjnWXFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Does reporting services currently allow me to write my own particular
> chart that will appear inline int he report as the stock reports do?
> reports and reports, but I would like to have some specific views that
> arent in the chart selection.
> Thanks in advance
> Weston Weems
>

Custom Chart Colours

Hi,

Could anybody tell me if in reporting services you can choose custom colours for the chart elements. The only way i can see to do it is with the standard built in colour palettes, but i have a requirement to set the colours specifically.

If it is not possible, does anyone at MS know if it is planned for the near future, and when would could expext to see it?

Many thanks

Matt

You can use any RGB combinatin for the Fill field like "#a0002f"

|||

This can be doen easily read this great article on msdn

http://msdn2.microsoft.com/en-us/library/aa964128.aspx#moressrscharts_topic3

Custom Bar Chart colors?

I am also looking for a way to specify my own list of colors for bars in a
bar chart. Please let me know if anyone has a solution for this.
Thanks Again,
AndyHowdy,
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
(Courtesy of Brian Welcker)
HTH,
Sean G.

Custom assembilies in the Dundas Controls

Hi,

Currently I am using SSRS 2005 and the Dundas Map and Chart controls.

I have been doing extensive customization with these controls thru custom assembilies / DLL's written in C#.

For the upcoming integration of the controls into SSRS 2008, will the same amount of extensibility be available?

Thanks!

Do I need to provide an example of this?

Would that help my post get a response?

Thanks!

|||

(bump)

Could someone let me know about this?

I wouldn't mind posting something to make a case for it.

Thanks,

-Don

|||

Can someone please respond to this?

Thanks,

-Don

|||

Don, could you provide an example of what properties you have customized, what kind of functionality is performed within your customizations?

-- Robert

|||

Hi Robert,

I use all the Dundas controls, but I have currently only customized two, Chart and Map.

With either of them I am creating a C# dll and linking to it via the "Custom Assemblies" tab.

For the Chart control, I create pareto lines, create shaded areas based on data and insert simple graphics for navigation/drill thru's to other reports.

The bulk of my customization has been done with the map control.

For one of my clients (a large real estate developer) I created ESRI compliant shapefiles that represent each home in a subdivision. These are loaded based on user selections, showing the status of sales or any metric the user chooses.

I recently have started reporting sales and marketing data using the map control and the US maps included with it. I'm also using shapes representing zipcode areas to show geographic locations of customers, etc etc.

With both the map and chart control, one of the most if not the most powerful feature IMO is the ability for me to get a reference to the actual graphics object and draw directly into it using C# and GDI+. Also, Dundas exposing the render cycle in many stages allows me a ton of flexibility in my control over the render process.

While I completely welcome your team integrating the Dundas controls into SSRS (the dialogs for the chart control in 2000 & 2005 were much better than the Dundas dialogs IMO), it would be really awesome if you could either improve on the extensibility via .dll's as I have previously mentioned or leave the existing functionality there with no changes.

I know I probably one of a few folks that are using the controls in this way but I feel confident that if the extensibility were to remain in the controls for SSRS 2008/Katmai that you would quickly have a die hard group of new users taking advantage of this.

Every client I have showed the custom map stuff to has been extremely surprised the ease that it can be customized (new shapes/shapefiles etc). It has been a dealmaker. The maps have been so effective it's lead to many clients of mine purchasing the Dundas suite simply for the map control (and these are clients that do not normally purchase 3rd party controls).

Please feel free to contact me directly if you feel any of this needs more explanation, I would be happy to go over it and provide any examples that you may need.

Thanks!

-Don

|||

We appreciate the feedback and take it into account.

At this point however it is a bit too early to make definitive statements if it is going to fit in SSRS 2008.

-- Robert

|||

Hi Robert,

Does this mean that the Dundas Map & Chart may not make it into SSRS 2008?

Thanks!

-Don

Custom assembilies in the Dundas Controls

Hi,

Currently I am using SSRS 2005 and the Dundas Map and Chart controls.

I have been doing extensive customization with these controls thru custom assembilies / DLL's written in C#.

For the upcoming integration of the controls into SSRS 2008, will the same amount of extensibility be available?

Thanks!

Do I need to provide an example of this?

Would that help my post get a response?

Thanks!

|||

(bump)

Could someone let me know about this?

I wouldn't mind posting something to make a case for it.

Thanks,

-Don

|||

Can someone please respond to this?

Thanks,

-Don

|||

Don, could you provide an example of what properties you have customized, what kind of functionality is performed within your customizations?

-- Robert

|||

Hi Robert,

I use all the Dundas controls, but I have currently only customized two, Chart and Map.

With either of them I am creating a C# dll and linking to it via the "Custom Assemblies" tab.

For the Chart control, I create pareto lines, create shaded areas based on data and insert simple graphics for navigation/drill thru's to other reports.

The bulk of my customization has been done with the map control.

For one of my clients (a large real estate developer) I created ESRI compliant shapefiles that represent each home in a subdivision. These are loaded based on user selections, showing the status of sales or any metric the user chooses.

I recently have started reporting sales and marketing data using the map control and the US maps included with it. I'm also using shapes representing zipcode areas to show geographic locations of customers, etc etc.

With both the map and chart control, one of the most if not the most powerful feature IMO is the ability for me to get a reference to the actual graphics object and draw directly into it using C# and GDI+. Also, Dundas exposing the render cycle in many stages allows me a ton of flexibility in my control over the render process.

While I completely welcome your team integrating the Dundas controls into SSRS (the dialogs for the chart control in 2000 & 2005 were much better than the Dundas dialogs IMO), it would be really awesome if you could either improve on the extensibility via .dll's as I have previously mentioned or leave the existing functionality there with no changes.

I know I probably one of a few folks that are using the controls in this way but I feel confident that if the extensibility were to remain in the controls for SSRS 2008/Katmai that you would quickly have a die hard group of new users taking advantage of this.

Every client I have showed the custom map stuff to has been extremely surprised the ease that it can be customized (new shapes/shapefiles etc). It has been a dealmaker. The maps have been so effective it's lead to many clients of mine purchasing the Dundas suite simply for the map control (and these are clients that do not normally purchase 3rd party controls).

Please feel free to contact me directly if you feel any of this needs more explanation, I would be happy to go over it and provide any examples that you may need.

Thanks!

-Don

|||

We appreciate the feedback and take it into account.

At this point however it is a bit too early to make definitive statements if it is going to fit in SSRS 2008.

-- Robert

|||

Hi Robert,

Does this mean that the Dundas Map & Chart may not make it into SSRS 2008?

Thanks!

-Don

Custom assembilies in the Dundas Controls

Hi,

Currently I am using SSRS 2005 and the Dundas Map and Chart controls.

I have been doing extensive customization with these controls thru custom assembilies / DLL's written in C#.

For the upcoming integration of the controls into SSRS 2008, will the same amount of extensibility be available?

Thanks!

Do I need to provide an example of this?

Would that help my post get a response?

Thanks!

|||

(bump)

Could someone let me know about this?

I wouldn't mind posting something to make a case for it.

Thanks,

-Don

|||

Can someone please respond to this?

Thanks,

-Don

|||

Don, could you provide an example of what properties you have customized, what kind of functionality is performed within your customizations?

-- Robert

|||

Hi Robert,

I use all the Dundas controls, but I have currently only customized two, Chart and Map.

With either of them I am creating a C# dll and linking to it via the "Custom Assemblies" tab.

For the Chart control, I create pareto lines, create shaded areas based on data and insert simple graphics for navigation/drill thru's to other reports.

The bulk of my customization has been done with the map control.

For one of my clients (a large real estate developer) I created ESRI compliant shapefiles that represent each home in a subdivision. These are loaded based on user selections, showing the status of sales or any metric the user chooses.

I recently have started reporting sales and marketing data using the map control and the US maps included with it. I'm also using shapes representing zipcode areas to show geographic locations of customers, etc etc.

With both the map and chart control, one of the most if not the most powerful feature IMO is the ability for me to get a reference to the actual graphics object and draw directly into it using C# and GDI+. Also, Dundas exposing the render cycle in many stages allows me a ton of flexibility in my control over the render process.

While I completely welcome your team integrating the Dundas controls into SSRS (the dialogs for the chart control in 2000 & 2005 were much better than the Dundas dialogs IMO), it would be really awesome if you could either improve on the extensibility via .dll's as I have previously mentioned or leave the existing functionality there with no changes.

I know I probably one of a few folks that are using the controls in this way but I feel confident that if the extensibility were to remain in the controls for SSRS 2008/Katmai that you would quickly have a die hard group of new users taking advantage of this.

Every client I have showed the custom map stuff to has been extremely surprised the ease that it can be customized (new shapes/shapefiles etc). It has been a dealmaker. The maps have been so effective it's lead to many clients of mine purchasing the Dundas suite simply for the map control (and these are clients that do not normally purchase 3rd party controls).

Please feel free to contact me directly if you feel any of this needs more explanation, I would be happy to go over it and provide any examples that you may need.

Thanks!

-Don

|||

We appreciate the feedback and take it into account.

At this point however it is a bit too early to make definitive statements if it is going to fit in SSRS 2008.

-- Robert

|||

Hi Robert,

Does this mean that the Dundas Map & Chart may not make it into SSRS 2008?

Thanks!

-Don

Custom assembilies in the Dundas Controls

Hi,

Currently I am using SSRS 2005 and the Dundas Map and Chart controls.

I have been doing extensive customization with these controls thru custom assembilies / DLL's written in C#.

For the upcoming integration of the controls into SSRS 2008, will the same amount of extensibility be available?

Thanks!

Do I need to provide an example of this?

Would that help my post get a response?

Thanks!

|||

(bump)

Could someone let me know about this?

I wouldn't mind posting something to make a case for it.

Thanks,

-Don

|||

Can someone please respond to this?

Thanks,

-Don

|||

Don, could you provide an example of what properties you have customized, what kind of functionality is performed within your customizations?

-- Robert

|||

Hi Robert,

I use all the Dundas controls, but I have currently only customized two, Chart and Map.

With either of them I am creating a C# dll and linking to it via the "Custom Assemblies" tab.

For the Chart control, I create pareto lines, create shaded areas based on data and insert simple graphics for navigation/drill thru's to other reports.

The bulk of my customization has been done with the map control.

For one of my clients (a large real estate developer) I created ESRI compliant shapefiles that represent each home in a subdivision. These are loaded based on user selections, showing the status of sales or any metric the user chooses.

I recently have started reporting sales and marketing data using the map control and the US maps included with it. I'm also using shapes representing zipcode areas to show geographic locations of customers, etc etc.

With both the map and chart control, one of the most if not the most powerful feature IMO is the ability for me to get a reference to the actual graphics object and draw directly into it using C# and GDI+. Also, Dundas exposing the render cycle in many stages allows me a ton of flexibility in my control over the render process.

While I completely welcome your team integrating the Dundas controls into SSRS (the dialogs for the chart control in 2000 & 2005 were much better than the Dundas dialogs IMO), it would be really awesome if you could either improve on the extensibility via .dll's as I have previously mentioned or leave the existing functionality there with no changes.

I know I probably one of a few folks that are using the controls in this way but I feel confident that if the extensibility were to remain in the controls for SSRS 2008/Katmai that you would quickly have a die hard group of new users taking advantage of this.

Every client I have showed the custom map stuff to has been extremely surprised the ease that it can be customized (new shapes/shapefiles etc). It has been a dealmaker. The maps have been so effective it's lead to many clients of mine purchasing the Dundas suite simply for the map control (and these are clients that do not normally purchase 3rd party controls).

Please feel free to contact me directly if you feel any of this needs more explanation, I would be happy to go over it and provide any examples that you may need.

Thanks!

-Don

|||

We appreciate the feedback and take it into account.

At this point however it is a bit too early to make definitive statements if it is going to fit in SSRS 2008.

-- Robert

|||

Hi Robert,

Does this mean that the Dundas Map & Chart may not make it into SSRS 2008?

Thanks!

-Don

Custom assembilies in the Dundas Controls

Hi,

Currently I am using SSRS 2005 and the Dundas Map and Chart controls.

I have been doing extensive customization with these controls thru custom assembilies / DLL's written in C#.

For the upcoming integration of the controls into SSRS 2008, will the same amount of extensibility be available?

Thanks!

Do I need to provide an example of this?

Would that help my post get a response?

Thanks!

|||

(bump)

Could someone let me know about this?

I wouldn't mind posting something to make a case for it.

Thanks,

-Don

|||

Can someone please respond to this?

Thanks,

-Don

|||

Don, could you provide an example of what properties you have customized, what kind of functionality is performed within your customizations?

-- Robert

|||

Hi Robert,

I use all the Dundas controls, but I have currently only customized two, Chart and Map.

With either of them I am creating a C# dll and linking to it via the "Custom Assemblies" tab.

For the Chart control, I create pareto lines, create shaded areas based on data and insert simple graphics for navigation/drill thru's to other reports.

The bulk of my customization has been done with the map control.

For one of my clients (a large real estate developer) I created ESRI compliant shapefiles that represent each home in a subdivision. These are loaded based on user selections, showing the status of sales or any metric the user chooses.

I recently have started reporting sales and marketing data using the map control and the US maps included with it. I'm also using shapes representing zipcode areas to show geographic locations of customers, etc etc.

With both the map and chart control, one of the most if not the most powerful feature IMO is the ability for me to get a reference to the actual graphics object and draw directly into it using C# and GDI+. Also, Dundas exposing the render cycle in many stages allows me a ton of flexibility in my control over the render process.

While I completely welcome your team integrating the Dundas controls into SSRS (the dialogs for the chart control in 2000 & 2005 were much better than the Dundas dialogs IMO), it would be really awesome if you could either improve on the extensibility via .dll's as I have previously mentioned or leave the existing functionality there with no changes.

I know I probably one of a few folks that are using the controls in this way but I feel confident that if the extensibility were to remain in the controls for SSRS 2008/Katmai that you would quickly have a die hard group of new users taking advantage of this.

Every client I have showed the custom map stuff to has been extremely surprised the ease that it can be customized (new shapes/shapefiles etc). It has been a dealmaker. The maps have been so effective it's lead to many clients of mine purchasing the Dundas suite simply for the map control (and these are clients that do not normally purchase 3rd party controls).

Please feel free to contact me directly if you feel any of this needs more explanation, I would be happy to go over it and provide any examples that you may need.

Thanks!

-Don

|||

We appreciate the feedback and take it into account.

At this point however it is a bit too early to make definitive statements if it is going to fit in SSRS 2008.

-- Robert

|||

Hi Robert,

Does this mean that the Dundas Map & Chart may not make it into SSRS 2008?

Thanks!

-Don

Custom assembilies in the Dundas Controls

Hi,

Currently I am using SSRS 2005 and the Dundas Map and Chart controls.

I have been doing extensive customization with these controls thru custom assembilies / DLL's written in C#.

For the upcoming integration of the controls into SSRS 2008, will the same amount of extensibility be available?

Thanks!

Do I need to provide an example of this?

Would that help my post get a response?

Thanks!

|||

(bump)

Could someone let me know about this?

I wouldn't mind posting something to make a case for it.

Thanks,

-Don

|||

Can someone please respond to this?

Thanks,

-Don

|||

Don, could you provide an example of what properties you have customized, what kind of functionality is performed within your customizations?

-- Robert

|||

Hi Robert,

I use all the Dundas controls, but I have currently only customized two, Chart and Map.

With either of them I am creating a C# dll and linking to it via the "Custom Assemblies" tab.

For the Chart control, I create pareto lines, create shaded areas based on data and insert simple graphics for navigation/drill thru's to other reports.

The bulk of my customization has been done with the map control.

For one of my clients (a large real estate developer) I created ESRI compliant shapefiles that represent each home in a subdivision. These are loaded based on user selections, showing the status of sales or any metric the user chooses.

I recently have started reporting sales and marketing data using the map control and the US maps included with it. I'm also using shapes representing zipcode areas to show geographic locations of customers, etc etc.

With both the map and chart control, one of the most if not the most powerful feature IMO is the ability for me to get a reference to the actual graphics object and draw directly into it using C# and GDI+. Also, Dundas exposing the render cycle in many stages allows me a ton of flexibility in my control over the render process.

While I completely welcome your team integrating the Dundas controls into SSRS (the dialogs for the chart control in 2000 & 2005 were much better than the Dundas dialogs IMO), it would be really awesome if you could either improve on the extensibility via .dll's as I have previously mentioned or leave the existing functionality there with no changes.

I know I probably one of a few folks that are using the controls in this way but I feel confident that if the extensibility were to remain in the controls for SSRS 2008/Katmai that you would quickly have a die hard group of new users taking advantage of this.

Every client I have showed the custom map stuff to has been extremely surprised the ease that it can be customized (new shapes/shapefiles etc). It has been a dealmaker. The maps have been so effective it's lead to many clients of mine purchasing the Dundas suite simply for the map control (and these are clients that do not normally purchase 3rd party controls).

Please feel free to contact me directly if you feel any of this needs more explanation, I would be happy to go over it and provide any examples that you may need.

Thanks!

-Don

|||

We appreciate the feedback and take it into account.

At this point however it is a bit too early to make definitive statements if it is going to fit in SSRS 2008.

-- Robert

|||

Hi Robert,

Does this mean that the Dundas Map & Chart may not make it into SSRS 2008?

Thanks!

-Don

Custom Annotations on SRS 2000 charts

I would like to be able to put custom annotations on charts. Specifically I have a line chart I want to annotate. I don't want to indicate all plot points, just areas of interest. For example, on one of our line charts there is a value for a week (weeks are the x-Axis) that is way out of whack with other weeks. I would like to be able to display only that value, circle that location on the chart and create a custom note so that when the report displays, all users can see it.

All I've been able to find that I can customize on SRS line charts is to add all plot points and be able to change their shape and color and font size. I want to be able to do way more than that with annotations. Is it possible? I have .NET programming abilities so I'd be willing to write code to do it, I just can't find any examples of how I can write custom code to do things like this.

Thanks for any help!

Mary

You may need to look at a 3rd-party charting tool such as Dundas Charts for Reporting Services. Unfortunately these are only available with RS 2005.

cheers,

Andrew

|||We purchased Chart FX for Reporting Services and it works like a charm, but this is for RS2005 http://www.softwarefx.com/SfxSqlProducts/cfxReportingServices/ . But I think there is not a version for RS2000 anywhere in the market... Sorry I cannot help much on this one.