I am having a problem setting the colors of the bars in a bar chart. It seems like it would be the simplest thing, but apparently it's not.
The "series" is grouped on whether or not the value is positive -- if so, the bars are blue (by default) and if not, green (by default). I want to change it so the positive color is blue and the negative color is red.
I found that I can change ALL the bars to one color by going to chart properties, Data tab, Values Edit, Appearance tab, Series Style, Fill. There I set the color to red and ALL the bars became red. But this is not what I want.
I tried using a conditional statement like IIf(Fields!IsPositive.Value=True,Blue,Red) for the color, but (not surprisingly), it told me I hadn't defined Blue and Red.
My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?
Need to be able to change the color of the columns red for negative values and Green for positive-- Im thinking that this will have to be a custom code scenario and not a expression-- any suggestions??
So I have created a chart in my report that counts the number of transactions by day. Each day in a month is a series. Now when I view the report, the series line is different color as expected until I hit the 17th, then the color associated with the line repeats. I.e. the 1st and the 17th are the same color line, the 2nd and the 18th are the same color...etc.
Does anyone know how to break the color limitation quandry?
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
Hi all, Is it possible with Reporting Services to create a scatter chart where the colour of the report area are dependant upon X or Y axis value? For example: can I specify that if the point values are greater than 75 then the color of those parts shall be red? and other are green as an example.
Furthermore can I get X and Y axis value of chart? also i like to know that i want add a line in scatter report based on a value which is not a Major or Minor gridline.can i do it? pls advice.Looking for your help desparately.
I have a column bar chart which displays values for each month. As per the requirement, January column must be blue, February must be orange, March must be green, April must be pink. These 4 colors would repeat for the remaining months.
I have to color format the bars in set of 4 colors. I have used SWITCH statements for other charts and it worked. But here in this case since it is a date field, I am getting error.
I have a 2012 report builder chart that has two series (one area chart and one bar chart) combined into one chart. The problem I'm having is the bar chart has much smaller numbers than the area chart and the scaling is messed up.
Is there any way to put the bar chart on the right axis and keep the area chart on the left axis? My goal is to increase the size of the bar chart in relation to the area chart.
Also, is there any way to make the bar chart color red if the number is negative and green if it is positive?
I have a chart with series that needs conditional colour for three conditions. One condition must be transparent. I have tried the various IFF or SWITCH expressions below and some work fine in SSDT but when I deploy them to the browser the formatting is lost. This simple IFF expression works. The series is transparent as required both in SSDT (Visual Studio BIDS) and IE11 and Firefox browsers but I need two other conditions.
Both of the expressions below work in SSDT (Visual Studio BIDS) as expected but when deployed to the browser none of this formatting is rendered and all series are in blues even the ‘transparent’ series. No red at all.
I have tried deleting various files RDL and DATA. I have tried uploading the file from report manager in IE and I have tried editing the file in report manager.
Hi, Not sure what I did wrong to this code. What I would like this code to produce is, if any number is less than 0 (negative) than it should be red, if it's greater than 0, it should be black. Somehow it comes back red even though it's a positive number.
I am using toggle visibility feature in one of my reports and I am trying to change the background color of some cells when I toggle the view. Please help, any help will be appreciated.
Hi SQL experts How can I make charaters change to color such as red if some condition happen in a column of database tables? Using IF.... function? Thanks Daniel
When the value of Downtime is greater than 0:00:10 I would like to have the background of that cell to be Red and its font bold. How to accomplish this in query?
I've created a report in SSRS 2005, where one of the fields is using 'Jump to URL'. I made that field the color blue and underlined it so the users can see it's a link.
How do I change the color of the field/link to a different color once it's viewed so the users know they already selected that field?
When you set a row's hidden property to true, RS writes a white row. Is there a way to keep the background color the same is it was before the row was hidden and just not display the data?
I have built an SSRS report and fetching my data from an ERP system, previously we have done the same way and the reports are working fine, but only one report which is also working fine but when the values displayed in Preview or Excel, we cannot see values in Excel, when we click on the cell we can see the values in formula bar, but not in the cell. When we select the cell and change the color it will then display the values. In this report many of the values are displayed correctly, but some are not displayed, so every time we need to change the color of entire report. This is causing issues to the end users.
January February March April Sales 1050 800 750 1100 Units Sold 50 40 41 60
I want to change the background color to yellow if the value is less than the previous month. For example for the sales row, February sales is less than January and March sales is less than February so I would want the values (800 and 750) to have a background color of yellow. The columns is grouped by month.I've tried experimenting with the Previous function but I run into the following error message: The BackgroundColor expression for the text box has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.
Changeing the line thickness (to say 1pt) of data points in a line chart alters that thickness in the designer but reverts to a standard thickness when the report is run (possibly 3pt).
The Procedure Lets say I had three data points being charted as lines, I do the following:
Put the chart into the designer Assign the datafields I want to chart The default line width seems to be about 3pt I right click the chart and select properties Data tab
For each data point
Click edit Appearance tab Series Style button
Set Style to 'solid' Width to 1pt Color to whatever color is desired Ok the (way too many) dialog boxes to get back to the chart I note the line thicknesses have changed to 1pt Preview (or deploy and browse) the report The chart line thickness have reverted to the default (3pt?) This is very irritating.
Versions SQL Server 2005 ver 9.00.3042.00 MS Visual Studio 2005 ver 8.0.50727.42 (RTM050727-4200) .Net ver 2.0.50727
Anyone have any idea of how to get the line thicknesses to stick?
When using the back color property for SSAS 2008 R2, is there a good way to match the number to the desired color? I found some color pickers online, but the numbers don't match the same colors in SSAS. How can I best determine the number needed for the color I want?
I am developing several charts with column type and sub type as stacked. There is a requirement from the users that they want an option to choose the type of chart.
Is it possible to change chart type dynamically from say Column type to Line type based on user option in front-end?
I am using Sql REporting Services 2005 for viewing reports in my web application. I have to change the chart types at run time basesd on the option. User can select any chart eg. bar chart, pie chart, column chart etc. On selection screen should populate the chart type. I am not able to change chart type at runtime. Help please.