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 Mike Lewis 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
  • Order by date
  1. BoeingSK

    ADD LETTER TO FIELD BASED ON FORMULA

    That was perfect, thank you! I'll be glad when the day comes that i can answer some of the questions. Up and Coming Technical Guy
  2. 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...
  3. BoeingSK

    BYPASS Parameters

    Thanks anyway for your help, I figured it out on the date I can just put No lower value and todays date. This should all be enough for me to play with. Thank you> Up and Coming Technical Guy
  4. BoeingSK

    BYPASS Parameters

    Thanks Cospringsguy and Lbass that worked for my number parameter, but what would be the default for a parameter that searches by date or a non numeric string. I tried the same thing on a date parameter and it would take the 0. Up and Coming Technical Guy
  5. BoeingSK

    BYPASS Parameters

    Settings are Custom-true, multiple-false, discrete-False, ranges-true Up and Coming Technical Guy
  6. 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...
  7. BoeingSK

    Alert for Data Change

    2328, Click on the Top of this page where it says Forum. Then there is a start new Thread Link at the top of all the Topics. Don't worry I used to be in your shoes!! Up and Coming Technical Guy
  8. BoeingSK

    A String Field Requiring A Number

    Yes sir, sorry I mean I summed it which only counted my "1"'s for each Y. Up and Coming Technical Guy
  9. BoeingSK

    A String Field Requiring A Number

    Thanks Lbass, but I was able to do a count on : if {STOCKEXT.FIELD9} = "Y" then 1 else 0 Then I will sum this up. I'll not your reference in the future. Thanks. Up and Coming Technical Guy
  10. BoeingSK

    CR auto refresh

    I just looked at my Third party software called Datalink, it has a autorefresh option. read up on it at www.MilletSoftware.com Up and Coming Technical Guy
  11. BoeingSK

    Placing A Parameter

    Amazing, That worked , I have a long way to go on learning these parameters. Know of any tutorials or references on parameters. Up and Coming Technical Guy
  12. BoeingSK

    CR auto refresh

    I don't see any auto refresh options but the is an auto save under file>options>Reporting. Up and Coming Technical Guy
  13. 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
  14. BoeingSK

    Placing A Parameter

    eNTER DATE IS A DATE TIME FIELD, I have format it to only show date on the report. But It pulls date and time through the table. Up and Coming Technical Guy
  15. BoeingSK

    Placing A Parameter

    Yes it is a date time field, I have set the parameter where it shows the calendar to choose the dates you want. When i select a date range the reports stays the same it doesn't reduce to only the range. The parameter is set as follows: Name: Month Date Range Type: Date List of Values : static...
  16. BoeingSK

    Placing A Parameter

    Sorry Crystal XI, I HAVE ENTERED {TKT_HDR.ENTER_DATE} in [?StartDate to ?EndDate] and it gave me an error message A number,currency amount, boolean, date,time-date, or string is expected here. I have all of the records pulling for the last two years, IU want the users to be able to selct...
  17. 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
  18. BoeingSK

    Alert for Data Change

    Any references on how to do that procedure. Up and Coming Technical Guy
  19. BoeingSK

    Alert for Data Change

    Sorry let me re-phrase that , not the field but the data in the field. If the price was $10.00 then change to $20.00 or if an order had a due date of 10/1/08 and changed to 1/1/08,I want to have these detail lines show only. Up and Coming Technical Guy
  20. 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...

Part and Inventory Search

Back
Top