Search results for query: *

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?

It is an SQL database. AN IT guy came down to my computer and thought it was the indexing within the database.

I usually don't have any problem with the speed of my reports, but this particular one is giving me a problem. It is a basic grouping report that sums the data. There is a parameter for the dates. I run it weekly and don't have a problem as long as the week is within one month. But when I run...

I hate to be pain but maybe I am not explaining myself clearly. The report works but I need it to group by week instead of by day. It looks like this: 04/04/2004 - 04/10/2004 (representing 04/04) 04/04/2004 - 04/10/2004 (representing 04/05) 04/04/2004 - 04/10/2004 (representing 04/06)...

I am sorry I should have been more specific. The reason I said manual cross tab is because there are different services. Week Service 1 Service 2 Service 3 4/05-04/11 cost cost cost 04/12-04/18 cost cost cost I just...

I am trying to run a yearly report (manual crosstab) that is broken down into weeks. I have to parameters "begdate" and "enddate". The report will start with the begdate and run each week until the enddate. It is summing unit cost. Basically I want it to look like this: Week...