Search results for query: *

Sorry...I skipped out for a bit... I tried putting in the your suggestion but received zero results.

The ID is returning both the true SSN and the pseudo SSN from the db. Mickey Mouse is listed twice each under his SSN and his pseudo ID. I'm grouping on UniqueMember which consists of {@LastNameShortened} & {CSO_CUS_ORG_Sub.CSO_FIRST_NM} & {CSO_CUS_ORG_Sub.CSO_DOB} & {CSO_CUS_ORG_Sub.CSO_SEX}...

Why wouldn't I want to use the ID as a group for this? I want to group by the VW_HSN.CID_ID...I want to see that Mickey Mouse has an 886 and a true SSN. This is at least getting me the two ID's to show, now I just want to show the most recent of these items. I don't want to see the Donald...

-LB... I already have this in the report... DistinctCount ({VW_HSN.CID_ID}, {@UniqueMember}) > 1 and {LGCEE_ELIGIBILITY_EXTRACT.LGCEE_INSP_EXP_DT} = Maximum ({LGCEE_ELIGIBILITY_EXTRACT.LGCEE_INSP_EXP_DT},{VW_HSN.CID_ID})

Yes...I'll have a parameter that the end-user will put a date in for. Most likely, it'll be with the week they are running it for.

I'm trying to show the most current date on two lines of data based on two different fields called ID#. Basically I have one member with two different SSN's. One SSN is real and one is a pseudo SSN. I need to see this member when one of the dates associated with the member is within a certain...

Thank you, again, fishymetrics! Your assistance was very helpful!! h

Thank you, fishymetrics! This is phenominal! I do have a question though...so I have 94% Same Day, 4% 10 Days, 0% 30 Days and 0% >30 Days and no Bad Dates and No Other...what happened to my other 2%? Could it be that the numbers are so small that they don't come out to 1% for the 30 Days or...

I need to create a Crystal Report (XI) that will show the number and percent of calls completed within the same day, within 10 days, within 30 days and greater than 30 days. The two fields I have to work with are: Service Date (when call was placed) Add TS (when call was completed) Any help...

I need help in showing multiple "cc's" in a sub-report. For example, I need to be able to send a letter to a CEO and then "CC" all of the Union Contacts contained in my report. For example: Mickey Mouse, CEO Donald Duck, Shop Steward Daffy Duck, Union Rep Elmer Fudd, Union Super I need it...

nevermind"...I got it! thanks! h

it's asking for a boolean after the + sign

and it wants something after the last + sign like a number, currency amount, boolean, date, time, etc...

it's saying a boolean is required after my and statement from the previous line

I'm trying to have an amount show up with the actual amount and right fill with zeros so that the field length is always 13...for example 42471 would show as 4247100000000. Right now, in my criteria I have the following...

When I try to format social security numbers, the cells do not hold all nine digits. For example, if there are zeros in the first digits, the zeros are being dropped. I want the zeros to remain there...please help...