Recent content by ecsrs

Thanks so much. It worked perfectly. Tried something similar before writing the post but must have had something incorrect.

I am looking for the the most recent score where the score type = 4142. However I want to show all customers even if they do not have a record for scoretype = 4142. In that case I need to display a score of zero. Here is sample data: custid datecreated scoretype score 15146...

Crystal Reports XI SQL database I am trying to filter the most recent score based on a group. My table has customerid, scoretype, score, date created. I have grouped on customerid and under selection formulas - group I added the following formula: {DATECREATED} = Maximum ({DATECREATED}...

I have a string field that I need to split if it is over 30 characters long. I would like to split it inbetween words. How would I write a formula that would split the string at the space before 30 characters. For example: "Please help me with this problem" I would need to split this string...

Thanks, the grouping worked perfectly.

I am using CR 8.5. I have a table which has the following fields: rates, serviceID, fundingID, and effective date. I need to know how to pull the rate for the latest effective date. For example: $5.00 as of 1/1/2004 and $6.00 as of 1/1/2005. How would I tell my report to pull the $6.00 rate...

I have Crystal Reports 8.5 installed on my machine. I am trying to connect to a remote MS SQL server though VPN. In the new connection menu I select: Create New connection -> OLE DB -> MS OLE DB Provider for SQL Server At the next screen when I try to select the SQL server through the drop down...

I found my answer. I didn't know I had to parse the data into 254 length fields first. Thanks anyways for your help.

I am using CR 8.5. My address field is a memo field and I am trying to split the memo field where there is a carriage return. I know I have to use an SQL expression, however I keep getting the following error message: "Error in compiling SQL expression; invalid field found here". Why is it...

Thank you! I have shared your responses with my IT guy who is going to look into the problem for me.

I am using Crystal 8.5 and I am connecting to a dbase database. I am not a systems person so please bare with me. I have a remote location whose database is not on our servers, so I physically went out to the location to try and run reports. They have two computers. One has a MS DOS...

I am on a computer that connects to their database through SCO Termlite. I have an IP address that connects to the database. Is there anyway for me to connect to the database using crystal reports on this computer? Please let me know if I am not being specific enough.

I actually have two questions. 1. I have always used crystal reports 8.5 which allowed you to use the report distribution executables. In version 10 what feature has replaced this or are you not able to create executables anymore? 2. I am on a citrex server and plan to purchase version 10...

I have discovered what is causing the slowness to the report but I am still not sure if there is any solution. The table I am pulling from contains service units that have a client, date, # of units, provider and service type associated with it. Some services require you to put in daily units...

I am using Crystal 8.5 and I have "Perform grouping on server" checked. Dose using 8.5 as opposed to 9 make a difference?