Search results for query: *

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...

Thanks, LB. Now, why didn't I think of that?!

Yes, i want to pass the ?date to the subreport. the subreport already contains a shared variable formula that is returning a sum.

Hi there, Using CRXI, SQL database. In main report, i have a datetime parameter {?Date} on field payment.updatedatetime. In the subreport, i have a datetime parameter {?Date} on field employee.entrydatetime. The subreport contains a variable to pull the date into the main report. I tried...

Hi there – Using CR11, SQL database..I have a report that returns data as listed below: 09/03/2010 0.00 0.00 673.60 Paid 09/10/2010 0.00 0.00 673.60 Paid 09/17/2010 0.00 0.00 673.60 Paid 09/24/2010 0.00 0.00 673.60 Paid 10/01/2010 0.00 0.00 673.60 Paid 10/08/2010...

Hi LB, I have decided to go another route, but thanks for the suggestions and your time!