Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How do I prioritizing conditional formatting in crystal reports?

Posted on 2009-05-18
10
Medium Priority
?
350 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

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…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

971 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