Having Custom Legend To Pie Charts
Aug 26, 2007
Hi All,
what I want is a custom Legend for the Pie Chart.
I have followed this article and have done what was written under
Custom Chart Color Palettes and Legends
http://msdn2.microsoft.com/en-us/library/aa964128.aspx#moressrscharts_topic4
But still the color of the legend is not uniform.
Basically I am using a stored procedure which returns two values : Circle, Total based on a parameter called Customer.
1. I have pasted the code asked in the Code Section of the report.
2. Have Disabled the 'Show Legend' box in Chart Properties.
3. Have included the following code in the Values->Appearance->Series Styel->Fill
=Code.GetColor(Fields!Circle.Value)
4. In the Category groups ->Group on-> this is my expression =Fields!Circle.Value (Basically I am not sure where
should I include Circle Field. I have tried this both by putting it in Category Groups and Series Groups.)
5. Dragged and dropped new table and have done the following
a.table1->Properties->Groups->Add->General->Group on Expression Fields!Circle.Value
b.Deleted Detail row.
c.Dragged and dropped rectangle in the column value and set the background value to =Code.GetColor(Fields!Circle.Value)
When I run the report for different customers the colors are not remaining constant. I have 17 values for Circles. So included three more colors in the "colorPalette " variable..
After doing all this still I am not able to get the same colors. Could someone tell me where I am going wrong?
View 1 Replies
ADVERTISEMENT
Oct 23, 2015
I was trying to write a custom legend text for a chart that I have in SSRS. In the chart I have a Bar chart and a Line chart. I have two values coming from a dataset. One is a running value. All the series values are from year dataset.
I need to get a custom legend text for the three data series looking like this. "2013- Mth", "2014-Mth". Year should be dynamic and coming from the dataset.
I tried writing an expression in the series legend option as shown below.
But I don't get the required text for the chart. I only get the default series text for the legend. If I only write a text without the dynamic year taken from the dataset columns I get the custom text. But not when I concatenate the dynamic year series with the static text. Any property to enable/disable?
View 2 Replies
View Related
Feb 12, 2007
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
View 2 Replies
View Related
May 30, 2007
I need some help regarding Custom Colors implementation for Charts in the Reporting Services.
What we are trying to do is to make every color for every Series(see example below) to be a customized Corporate color.
For example each of the series on the Chart should be in specific Custom Color:
Series 1 - "LightBlue"
Series 2 - "LightYellow"
Series 3 - "DarkBrown"
All I found from MSDN is how to do it in the Chart Properties in a Code section (right click on the report outside the chart -> Properties -> Code tab -> paste the Custom Code ).
And then to use it in the Chart color definition as:
Code Snippet=Code.GetColor( Series# )
But we are trying to do it in a separate C# class that would be updated only in one place, instead of changing 30 reports each time something is changed. So that it could be generic.
The C# class:
Code Snippet
namespace CustomColorPalette
{
public class CustomPalette
{
public CustomPalette()
{
}
public static string GetColor(string GroupingValue)
{
int groupingValue = int.Parse(GroupingValue);
string[] colorPalette = {"Green", "Blue", "Red"};
if (groupingValue < colorPalette.Length)
{
return colorPalette.GetValue(groupingValue).ToString();
}
else
{
return "Black"; // if # of Series is more than defined - all undefined will be = Black color
}
}
}
}
I tried 2 different ways:
1.
Then I put a code into a Custom Code section of a report:
Code Snippet
Public Function GetColor(SeriesNumber as String)
Return CustomColorPalette.CustomPalette.GetColor(SeriesNumber)
End Function
And in the Chart Custom Color settings I put:
Code Snippet=Code.GetColor( Fields!SeriesNumber.Value )
And after compilation I get an error:
Error 303 [rsCompilerErrorInCode] There is an error on line 2 of custom code: [BC30451] Name 'CustomColorPalette' is not declared. c:developmentvoyagerreportsvoyager convert reports.rootvoyager convert reportsReport_007D.rdl 0 0
2.
Second way I tried:
Then I put a code into a Custom Code section of a report:
Code Snippet
Dim X As CustomColorPalette.CustomPalette
Protected Overrides Sub OnInit()
X = new CustomColorPalette.CustomPalette()
End Sub
And in the Chart Custom Color I put:
Code Snippet=Code.X.GetColor( Fields!SeriesNumber.Value )
And after compilation I am getting an error like this:
Error 302 [rsCompilerErrorInExpression] The BackgroundColor expression for the chart €˜chart2€™ contains an error: [BC30456] 'X' is not a member of 'ReportExprHostImpl.CustomCodeProxy'. c:developmentvoyagerreportsvoyager convert reports.rootvoyager convert reportsReport_007D.rdl 0 0
Is there any workaround? Or all I can do is to make the Custom Colors manually in each report, and if something need to be changed - I will need to change it in each report separately
Thanks,
Alex
View 5 Replies
View Related
Aug 9, 2007
I have a chart and i am populating it from a sproc.
In the Legend i am getting InvestmentPercent.Value- InvestmentName.Value - InvestmentPercent.Value
How can I just display InvestmentPercent.Value - InvestmentName.value
In the graph it looks
3- cash -3
38 - FixedIncome -38
how can I set this thing right...
Regards
Karen
View 8 Replies
View Related
Apr 16, 2008
I have added a pie chart to my report but the legend is not wide enough. Is there a way of altering the width of the legend?
View 1 Replies
View Related
Jan 9, 2007
I have few chart based reports where I am showing different costs in series. I want to fix the colour of each type of cost so that I can maintain the same colour for each cost in different reports.
Is it possible?? If yes, then please let me know.
Thanks in advance!!!
View 1 Replies
View Related
May 7, 2008
.......I need to know how to have that displayed before the reports are ran. I'd like to have in the Report Parameters area so users can see this information when making choices for the reports.
View 1 Replies
View Related
Jul 17, 2006
Hi,
I am having trouble really understanding what makes a model accurate and effective at predicting some attribute. I can't seem to find any clear documentation about the mining legend of the lift chart on the Mining Accuracy Chart tab when working with the Data Mining Structure designer in VS 2005. Specifically, I would like to know more about what numbers in the Score, Population Correct and Predict Probability columns mean, and why they change when you move the vertical gray bar on the Lift Chart. Also, what is generally a good score to be aiming for, provided that it is highly difficult to get 100% accuracy with the kind of data that I am using.
Any more information on this subject is much appreciated. Thank you for your time,
Chris Burns
View 1 Replies
View Related
Jan 17, 2007
I am trying to develop a report that will show a 100% stacked bar graph for many teachers. Each teacher will have there own graph. The series in the report are the percent of scores given on a test, with each test in a group. Scores are given on a scale of 1-4. Most of the time a teacher will have all fours scores in there data; however it is possible to only have 2 or 3 of the scores. How can I set the legend up so that all scores across all the graphs show the same color for the same data series? Right now I get something like this.
First Graph
4: Lime
3: Purple
2: Blue
1: Green
Second Graph (no values for 1 or 2)
4: Blue
3: Green
I need the second graph to be
4: Lime
3: Purple
View 5 Replies
View Related
Sep 1, 2015
I have a Pie Chart report that works well until Users discovered that when values are 0% or less across the chart, the Legend returns NaN. How do I format the Legend to return 0% instead of the NaN that Users do not want to see. Below is my express for the Legend Property="#AXISLABEL" & " - " & "#PERCENT{P0}".
View 5 Replies
View Related
Mar 8, 2007
Hi,
I am creating a custom transformation component, and a custom user interface for that component.
In
my custom UI, I want to show the custom properties, and allow users to
edit these properties similar to how the advanced editor shows the
properties.
I know in my UI I need to create a "Property Grid".
In
the properties of this grid, I can select the object I want to display
data for, however, the only objects that appear are the objects that I
have already created within this UI, and not the actual component
object with the custom properties.
How do I go about getting the properties for my transformation component listed in this property grid?
I am writing in C#.
View 5 Replies
View Related
Aug 4, 2006
After days of trying to deploy my web application along with the ASPNETDB database I am convinced this is actually just an attempt on the part of the MSFT developers to drive us nuts.
It simply will not work. As reported by everyone in all of the forums, it works fine in development but does not work when deployed. If I move my data to a full SQL Server instance and modify all of my connection strings accordingly, it works fine, as well. It just does not work when I publish the app and try to run it using the AttachDBFilename methodology. I am convinced that only Santa Claus or an honest lawyer can make it work.
Let's recap the steps: first, I create the folder that I want to use for production and give Modify permissions on that folder to <machine>ASPNET and NETWORK SERVICE. Then I open up IIS Administrator and create a new virtual directory that points to that folder and set its permissions to include Write. I check the ASP.NET tab and it's set for 2.0. Now I switch back to VS2005 and publish my web application directly to the target folder.
Feeling optimistic, I go right to IE and bring up the site. Looks good until I attempt to login. That's when I get the first error - Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.
From there I start through the forums and try every one of the solutions proposed, even though none of them specifically identify this error wording. I know I should have used the wording from the Exception "Details" - except they state exactly the same thing - what was I thinking? I thought the .NET developers did away with the error message authors from the old days but it looks like they're back with a vengence.
Somewhere along the way I am able to get past that first error. Unfortunately, I've made so many changes I don't know which combination actually worked. But it doesn't matter because now the database is refusing to let <machine>ASPNET login! Okay, so I use SSME and create a login attach the database and create a user (none of which is supposed to be required for UserInstance=true). Detach the database and try IE again. You guessed it - still won't work. Now it can't generate the user instance because a database by that name already exists, or the user doesn't have permissions, or it's Friday and the machine wants to leave early - I give up.
So, at this point, I'm pretty much finished with SQLExpress for anything other than my development environment.
View 2 Replies
View Related
Jun 10, 2009
Is there anyway in SSRS 2008 to sort the Legend on a chart? Right now I am unsure as to how it is currently sorting. I see a property to Reverse the order, but I don't see anything to alphabetize it.
View 8 Replies
View Related
Jun 22, 2015
Is it possible to remove the tick marks that I have circled in red?The chart has data Week by week over a year, and the T1, T2 etc are equivalent to Quarter1, Quarter 2 etcI've got a 3 level grouping, with the top level being Year, then Quarter, then Week. The label for the "Week" grouping is set to blank, and that's why you don't see it here.Removing the Tick marks would make the chart legend more readable in my opinion.
View 2 Replies
View Related
Aug 14, 2007
Hi,
I've created a Custom Data Flow Component and added some Custom Properties.
I want the user to set the contents using an expression. I did some research and come up with the folowing:
Code Snippet
IDTSCustomProperty90 SourceTableProperty = ComponentMetaData.CustomPropertyCollection.New();
SourceTableProperty.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;
SourceTableProperty.Name = "SourceTable";
But it doesn't work, if I enter @[System:ackageName] in the field. It comes out "@[System:ackageName]" instead of the actual package name.
I'm also unable to find how I can tell the designer to show the Expression editor. I would like to see the elipses (...) next to my field.
Any help would be greatly appreciated!
Thank you
View 6 Replies
View Related
Apr 2, 2007
Hi,
I'm trying to enable Expression for a custom property in my custom data flow component.
Here is the code I wrote to declare the custom property:
public override void ProvideComponentProperties()
{
ComponentMetaData.RuntimeConnectionCollection.RemoveAll();
RemoveAllInputsOutputsAndCustomProperties();
IDTSCustomProperty90 prop = ComponentMetaData.CustomPropertyCollection.New();
prop.Name = "MyProperty";
prop.Description = "My property description";
prop.Value = string.Empty;
prop.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;
...
}
In design mode, I can assign an expression to my custom property, but it get evaluated in design mode and not in runtime
Here is my expression (a file name based on a date contained in a user variable):
"DB" + (DT_WSTR, 4)YEAR( @[User::varCurrentDate] ) + RIGHT( "0" + (DT_WSTR, 2)MONTH( @[User::varCurrentDate] ), 2 ) + "\" + (DT_WSTR, 4)YEAR( @[User::varCurrentDate] ) + RIGHT( "0" + (DT_WSTR, 2)MONTH( @[User::varCurrentDate] ), 2 ) + ".VER"
@[User::varCurrentDate] is a DateTime variable and is assign to 0 at design time
So the expression is evaluated as: "DB189912189912.VER".
My package contains 2 data flow.
At runtime,
The first one is responsible to set a valid date in @[User::varCurrentDate] variable. (the date is 2007-01-15)
The second one contains my custom data flow component with my custom property that was set to an expression at design time
When my component get executed, my custom property value is still "DB189912189912.VER" and I expected "DB200701200701.VER"
Any idea ?
View 5 Replies
View Related
Sep 26, 2006
Hi,
I have just run a simple data set through a model to predict a simple true or false value (i.e. binary output)
The Lift Chart/Mining Legend in Analysis Services shows three results €“ Score, Population Correct (%), and Predict Probability (%)
Population Correct I beleive is the percentage of predictions it got right out of the total number of predictions it tried to make. Is this correct?
However, I can€™t work out how the other two are derived in particular the 'SCORE'. To give a live example the scores were as follows:
Model Score Pop Correct Pred Probability
Decision Trees 0.83 76.59% 54.28%
Neural Network 0.75 67.63% 50.05%
Ideal Model 100.00%
Can anyone help with this and give a detailed explanation?
Many thanks,
S Rajput
View 4 Replies
View Related
Aug 17, 2005
What I want to accomplish is that at design time the designer can enter a value for some custom property on my custom task and that this value is accessed at executing time.
View 10 Replies
View Related
Aug 16, 2006
I am writing a custom task that has some custom properties. I would like to parameterize these properties i.e. read from a varaible, so I can change these variables from a config file during runtime.
I read the documentation and it says if we set the ExpressionType to CPET_NOTIFY, it should work, but it does not seem to work. Not sure if I am missing anything. Can someone please help me?
This is what I did in the custom task
customProperty.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;
In the Editor of my custom task, under custom properties section, I expected a button with 3 dots, to click & pop-up so we can specify the expression or at least so it evaluates the variables if we give @[User::VaraibleName]
Any help on this will be very much appreciated.
Thanks
View 3 Replies
View Related
Sep 5, 2007
Hi all ,
i need to have outside label position for my data in 3d pie chart. How can i implement outside labelling?
Thanks
View 1 Replies
View Related
May 4, 2007
I have created a bar graph but cannot find a way to change the bar's color for different series.
I have a graph which has sales men and their sales between dates
Thanks for your help
View 5 Replies
View Related
Jan 10, 2007
Hi, I have a quick question about charts in SQL reporting services...
Is it possible to have a page through chart, meaning that an user can page through multiple pages of the same chart?
View 1 Replies
View Related
Mar 1, 2007
hi,
I would like to have a bar chart with the values of each bar on the top of the bar. How can I do this.
thanks,
naveen
View 1 Replies
View Related
Nov 14, 2007
Hi All,
I'm using DTS in Sql Server 2000 for the first time, and would like to create Ad-Hoc reports with Pie/Charts and graphs. Is this possible in SQL Server/DTS, or would I need something like Cyrstal Reports?
Thanks!
Matt
View 2 Replies
View Related
Jun 21, 2008
Hi
I have developed some line charts in reporting services with some parametrs
On the bottom axis is the month and the upper is no. hours.
The problem is that when i select certain parametrs becaus there is no data for that month the line just ends and then starts at a new month.
Does anyone know anyway of telling it to go to zero if there is no data for it so there is a continous line
Thanks
View 2 Replies
View Related
Mar 18, 2008
Can you loop through the records of one dataset and create a chart for each record?
View 2 Replies
View Related
Jan 4, 2008
Hi,
How can we use the line chart in the Sql Server Reporting Services 2005.
Please explain about the each and every properties in chart control.
Thanks In Advance
Shoba
View 1 Replies
View Related
Aug 2, 2007
Does anyone here use 3rd party graphs and charts for SSRS 2005?
What do you use? Is there a superior package out there?
Thanks
-JW
View 1 Replies
View Related
Feb 28, 2007
I've got a report with a table holding a subreport that contains a number of Dundas charts. Each of these charts displays A LOT of data.
Now... after deploying the report, only a few charts at the bottom of the report are displayed -- the rest display the Image-doesn't-exist icon (File image with red X across it). Can anyone tell me what's going on? My best guess is that this is a memory issue on the server side...
View 1 Replies
View Related
Jul 2, 2007
Friends,
I have a requirement in Bar charts using SSRS...Assume that I have 3 Products Quantity and the representation will look like following
A - 10
B- 20
C-15
Though it is easy to develop this as a bar chart...The requirement is that a Product Perfomace should be represented using Images in the chart area...Instead of showing that A has 10 quantitites in a single bar, a general product image should be coming in the place of 10 and same with the case of B and C.. I have used smiley icons here for clarity
The look of the chart should be like following
|
|_________________
|_________________|
|
|________________________________
|________________________________|
|
|______________________
|______________________|
|_________________________________________________
Please let me know if there is a way to customize this bar chart using SSRS Charts...Thanks in Advance
View 2 Replies
View Related
Aug 24, 2007
Hi,
I am upgrading all my access reports to reporting services. One of my access reports, contains a chart which is set a a multiple chart (so I can see a chart of data for each day in the data set). Is it possible to do the same using the SQLserver 2005 chart component?....I cannot see an obvious button to press which makes a single chart a multiple one.
If this is not possible in vanilla reporting services, can anyone suggest a thrid party add-in that will rovide the functionality I want? (cheaply lol!)
Cheers,
Kevin.l
View 18 Replies
View Related
Aug 14, 2007
I have a pie chart which is been populated from a sproc.
and for a particular fund the values that generate are 78%,20% and 2% respectively.
And when it generates a chart the pie chart is uniformly displayed... Like for eg.. its been broken into 3 parts and there isnt a difference between the 78% and the 2% so ... How can i get the pie chart to be a displayed according to its values..
Any help will be appreciated..
Regards
Karen
View 7 Replies
View Related
