Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How do I prioritizing conditional formatting in crystal reports?

Posted on 2009-05-18
10
Medium Priority
?
351 Views
Last Modified: 2013-11-28
I'm setting up conditional formatting for a report and they conflict. I can not use any other color for this but red and white so changing the colour to something else is not an option.

I want to apply both the formats to the whole report but for the country Canada if there are orders under $100 (and there are) then the font is the same colour as the background and I can't have that. Is there an override/priority order or something I can write that says if the background is red ignore the color change? I know how to prioritize in highlight expert but highlight expert does not display conditional formatting as far as I know and also I know I can do this in highlight expert but I need to know how to do it in conditional formatting.

Thanks!!

edit: just a note I'm using Crystal Reports 2008 Developer (version 12)
// This is to change the font colour of the order amount if the amount is less than 100
if {Orders.Order Amount} < 100
then 
    red
else
    white
 
// This is to change the background colour of the details if the country is Canada
if {Customer.Country} = "Canada"
then
    red
else
    white

Open in new window

0
Comment
Question by:respawn
  • 5
  • 3
  • 2
10 Comments
 
LVL 2

Expert Comment

by:vetaldj
ID: 24416612
You can try something like this
// This is to change the font colour of the order amount if the amount is less than 100
if {Orders.Order Amount} < 100 and {Customer.Country} <> "Canada" 
then 
    red
else
    white
 
// This is to change the background colour of the details if the country is Canada
if {Customer.Country} = "Canada"
then
    red
else
    white

Open in new window

0
 

Author Comment

by:respawn
ID: 24416688
Also I just noticed that if the background is white and the order is above 100 the font is white as well so that doesn't show up. So just to recap I need something like

if {Customer.Country} = "Canada" and {Orders.Order Amount} < (less than) 100
then
    details background white
    font red

if {Customer.Country} = "Canada" and {Orders.Order Amount} > (greater than) 100
then
    details background red
    font white

if {Customer.Country} (not equal) "Canada" and {Orders.Order Amount} < (less than) 100
then
    details background white
    font red

if {Customer.Country} (not equal) "Canada" and {Orders.Order Amount} < (greater than) 100
then
    details background white
    font black



0
 
LVL 101

Expert Comment

by:mlmcc
ID: 24416725
There is no prioritizing.

Do that in the appripriate places.
Detail background
if {Customer.Country} = "Canada" and {Orders.Order Amount} < (less than) 100
then
    crWhite
else if {Customer.Country} = "Canada" and {Orders.Order Amount} > (greater than) 100
then
    crRed
if {Customer.Country} (not equal) "Canada" and {Orders.Order Amount} < (less than) 100
then
    crWhite
else if {Customer.Country} (not equal) "Canada" and {Orders.Order Amount} < (greater than) 100
then
    crWhite

Similarly for the font color

mlmcc
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:respawn
ID: 24417305
So I need to put the full above into both places? Also I know = is equals but what is the sign for not equals? Thanks
0
 

Author Comment

by:respawn
ID: 24417350
nvm I found what not equals is, i figured I just could have googled it.  Anyhow, I'm quite new to formulas, I tried to format the text but I got an error and am unsure how to fix it. I have attached what I got. Think you can help? Thanks.
formula.png
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 24417396
My fault.  Need an ELSE before the third IF

mlmcc
0
 

Author Comment

by:respawn
ID: 24418296
well i put in the formula like you said and I put it in both places and I removed the highlight expert rules and I got what you see in the image below. I'm really not sure what to do lol.
hrmm.png
0
 
LVL 2

Accepted Solution

by:
vetaldj earned 2000 total points
ID: 24418521
Try for font this formula:
Select {Customer.Country}
    Case "Canada":
        If {Customer.Order Amount} <= 100 Then crRed Else crWhite
    Default:
        If {Customer.Order Amount} <= 100 Then crRed Else crBlack

And for background:
Select {Customer.Country}
    Case "Canada":
        If {Customer.Order Amount} <= 100 Then crWhite Else crRed
    Default:
        crWhite

After all it looks somethig like attached file
0
 
LVL 2

Expert Comment

by:vetaldj
ID: 24418573
Can't upload file in some reason...
0
 

Author Comment

by:respawn
ID: 24426971
I changed the code to this to reflect the DB's tables and it really looks like it worked. THANKS!!!!!!

Background...

Select {Customer.Country}
    Case "Canada":
        If {Orders.Order Amount} <= 100 Then crWhite Else crRed
    Default:
        crWhite

Font...

Select {Customer.Country}
    Case "Canada":
        If {Orders.Order Amount} <= 100 Then crRed Else crWhite
    Default:
        If {Orders.Order Amount} <= 100 Then crRed Else crBlack


woot.png
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question