Recent content by SR24

Sorry, I should have clarified this. The values that I will be comparing to the goal table are in the GF3. There are 5 different values in all. Each value would be compared to a goal seperately. I don't think creating 3 levels (a,b,c) of GF3 and suppressing the GF3 levels based on a...

lbass, thanks for the tip. This works great and gives me the shape that I want. Although, I don't see any option that will allow me to control the background color with conditional formatting. I have various score values that need to be compared to a goal table. My users would like the...

Is it possible to display a text box in the shape of an oval as opposed to the standard rectangle? I can't seem to find anything in the format editor that will allow me to change the shape. My users have requested an oval shape with conditional formatting to change the background color. I can...

Thanks for the reply. I tried setting up the ODBC connection. I followed the instructions in the link you provided. Everything works fine until I try to click ok to complete the setup. I am getting an error message that states "Failed to save table attributes of (null) into (null)". Any...

Hi all, I have a text (.txt) file that contains the data that I need for a report. The db administrators for my client have asked if I could use the text file as the datasource so they don't have to set up a procedure to import the file into the database. I understand it's possible to use a...

I'm using Crystal XI. For some reason the cell sizing handles no longer appear when a cell is highlighted. Is this an option that can be turned on or off? Does anyone know how I can turn this back on? Thanks!

Thanks LB. I figured this would be a manual crosstab because of the layout they've requested. Your @Rate formula is what I used in my initial report with the vertical layout for Group 2. I wanted to try to use a crosstab so the column headings would change dynamically going forward as opposed...

I have a single field in the row section of the cross tab named User_02. This field contains the various results, ie O, Y, etc for each Loan number. I am doing a count of Loan number in the summarized Fields section. Date, grouped by month, is in the column field. With this set up counts for...

My client who is using CR 8.5 has asked me to produce a cross tab report which has a summary that calculates a percentage in the middle of the cross tab. I'm not an expert with cross tabs so I'm wondering if this is even possible using a standard cross tab report or if a manual cross tab would...

Thanks LB! Formula 3 works great. I had found a work around to parse Middle Name but this works much better. I found a few records that show the full middle name in the @MiddleName field. Since I can only populate 1 character in this field I modified the formula as follows: if...

I am looking for some help in parsing a string field which contains data as follows: LName, FName MName I need to show the Last, First and Middle Initial in seperate fields. I successfully use the Split function to parse the LName and FName into separate fields but I am having trouble parsing...

Thanks for the quick response. It worked great!

I have a string field which contains numeric data with leading zero's. I've converted this field to a number field and removed the leading zero's but I am having some trouble inserting a decimal point so I can report the field as a currency amount. For example, the string would appear as...

Thanks for the tip. That appears to be the problem. The ClientID of DOE001 was not misspelled but it appears there are records with the same PacketId with a different ClientId that I was unaware of. If I move my WHERE clause into the nested query do you think this will solve my problem?

I am wondering if anyone has any idea why the following query isn't returning the correct number of records. The query used is: SELECT dbo.vw_Debtor.PacketId, dbo.vw_Debtor.FileKey FROM dbo.vw_Debtor INNER JOIN ( SELECT PacketId,MAX(FileKey) FileKey FROM dbo.vw_Debtor GROUP BY...