Search results for query: *

fisheromacse, It works fine. Thanks! Rbp

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

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

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

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

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

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

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!

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

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

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

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

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

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

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

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

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

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

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

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}))