Recent content by mdj3366

The main report is not returning any data. I forgot to mention the main report is pulling the data via a stored procedure.

Hello - Using Crystal XI, SQL Server database. I have an invoice report that I run monthly for a client. It is run on the first day of the month reporting the previous month's payment activity (only benefit weeks that have been paid). It is grouped by ADP code. My issue is I need to be able...

Hi fisheromacse - the contents of the @date formula is dete({Employee.HireDate}). Thanks.

Thanks for the prompt reply. I am using a datetime field. My formula for (@date) is date(Employee.HireDate). The formula is converting the datetime field of (Employee.HireDate) to a date field.

Hi - I did as suggested and an error was returned "the number of days is out of range". I have a formula to extract the date from a datetime field. The formula you suggested looks like this (@date) + 7 * (Employee.BenefitDuration).

Hello - Using Crystal 11, SQL database. I have a datetime field that I would like to multiply by a number to arrive at the future date. Is this possible? Thanks in advance for any suggestions.

Hi there - Is it possible to create a parameter that stores the last data date and time that the report was run so that i can run the same report from the data date and time to the current datetime? Thanks.

Perfect! Thank you very much, LB! You are truly awesome!!

No, it is grouoped on employee id, then sorted by name ascending.

Almost there. This is what i am getting now using the formula last suggested: Name Pay Code Payment Date Gross Amount Person 1 160 04/29/2011 996.00 Person 1 162 05/13/2011 996.00 Person 2 160 04/29/2011 884.40 Person 2 162 05/13/2011 884.40 Although both have payment dates of 5/6...

Actually, what i posted last is incorrect. That should have read: Person 4 160 05/06/2011 996.00 Person 4 162 05/13/2011 996.00 I do not need to look back any further than the most recent payment code changes. Thanks.

I forgot to include this in the section with your formula: Person 4 160 04/29/2011 996.00 Person 4 162 05/13/2011 996.00 So the formula is somewhat working.

Original data: Name Pay Code Payment Date Gross Amount person 1 160 04/08/2011 700.00 person 1 160 04/15/2011 700.00 person 1 160 04/22/2011 700.00 person 1 160 04/29/2011 700.00 person 1 160 05/06/2011 700.00 person 1 160 05/13/2011 700.00 person 1 160 05/20/2011 700.00...

Thanks for the reply, LB. I am also getting records for those who did not have a pay code that changed. The pay code is a formula: if {payment.Sub}in["Y",""] then "160" else if {payment.Sub}="N" then "162" The selection criteria is this: {org.ORG_NAME} = "Plan" and {payment.payment_date} <=...

Hi there, Using CRXI, SQL database. This is the data as it is pulling now: Name Pay Code payment_date wages Person1 160 03/18/2011 996.00 Person1 160 03/25/2011 996.00 Person1 160 04/01/2011 996.00 Person1 160 04/08/2011 996.00 Person1 160 04/15/2011 996.00 Person1 160 04/22/2011...