Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. l8kerfan

    Conditional Statement

    I am trying to import the picture in the details. On the left most side of the each line when the importance is labeled "Critical". It is the same picture every time. Do you have a sample suppress formula I could look at? Thanks.
  2. l8kerfan

    Conditional Statement

    I am trying to insert a picture when the word critical comes up in the report. Is it possible in 8.5 to write a conditional statement to insert a picture file? Or do I need to upgrade to XI to do so? Thanks.
  3. l8kerfan

    Boolean error

    Thanks lbass. That worked. And thanks for the suggestion Madawc.
  4. l8kerfan

    Boolean error

    I'm using the crystal 8.5 for Prolog Manager 7.5. I have the formula listed below in a report. I need the formula to recognize or make sure that the {COR Scope Change_4_ttx.ChangeOrderRequests~Status} does not equal "Voided" or "Rejected". I've tried using an OR statement after "Voided" but...
  5. l8kerfan

    Forecasting formula

    START PROJECTED MONTHS PROJECT TOTAL MONTH COMPLETION TO COMPLETION DURATION FEE MONTH FROM CURRENT (MONTHS) Dec-05 Sep-07 18 21 400,000 (E238) (F238) (G238) (H238) (I238) BOOKED...
  6. l8kerfan

    Sequential numbering

    Ok, I'm a little confused. I was using this formula "Item Number " & totext(recordnumber,0,"") Do I need to use the second formula for that counter reset suggestion to work? Or will it work with the formula above?
  7. l8kerfan

    Sequential numbering

    One more question. How do I get it to loop to "Item Number " 1 after the first group of records? I have this as a formula in a text field in the details section. I tried putting it in a group section but the numbering was not coming out properly.
  8. l8kerfan

    Sequential numbering

    I'm pretty new to setting up reports in crystal so this is a real basic question. Is there a way to add a formula to a text field so that is prints out "Item Number" followed by a space and a number which would be sequential? Also, is there a way to subtract two dates and have the input come...
  9. l8kerfan

    Anyone familiar with Prolog reports?

    That worked great!! Thank you so much. [2thumbsup]
  10. l8kerfan

    Anyone familiar with Prolog reports?

    This is the formula I'm having troubles with... If {Company Setup.Company~CompanyID} = "CWDCON" Then {Contracts_10_ttx.Contracts~Description} Else If {Company Setup.Company~CompanyID} = "CWD" Then {Contracts_10_ttx.Contracts~Description} Else If...

Part and Inventory Search

Back
Top