Colouring the chart plot area based on x-axis scale

Hi,

I have a report based on a line chart.

The values on X-axis are scaled from -100 to +100. I want to colour the band from -100 to 0 with red colour and that from 0 to +100 in green colour, and i want to provide legend for these bands/sections. How can i do this?

This doesn't look like a tough thing to do but i can't find a way to do it within the chart properties.

Basically i would like to divide the chart (plot area) into multiple vertical bars, each having a different colour. The colour is determined by the range that vertical bar covers on the x-axis

Thanks a lot!

Simranjeev

To color the bars on the chart, go to Chart Properties -> Data -> Edit button in the Values section -> Appearance Tab -> click the Series Style button -> Fill tab

You will have to enter an expression in the color property for the bar to be one solid color. The expression should look something like:
IIF(Fields!XAxisField.Value < 0, "Red", "Green")

You can do this if the axis value is a number or date. You may have to nest a couple of IIF statements if there are a lot of sections that you want to use. I don't think you can use the legend provided by reporting services for what you want it to accomplish since it is based on the series fields. You can create your own legend with a few lines, textboxes, and property changes though.

Colouring the chart plot area based on x-axis scale

Hi,

I have a report based on a line chart.

The values on X-axis are scaled from -100 to +100. I want to colour the band from -100 to 0 with red colour and that from 0 to +100 in green colour, and i want to provide legend for these bands/sections. How can i do this?

A prompt response would be really appreciated

Thanks a lot!!

Simranjeev

Hi!

This is a little urgent so i would really appreciate some response.

This doesn't look like a tough thing to do but i can't find a way to do it within the chart properties.

Basically i would like to divide the chart (plot area) into multiple vertical bars, each having a different colour. The colour is determined by the range that vertical bar covers on the x-axis

Thanks!

Simranjeev

Colour Printing in CR 8.5

Hi
I'm using Crystal reports in My VB application. All but one of my reports are printing in colour. All my reports/designers are in the same project. Any ideas why this one report is printing in black & white?
any help would be appreciatedI do not know if this will apply to you because I am using Crystal 10.

I had a similar problem with users trying to print crystal reports in color, but they were printing in black and white. What I found was that since I created the crystal reports, all users who were accessing the crystal reports were printing from my printers default settings. I have a black and white printer in my office, so all the users were printing in balc and white.

What I had to do was, open the crystal report setup/creator, open the printer setup, select the color printer, and then save the report. After this was done, all users were able to print the crystal reports in color.

Let me know if this helps.

Colour of the series in legend

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!!!

Check out my sample report on Brian Welcker's blog: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx

-- Robert

Colour My World

In SQL Server 2000 Query Analyzer, is there a way to print T-SQL code with
the QA color coding? When I print, even to a color laser printer, everything
including the keywords and comments come out in black and white.
Thanks!>> In SQL Server 2000 Query Analyzer, is there a way to print T-SQL code
Not sure if direct printing is possible or not. This might be silly but if
the code is small enough to fit the screen, you could use a screen print to
a word document and then print it.
Anith|||>> When I print, even to a color laser printer, everything
including the keywords and comments come out in black and white. <<
Just for fun, you might want to research the effect of "colored code"
on maintaining it. There is a standard test for brain damage where you
show the subject a seires of flashcards with the names of colors in
colored ink (I.e. "RED" pritned in green ink) and ask them to call out
the either word or the color. This has nothing to do with being
color-blind.
Since it involves switching brain hemispheres and thus the physical
structure of the brain as a organ, the rate is fairly constant over a
person's lifetime. Unless they get some physical damage to the brain.
Strongly analytical ("left brain, right hand") people have an awful
time with "neon vomit programming tools" because they have to filter
out the colors to abstract the code from the text.
So, I have to ask, why would you ever want to do this? Get a copy of
SQL PROGRAMMING STYLE for some more info on how humans read code. I
did a bit of the work on this back in the 1980's for AIRMICS while I
was a Georgia Tech.|||Well, cut-n-paste it into MS Word - that should do the trick ;)|||Screen capture could work, but the code is many, many pages long.
Is this possible in SQL Server? If not , are there any 3rd party programs
that might work?
Thanks again...
"Anith Sen" wrote:

> Not sure if direct printing is possible or not. This might be silly but if
> the code is small enough to fit the screen, you could use a screen print t
o
> a word document and then print it.
> --
> Anith
>
>|||Nope, tried it. Still black-and-white in MS Word.
"Alexander Kuznetsov" wrote:

> Well, cut-n-paste it into MS Word - that should do the trick ;)
>|||Why would I want color-coded printouts? for the same reason they're
color-coded on the screen. Easier to separate what's code, what's keywords,
and what's comments.
As far as the brain damage research, although it sounds rather intriguing,
considering how many more years of my life I'm going to spend looking at M&M
colored typing, I may be better off not knowing...
"--CELKO--" wrote:

