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. Rbp1226

    How to write a formula to get position names in the middle of string

    Hi, I am using Crystal Version 2008 against Oracle 10g database There is a column in database - Position Name Example: Y1928.IT SPECIALIST (APPSW).1987452.ARSE.APPR 218168.INFORMATION TECHNOLOGY SPECIALIST.992467.ARSE.APPR I only want the real name in the middle: IT SPECIALIST (APPSW)...
  2. Rbp1226

    Date selection Formula or SQL help

    lbass, It works Great. Thank you very mcuh!! May I know any other idea if I use universe as data source which SQL expression not available. Thanks!! Rbp1226
  3. Rbp1226

    Date selection Formula or SQL help

    update: dateadd('yyyy', -5, max(date_completed)) Thanks, Rbp1226
  4. Rbp1226

    Date selection Formula or SQL help

    Fisheromacse, thanks for your help, sorry I didn't explain clear, it is not based on currentdate, it based on each persons records to get max date, it should be like: dateadd('yyyy', -5, max(date_completed), I tried few different ways, did not work well. Is there any one have good idea...
  5. Rbp1226

    Date selection Formula or SQL help

    Hello, I am currently using Crystal Report 2008 and oracle 10g; I am trying to find either Report record selection formula or SQL selection to get Date records back to 5 years. For example: Training records: Course_Title Date_Completed Person_ID Network 1/3/2009 1 System...
  6. Rbp1226

    Conversions between UNIX time and normal time

    Hi all, I am based in US, I am using Lbass’s formula and it works good, thank you much for all your help!! Rbp
  7. Rbp1226

    Conversions between UNIX time and normal time

    Hi, Is anyone having good idea how to convert UNIX time to normal DateTime in Crystal? Example: UNIX time: 1174996028 Environment: Crystal Reports XI Oracle 10g Thanks!
  8. Rbp1226

    How to pass value from sub report to main report

    lbass, It works perfect. Thank you so much! Rbp1226
  9. Rbp1226

    How to pass value from sub report to main report

    All, Thanks for all the suggestions! The report actually contents three different reports (with different report title) and use three different table, the customer want combine three reports to one. The issue was – if sub report have more than two pages then the second page will have no...
  10. Rbp1226

    How to pass value from sub report to main report

    I have a report contents main report (with two groups) and two sub reports which located on Report Footer b and Report Footer c, Report Footer a contents grand total for mail report. The sub reports linked with an ID to the main report. I want to pass values from sub reports to mail report in...
  11. Rbp1226

    How to export without Double quotes in Tab Separated Text (TTX) file

    Thanks LB! I tried use edit->find/replace, it was working fine in the beginning but stopped late on, the file was huge size, and I finally wrote SQL statement and used Toad to save as txt file. chelseatech, thanks for the info and provide me this web site Rbp1226
  12. Rbp1226

    How to export without Double quotes in Tab Separated Text (TTX) file

    I need export a format as Tab Separated Text (TTX) file from Crystal Report XI, but customer does not like double quotes for the string fields, it is huge size data, and it need take more than 30 minutes manually replace the double quotes, some times stopped process and could not finish the...
  13. Rbp1226

    Calculation between Numbers and Dates

    Hi LB, The formula works well, Thank you so much! Thank you all your help guys! Rbp
  14. Rbp1226

    Calculation between Numbers and Dates

    Thank you all, This is monthly report, 200801 express January 31, 2008 data, and 200802 express February 28(9), 2008 data…and so on. First I need to convert this number to date, and then subtract DOB to get age. I am still trying to work out. Thank you! Rbp
  15. Rbp1226

    Calculation between Numbers and Dates

    Hi dgillz, This is monthly report, yes, 200801 need convert number to date, DOB is date type. Thanks. Rbp
  16. Rbp1226

    Calculation between Numbers and Dates

    Hi dgillz I am using CRXI Release 1 Thank You!! Rbp
  17. Rbp1226

    Calculation between Numbers and Dates

    Hello Dgillz, You are right, Bob isn't 49 yet, I am still have no good idea for the caculation? Thanks!! Rbp
  18. Rbp1226

    Calculation between Numbers and Dates

    Using CR 11 & Oracle 10g I have a report need calculations between Numbers and Dates, I could not get correct result, is any one can help? Thank you!! Simple example below: Column 1 Column 2 Column 3 200801 01/23/1948 Mike 200801 5/27/1959 Bob The result should be Mike = 60 years old...
  19. Rbp1226

    Converting empty date value to string '00/00/00'

    Hi LB, It works fine; I did change the formatting as date, please see the formula below. Thanks so much for your help!! Rbp If isnull({DT_RT _TO_CIVPAY}) or {DT_RT _TO_CIVPAY} = date(0,0,0) THEN '00/00/00' ELSE totext(date({DT_RT _TO_CIVPAY}))

Part and Inventory Search

Back
Top