Crystal Reports field color display problem

Last post 05-09-2008 5:11 PM by TonyDong. 7 replies.

Sort Posts:

  • Crystal Reports field color display problem

    05-02-2008, 11:47 AM
    • Loading...
    • ajaxrobert
    • Joined on 06-04-2007, 10:50 PM
    • Posts 31

    I have a Crystal Report XI report that displays a memo data type field across multiple lines and the background color is present on all lines.

    I also have a Crystal Report XI report that displays a string[500] data type field across multiple lines and the background color is present on only the first line.

    I want the color present on all lines. How can I get the color on all lines of the string data type?

  • Re: Crystal Reports field color display problem

    05-02-2008, 12:49 PM
    • Loading...
    • TonyDong
    • Joined on 02-01-2006, 1:30 PM
    • BC, Canada
    • Posts 642

    Right click yoour mouse on details, choose SectionExpert, select Color, X-2 

    if IsStringDataType('ColumnName') then crSilver else crNoColor

    You need to write IsStringDataType function to return true or false

    Don't forget to click "Mark as Answer" on the post(s) that helped you.
  • Re: Crystal Reports field color display problem

    05-02-2008, 1:04 PM
    • Loading...
    • ajaxrobert
    • Joined on 06-04-2007, 10:50 PM
    • Posts 31

    What/where is details ?

    Right click yoour mouse on details

  • Re: Crystal Reports field color display problem

    05-02-2008, 1:08 PM
    • Loading...
    • TonyDong
    • Joined on 02-01-2006, 1:30 PM
    • BC, Canada
    • Posts 642

     

    Details is on the crystal report design layout. and where you put your columns inside it.
    Don't forget to click "Mark as Answer" on the post(s) that helped you.
  • Re: Crystal Reports field color display problem

    05-09-2008, 10:28 AM
    • Loading...
    • ajaxrobert
    • Joined on 06-04-2007, 10:50 PM
    • Posts 31

    I have not done any of the following and don't know how to do these

    if IsStringDataType('ColumnName') then crSilver else crNoColor

    You need to write IsStringDataType function to return true or false

    Can you offer any nore help here?

  • Re: Crystal Reports field color display problem

    05-09-2008, 12:04 PM
    • Loading...
    • TonyDong
    • Joined on 02-01-2006, 1:30 PM
    • BC, Canada
    • Posts 642

     

    Try this way, may it is easy to do:

    Select the field you want to format,  right click mouse chose format objact, Chose Paragraph, and in Text interpretation, select HTML Text

    So here you can use html to format your data now. you need to format your  data before bind to crystal report

    for example:

    select "<font color='red'>ABC</font>" from table.

    after you bind it to crystal report, the font will change to red automatically like nomal html format.

    Don't forget to click "Mark as Answer" on the post(s) that helped you.
  • Re: Crystal Reports field color display problem

    05-09-2008, 5:07 PM
    • Loading...
    • ajaxrobert
    • Joined on 06-04-2007, 10:50 PM
    • Posts 31

    Only it's the Group Header background

  • Re: Crystal Reports field color display problem

    05-09-2008, 5:11 PM
    • Loading...
    • TonyDong
    • Joined on 02-01-2006, 1:30 PM
    • BC, Canada
    • Posts 642

     

    It can be used in details also, please double check your data.
    Don't forget to click "Mark as Answer" on the post(s) that helped you.
Page 1 of 1 (8 items)