I think that the following came from one of Ken Hamady's newsletters some time ago, just cut & paste into a formula field:
The number of "Work Days" between two dates:
Calculating the number of calendar days between two dates is fairly simple. However, if you need to calculate the number of...
I have a series of images stored on a hard drive showing various logos. The images are not stored in the Oracle database along with the other data I am using.
In my crystal report I have a group based on the field {companyname} and I wish to display the appropriate logo for that company. E.g...
A colleague is using Crystal v10 to connect to an Oracle database using an ODBC connection.
When inserting a number field into a report the number is displayed as normal if the number is zero or posiive, however negative numbers are shown incorrectly.
For example -5 is displayed as 65531...
You need to use a running total field.
Summary
Field to summarize: {HOURS}
Type of summary: sum
Evaluate:
Use a formula - click on X=2 button and use the formula
{STATUS}="CLOSED"
Reset
On Change of group - {WORKTYPE}
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.