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 dencom 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: *

  • Users: BoeingSK
  • Content: Threads
  • Order by date
  1. BoeingSK

    ADD LETTER TO FIELD BASED ON FORMULA

    I need to add letters to a field based on a conditional formula is this possible? This is what I have please tell me where I am going wrong. IF {Command.DOC_CATEGORY}="SO" THEN 'S{Command.DOC_CATEGORY}' ELSE IF {Command.DOC_CATEGORY} = "RF" THEN 'R{Command.DOC_CATEGORY}' I want the field to...
  2. BoeingSK

    BYPASS Parameters

    My question is how do we Bypass parameters. I have a report that I added a parameter to search for document numbers. The user can search for one document or a range of numbers. What I don't know is how to bypass the parameter and just let the whole document flow. It won't let you hit O.K. on the...
  3. BoeingSK

    A String Field Requiring A Number

    I am creating a formula to count a field that has only Y,N, or Blank in the field. I am using fomula : COUNT({STOCKEXT.FIELD9})="Y" to count all of the Y's but it is giving me the error message "A number is required here" Up and Coming Technical Guy
  4. BoeingSK

    Placing A Parameter

    Sorry for the lack of Knowledge, this is my first time using a parameter field. I have set it up to choose a date range but I don't know where to place it so it works. Up and Coming Technical Guy
  5. BoeingSK

    Alert for Data Change

    Is there any way to create an alert or highlight formula that would capture data change. I have a report that covers all our orders over the last few years. I need to know if I can have something that would highlight any change when i update. I also on want only the changes to show suppressing...
  6. BoeingSK

    Incomplete Backups

    We have a server that seems to hardly ever complete a full scheduled backup. We have to come in every day and change tapes then re-insert tapes for verify. Any suggestions on this. Up and Coming Technical Guy
  7. BoeingSK

    Error for Business Contact Manager

    Everytime i open my Outlook I receive the following message "Business Contact Manager for Outlook could not complete you last action or actions. Please try again." Does anybody Know the fix for this. I am running Windows XP and Microsoft Professional 2003 Up and Coming Technical Guy
  8. BoeingSK

    Grouping by an Alias Created

    I have an extensive report that I had to use a command to pull in the data. It was a count of each part number that we have ordered over our history the last two years. I was able to create an ALIS to group all partnumbers by distinct number with the count of that number. Now I want to Group...
  9. BoeingSK

    Suppressing one filed by the date of another.

    I have a report that shows customers orders through our company. The fields are Partnumber, Description, Qty, Date Due, and Comments. We add comments to each order line but we don't want to see them to the until the order is overdue. How do I use the due date field to suppress the Comment...
  10. BoeingSK

    Hold or Lock Data

    I am using Crystal reports XI and I have a report that is tracking orders with dollars spent. I have a Summary at the bottom for the grand total. I don't know how to do a subtraction formula because everytime i update I lose the old data.How can I keep the old prices still.

Part and Inventory Search

Back
Top