Search results for query: *

I have created a report that has a lot of lines per employee and what I am trying to do is suppress the details and show only the summarized fields in the group footer section. The problem is that when trying to insert a summary the formula field that I created is not showing up as a...

I am trying to set up a formula to calculate the first of the month after 30 days. So the field is called Benefit date let's say the value is 7/13/2006. I am trying to write a formula that will add 30 days (8/13/2006) and then display the first of the following month (9/1/2006). Any help would...

Hi All, I am on Crystal 11 and have a question about getting the date that an employee attended a training course. The training courses are on a different table than the employee and there is a one to many relationship between employee and training history. This is what the data looks like...

I have an excel file with multiple worksheets and I am trying to have condition which returns different cells based on different criteria being met. This is the formla that I am trying to use: =IF(B6<='Pricing'!C3,'Pricing'!C5) (IF(AND(B6>'Pricing '!C3, B6<='Pricing'!D3),'Pricing'!D5)) I get...

I am on Crystal XI and I have a table that contains Dates that Team Members got a pay rate increase. Below is sample data: Employee ID Pay Rate Beg Date Pay Rate 13 01/01/1998 $7.00 13 02/05/2000 $8.25 13...

I have two tables (Employee & Positions). Table Employee ID Employee Name ================================= 9999 John Doe 9998 Jane Doe 9997 Sally Doe Table Positions ================================= ID EmployeeID Position Start Date Baker...

I am trying to convert a date that is currently stored as a timestamp to a string but I need to have it come back in the following format YYYYMMDD. Right now I am using the following CStr ({Table.Field}) this converts the field to a string but doesn't report it in the correct format. Any help...

I am trying to create my first fixed file format report using Crystal. The report is rather large and has about 100 columns of data. I don't want to print the file on a page, I just want to generate a file to send to a vendor. The previous reporting software that I used, I could have fields on...

Hi All, I'm new to using Access as a program to run queries. I used to use our old HRIS software, but now am forced to run queries through Access. So I have a table of Data which contains employees where each employee can have one row or as many as 20 rows of data. Each row of data contains a...