well, here is my issue. I'm pulling records out of this database in crystal report8.5 and i need show the prices of items that hasnt been updated w/o the effective date 5/1/02. For example,
Old List before sort
123 1/1/00 New List after sort
123 3/1/02 =========== 345 5/1/00
123...
well, i have this field with m,t,s that suppose to be translated into m=!, t=#, and s=* to indicate various shipping or purchase items. However, i have failed to translate those letter into the symbols by using select expert. So my question is what do i need to use in CR8.5 to translate the...
Hi Dgillz,
It's working! thank you so much!Do you know where i can learn more about Crystal Rpeort formulas? I have couple website plus some books but this problem wasnt addressed. Again, thanks
Well, here is some example of the data !
OneWorld Xe CR8.5 (should convert it as yr/month/date)
098185 --------> 1998/7/4
102038 --------> 2002/2/7
And when I extract the date field into CR8.5, it converts 102038 into 102,038.00 so how can I get rid of the decimals
Well, here is my issue. I'm trying to export the date field from ONEWORLD Xe into crystal report 8.5. However, the date format that crystal report 8.5 uses is GREGORIAN calendar and OneWorld Xe uses the Julian calendar. So when I extract the date field from ONEWORLD Xe into crystal report 8.5...
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.