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 strongm 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. roswelltx

    Color coding a text field

    I'm sorry but I do not understand: "Things like the version of your software and whether this is a typed text field or you mean a database field or a formula, etc., would be useful to know so that we don't waste time." This is what you asked for and I answered all of that in my last post. CR10...
  2. roswelltx

    Color coding a text field

    Sorry, I'm bad on being vague. It is a DB field and it actually is a long memo type field. I am using Crystal 10. Thanks
  3. roswelltx

    Color coding a text field

    Hi all. I have a long text field. If i want to show a certain word in RED when it finds it in this text field, is there a way to do this? Thanks Regina
  4. roswelltx

    Cannot Summarize fields

    Sorry. I am using Crystal 10. It will not let me right click and insert a summary, that option isn't available. Almost like it doesn't see it as a number, but it does say it is a number if I try to do a SuM({field}) it gives error saying this field cannot be summarized. Thanks, Regina
  5. roswelltx

    Cannot Summarize fields

    I have a field that is a number and Crystal see's it as a number, but it will not let me summarize it, or count it or anything. I don't understand why? I have tried doing it with insert summary and through a formula, it just doesn't let me. Any suggestions? Thanks, Regina
  6. roswelltx

    Subreports- formula's

    awesome thanks Gary!!!!
  7. roswelltx

    Subreports- formula's

    Is it possible to create a formula that will divide one total from the main report with a total on a subreport. Can this even be done? Thanks, Regina
  8. roswelltx

    Multidimensional Array help

    Scott, Wanted to give you an in depth update. Thank you first of all for all the hard work you put into this. It was an awesome help. I was able to take it, and use it as a template, i had to convert it to basic script so I could make use of the formula= to evaluate each step and what it was...
  9. roswelltx

    Multidimensional Array help

    Scott, Thank you so much, I will be working heavily on this Monday and I will let you know what happens. I appreciate all the work you put into this. Thanks, Regina
  10. roswelltx

    Multidimensional Array help

    Scott, If I could get this output: TICKET NUMBER HD0000001725 ---jcgoode 20 hours ---mkoonce 144 hours ---kwlewis 57 hours That would work, then I could add up all the hours across the varies tickets and get an average of the amount of time worked for the month. Unfortunetly the...
  11. roswelltx

    Multidimensional Array help

    Would it be possible to use the first code Scott provided for splitting but do a step before that that splits it up per line first then puts each line into a separate array, then when you start to split, instead of pasing through the entire history file, you parse through each line that is in an...
  12. roswelltx

    Multidimensional Array help

    Scott, I do NOT have write access to SQL only read. Someone that had done this report in the past just took the assigned feild in remedy and calculated that time with when it was opened. That is not even close to acurate since the assigned field ONLY gives the last person that was assigned and...
  13. roswelltx

    Multidimensional Array help

    Let me give you a longer text file than that one. This is pulling from a Remedy ticket history field stored on SQL. We need to know every time the assigned person changes to another one and the date and time for that. The parts I need pulled out are bolded and in RED. I know this is long but...
  14. roswelltx

    Multidimensional Array help

    Scott, Great job. With some fine tuning , this looks like we can use it. One problem i am having though is, when you run it, it is getting an error saying: "An Array's dimension must be an integer between 1 and 1000" It is getting it from this line: strarrWorking:=Split(strWorking,"###")...
  15. roswelltx

    Multidimensional Array help

    I'm sorry I put in before the text file what I need to pull out, I thought thats what you meant. here is the expected output for everytime it changes: Person assigned= epere5 Date/Time assigned= 1/21/2005 3:40:15 PM The problem is I can split it up but the date and time fields are always...
  16. roswelltx

    Multidimensional Array help

    I am using crystal 10, with SQL database. I am trying to parse through an extremely large text file, I need to be able to pull out the group assigned, the user id assigned too, and the date and time fields, here is an example of the text field: Group Assigned changed from '' to 'ITCC-Soft1' by...
  17. roswelltx

    Daylight saving conversion need help

    I have a formula that works: if {Parameter} in DateTime (2005, 04, 03, 02, 00, 00) to DateTime (2005, 10, 30, 02, 00, 00) then dateadd ("h", 1, {Parameter}) else {Parameter} My problem is I don't want to have to limit this to this one years of 2005, I need a way to make it dynamic...
  18. roswelltx

    Multidimensional Array help

    I have an extremely large text field on SQL that I am having to parse through and pull out several keys things. I am thinking a Multi-dimensional array would work for this but I cannot find an example of one anywhere. Does anyone have an example of what it is suppose to look like. Thanks...
  19. roswelltx

    Calculating field

    That worked thank you so much...
  20. roswelltx

    Calculating field

    Thanks for your reply, forgive me for my lack of programming knowledge, but what do you mean insert a summary on the field?

Part and Inventory Search

Back
Top