Search results for query: *

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

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.

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

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 there, I am using CR 11, SQL database.I have a report that is used to invoice customers on a monthly basis. It is capturing all payments made within a specific time period using the payment.update(datetime) field. My problem is this: say the report is run 5/28/10 at 1700 for the month of...

Using CRXI, SQL Server database. My report has detail as listed below: 05/08/2009 GRANADOS 4 202.50 05/15/2009 GRANADOS 4 337.50 05/22/2009 GRANADOS 4 337.50 05/29/2009 GRANADOS 4 337.50 06/05/2009 GRANADOS 4 135.00 03/26/2010 JACKSON 2 183.84 04/02/2010 JACKSON 2...

Hi, I am using CRXI connecting to a SQL database. This is what data is currently being returned: 010001 10011259 John Doe No 010001 10011259 John Doe No 010001 10011259 John Doe Y Yes 010001 10011259 John Doe Y Yes The column with the Y has null values. How can I eliminate John Doe...

Hi, Using CR 2008 or XI, SQL database. I need to be able to group on a datetime field. This is the data that i am currently getting: 03/05/2010 5:31:28 PM 03/05/2010 3:33:15 PM 03/05/2010 3:55:10 PM Week ending 3/1/2010 5:31:28PM # of validations 3 The 03/05/2010 activity is grouped...

Hello, Using CR11, SQL database. Using the below formula to return a date. WhileReadingRecords; DateVar Array Holidays; DateVar Target:=date({payment.updt_datetime}); NumberVar Add:= 5; NumberVar Added := 0; WHILE Added < Add Do (target := target +1; if dayofweek (target) in 2 to 6 and...

Hi There, I am using CR 11, SQL database. I have a table that stores payment (payment) information and another that stores call information (calllog). I have a report that displays when a payment has actually been processed, using info. from the payment table. When I try to add the check date...

Hi there, I am using CR 11, SQL database My database has participants with a payment.payment_date field and payment.status_lkup_id, with the status_lkup_id field assigned a value of 1974 if the payment has been paid, 1975 if the payment is inactive, 2036 if the payment is ineligible and 2037 if...

I want to add the sql expression created here thread767-1462006 into a report. However, in the field explorer, i don't have the option to add a sql expression field. Is this occuring because I am using a stored procedure to report from? If so, is there another way to accomplish this? I am...

I need to be able to group by year for years up to 2009, but by month if the year is 2009, in a cross tab. I am using the sql expression created in this thread 767-1462006 to group. Thanks.

I have a report that i'm using to find the oldest date entry in the database for a datetime field. For example, when someone is loaded into the database for the first time, the employee.entry field is populated with the date and time of the entry. Each time the employee’s data is updated...

I have a database that stores check detail for each person. Each person can have a differing number of checks. Each check is assigned a status (paid, eligible, or ineligible) and a date. Looks like this: 7/01/2003 paid (1974)...