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
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,
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!
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...
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
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}))
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.