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!

Register Log in
  • Congratulations derfloh 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. hoppeli

    About Strings

    Thanks lbass, as we thought, my formula did not work properly in all cases. Your last advise was perfect! Thanks, Master! -H
  2. hoppeli

    About Strings

    lbass, I did it like this: if ubound({?code}) = 5 then ( {table.field} like "*"+{?code}[1]+"*" or {table.field} like "*"+{?code}[2]+"*" or {table.field} like "*"+{?code}[3]+"*" or {table.field} like "*"+{?code}[4]+"*" or {table.field} like "*"+{?code}[5]+"*" ) else {table.field} like...
  3. hoppeli

    About Strings

    Thanks lbass! That did the trick if I have two Iata codes! How about, if user wants e.g. 5 or 15 Iata-codes to be added? I tried to manipulate the code, but probelms started even with three Iata codes... -Hoppeli
  4. hoppeli

    About Strings

    Hi folks! "{table.field} like "*vie*" or {table.field} like "*svo*"" is doing the trick perfectly. I have tried to instead of 'svo' or 'vie' use parameter ({?IATA}), which is then the same 'vie' or 'svo' of both or whatever will be chosen, and then this does not work! I need to give the freedom...
  5. hoppeli

    About Strings

    Hello Folk's! I am using CR10 with SQL7.0 db. I have a problem once again... I have a string, which is say 25 digits: "EC 1 per 7 ng vie Hilton" or "PLA 2 per 1 ng svo ? ". I need to pick out always "vie or "svo", which is IATA code. Starting digit of that iata can vary and there can be...
  6. hoppeli

    Slow access to the database (reading records slowly)

    Hello folks! I am using CR 8.5 with SQL 7.0 DB. My own laptop is reading records vey very very slow. Again, my colleaque's laptop, which is identical, is reading records in normal speed. What could cause this behaviour in my laptop? Could it be something in CR or its installment? Should I...
  7. hoppeli

    need to duplicate records (rows)

    GJParker, you made my day. I had tried it earlier, but somehow, as being beginner, did not succeed in doing that. Now I have a solid foundation to continue. THANKS!
  8. hoppeli

    need to duplicate records (rows)

    Hi all! I am using CR 8.5 and SQL db (7.0). I have a dilemma as follows: I need to duplicate a detail section, if there is a certain string in a certain field: detail section now: 008 4 5000 0,00 1234,00 If there is this "008", it means this row should be duplicated and then output should...
  9. hoppeli

    YTD

    Sorry LB, I am a little bit in middle of a chaos. Here are those: //@YTD {table.date} in {?sdate} to {?edate} then {table.amount} else 0 //@Lytd if{table.date} in dateadd("y",-1,{?sdate})to dateadd("y",-1,{?edate}) then {table.amount} else 0 BTW: partially it fetches data, but according my...
  10. hoppeli

    YTD

    Hi Lbass and thanks for your quick response. It did not work. I am quite suspicious of my ytd-formula, which is by the book, i.e. like Crystal guide tells. What might be our advise of the right formula? Tks Hoppeli
  11. hoppeli

    YTD

    Hi. My record selection formula is as follows: {table.date} in {?sdate} to {?edate} or {table.date} in {?comp_sdate} to {?comp_edate} Formula for sales is simply: if {table.date} in {?sdate} to {?edate} then {sales.amount} else 0 (And similar to comparison formula for comparison date range.)...
  12. hoppeli

    Comparing two different date range?!

    Hi Ro, unfortunately I am not the same you thought. I amsure I can do it, unfortunately I do not have enough time to concentrate to work with CR. Learning by doing is in a way good method. Heikki
  13. hoppeli

    Comparing two different date range?!

    Hi Rosemary, I hope you do not think me to be Homer...Truth is I have studied and learned myself all of CR and thus cannot be smart using formulas and comparisons. I have tried to make "or" record selection, but it has not been worked out. I try you advises when I have time to do it. Thanks...
  14. hoppeli

    Comparing two different date range?!

    Hi Rosemary! I use MS SQL 7.0 with CR 8.5. Basically I would like to have as follows: CUSTOMER START DATE- REFERRING START DATE END DATE REFERRING END DATE ---------------------------------------------------------- cust 1 10000...
  15. hoppeli

    Comparing two different date range?!

    How I can compare two user named different date range so that selected records are within date ranges and subtotals and grand totals are right? I should also have headers and totals right in reposrt (not in subreport)! Example: I can have records of parameter dates right and use subreport to...
  16. hoppeli

    comparison formulas

    Hi. I am in a way beginner in CR and using Crystal 8.5. I should compare data between two equivalent period of time. In Record selection I can select the first range of dates but how could I select the previous period of time. Example: there are sales of 2004, and comparison should make to year...

Part and Inventory Search

Back
Top