Search results for query: *

Hello, Is there a way to group all of the information in a Crystal Report and have it centre on the printing page. I have created a history report for employees using multiple sub-reports, but when I print a page the information is not centred. Will I have to manually move the fields in each...

I am working on a retirement report and I need the age of the person to round down to the nearest whole number. I am currently using the following formula to establish the number of years, (March 31, 2004 - Birthdate)/365 For some people, this report shows 64.6, and then when I try to round it...

Hello, I am working on a report that requires me to have the date appear in a certain format, for instance (YYYYMMDD). When I take the date field and use the following cdate(Field) then the date appears in the correct format. The problem I am running into is that if there is no date in the...

Hello, I am looking to remove leading zero's from employee numbers. The employee numbers do not always start at the same area, ie. an employee number can be 0005656 or 012343. How can I just get rid of the zero's that come before the number. Thanks for your help,

Hello, I am trying to create a formula that will show me the correct award value. For instance, everyone has an award entitled 02A1, but some employees receive an award half way through the year and it is coded 02M1. What I am looking for is for a formula to show me that if an employee has a...

You did assist in a similar question yesterday. That was for the isnull's and how to have blank spaces appear if there is nothing in the field. This is not a homework assignment. I have tried a few different variations of the above since I posted this question. I have tried the following: If...

I am currently working on an ASCII type report. The field I am working with is the city field. The report requires this field to be 20 characters in length, but some of the city names are 21-25 characters in length. I have tried using the following formula, if IsNull ({usrCity.Desc1}) then...

I am currently working on an ASCII report. Each field must start at the same point. I have come to a field based on employee middle names. The problem lies in that some employees have middle names and some do not. The field length for the Middle Name is 12. For those employees that have a...

For this report employees become eligible for our plan the 1st of the month following three months of service. I currently have the following formula Dateadd ("m",4,{eepaystatus.orighiredate}) This formula has allowed me to add 4 months to the original hire date of the employee but...