Posted on 2005-05-04
Last Modified: 2012-06-27
LETS SAY i have 7 textboxs showing the coloring scheme

(vibgyor) -violet indigo blue green yellow orange red

if i want to show vibgy_r ...i just hide the 6th box
but there is a space between y and r

is there any way to make it hidden

I WANT TO DISPLAY VIBGYR (WITHOUT THE SPACE) there any way i do it programaticaly (within crystal)?
Question by:crystalguy2000
    LVL 100

    Accepted Solution

    Not in the way you are trying to do it.  Crystal cannot move/resize the boxes.

    However you could do something like this for each text box.  Set the color using a formula

    Color formula
    if left({?ColorString},1) = "v" then
       Color (xxx,yyy,zzz)  code for violet (may be able to use crViolet)
    else if left({?COlorString},1) = "i" then
       Color (xxx,yyy,zzz)  code for indigo (may be able to use crIndigo)

    Textbox 2
    if mid({?ColorString},2,1) = "v" then
       Color (xxx,yyy,zzz)  code for violet (may be able to use crViolet)
    else if mid({?COlorString},2,1) = "i" then
       Color (xxx,yyy,zzz)  code for indigo (may be able to use crIndigo)

    etc for each textbox in turn

    For textbox 7
    if length((?ColorString) <> 7  then
    else same as above

    You could then suppress textbox 7 with
    length((?ColorString) <> 7

    LVL 100

    Expert Comment

    Glad i could help


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now