Search results for query: *

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

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, 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!

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

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

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

I need convert empty or null value to '00/00/00' in report, the column is date type, if I use function Cstr: IF CSTR({DT_RT _TO_CIVPAY}) = '' THEN '00/00/00' ELSE Cstr({DT_RT _TO_CIVPAY}) It works fine for empty value but the real date comes format like: 3/5/2007 12: 00: 00 AM (example) If...