Results 1 to 5 of 5

Thread: Crystal report problem

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2009
    Posts
    6

    Crystal report problem

    hi all ,

    I am using crystal report in my vb6 application , the cr version is 4.6
    what I want is to put a condition if the field = "total " then color all the fields with grey color .
    I tried to search in google , I found that I shoud use select records expert
    but I didnt know how to use it to color all the fields .

    help please

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Crystal report problem

    Moved To Reporting

  3. #3
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Crystal report problem

    I'm afraid, AFAIK, that you have to condition every field

  4. #4

    Thread Starter
    New Member
    Join Date
    Jul 2009
    Posts
    6

    Re: Crystal report problem

    Quote Originally Posted by jggtz View Post
    I'm afraid, AFAIK, that you have to condition every field
    hi

    how can I assign color to the field whats the function ?
    because I search the edit formula but I didnt find the coloring function !
    any code may help me ?

  5. #5
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Crystal report problem

    Click right button over every field that you want to condition (one by one, I never try selecting all the fields)
    Select 'Font'
    Set desired Color in the Color combobox
    Click over 'x-2' button at the right side
    In the formula Editor window, write your condition as (is an example, write your real table an field names):
    Code:
    If {Table1.Field1]="total" then crRed
    Save the formula
    And that's it

    JG

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width