> including the keywords and comments come out in black and white. <<
> Just for fun, you might want to research the effect of "colored code"
> on maintaining it. There is a standard test for brain damage where you
> show the subject a seires of flashcards with the names of colors in
> colored ink (I.e. "RED" pritned in green ink) and ask them to call out
> the either word or the color. This has nothing to do with being
> color-blind.
> Since it involves switching brain hemispheres and thus the physical
> structure of the brain as a organ, the rate is fairly constant over a
> person's lifetime. Unless they get some physical damage to the brain.
>
> Strongly analytical ("left brain, right hand") people have an awful
> time with "neon vomit programming tools" because they have to filter
> out the colors to abstract the code from the text.
> So, I have to ask, why would you ever want to do this? Get a copy of
> SQL PROGRAMMING STYLE for some more info on how humans read code. I
> did a bit of the work on this back in the 1980's for AIRMICS while I
> was a Georgia Tech.
>|||On Fri, 10 Feb 2006 08:51:29 -0800, "Joel"
<Joel@.discussions.microsoft.com> wrote:

>In SQL Server 2000 Query Analyzer, is there a way to print T-SQL code with
>the QA color coding? When I print, even to a color laser printer, everythin
g
>including the keywords and comments come out in black and white.
>Thanks!
I use Macromedia's Homesite. You can set the colors for each entity.
What you see on the screen is what prints. I also use Ultra Edit and
Slick Edit. Both of these allow you to print a selection where
Homesite will only print the entire file. I like the printout from
Homesite best.
--
BettyB -- www.flamingo-code.com
"I have noticed even people who claim everything is
predestined, and that we can do nothing to change it,
look before they cross the road." - Stephen Hawking|||I don't know if it is an option or not, but the 2005 replacement of QA (Mana
gement Studio) does keep
formatting (including colour) when you copy text. Personally, I hate that, b
ut it might be an upside
in these situations.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:F6077A67-C933-47CA-A4C5-654D2E7881A8@.microsoft.com...
> Nope, tried it. Still black-and-white in MS Word.
> "Alexander Kuznetsov" wrote:
>|||> Personally, I hate that,
me too. Sometimes I need to paste into notepad - that removes colors
and fonts

Colour coding the RDL XML in vs2005

Hi.
Does any one know how to get vs2005 to colour code rdl apart from
renaming the file xml?
Some times one just needs to check the rdl file, and looking at it in
B&W isn't easy to visually scan.
Thanks.On Aug 4, 1:49 am, Ray Proffitt <ray...@.gmail.com> wrote:
> Hi.
> Does any one know how to get vs2005 to colour code rdl apart from
> renaming the file xml?
> Some times one just needs to check the rdl file, and looking at it in
> B&W isn't easy to visually scan.
> Thanks.
A good software to do this with is Notepad++ (open source): its a text
editor that will color code based on your language selection (i.e.,
XML, C#, HTML, etc). You can download it at: http://notepad-plus.sourceforge.net/uk/site.htm
It works well for this sort of thing.
Regards
Enrique Martinez
Sr. Software Consultant|||I've been using notepad++ for years. Problem is notepad++ doesn't have
the Report design view, and I frequently change to see the code, cos
sometimes I just need to...
VS2005 will colour code the XML too, just not when it has an RDL
extension, I think it's MS just trying to mother us too much.
I figured there might be a reg setting I could change.
I've tried a couple in here:
HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\Text Editor\RDL
Expression
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\8.0\Languages
\Language Services\RDL Expression
On Aug 5, 9:26 am, EMartinez <emartinez...@.gmail.com> wrote:
> On Aug 4, 1:49 am, Ray Proffitt <ray...@.gmail.com> wrote:
> > Hi.
> > Does any one know how to get vs2005 to colour code rdl apart from
> > renaming the file xml?
> > Some times one just needs to check the rdl file, and looking at it in
> > B&W isn't easy to visually scan.
> > Thanks.
> A good software to do this with is Notepad++ (open source): its a text
> editor that will color code based on your language selection (i.e.,
> XML, C#, HTML, etc). You can download it at:http://notepad-plus.sourceforge.net/uk/site.htm
> It works well for this sort of thing.
> Regards
> Enrique Martinez
> Sr. Software Consultant

Colour a cell in a report when mouse is over it

Hi to everyone,

Is it possible (and if so, how should it be done?) to change some settings (i.e. the background colour) when user puts the mouse over a cell?

Thanks in advance,

Jesus M

Sorry, let me be more specific. I am using Visual Studio 2005 to develop an RDL file so as to upload it to a Report Server. The control I am using is a Table, although I could use any other (Matrix, for example) if needed for acomplish this :-)

Thanks again