Recent content by Barb59

Terry, Thank-you so much, that did the trick. Barb

Terry, Thanks for the suggestion. This time the query only returned the employees who had an active 401(k) deduction. It's almost as though the left join from EBase to EDeduct is being ignored or overridden. I managed to pull the data together another way, so please don't spend any more...

Hi Arrowhouse, I ran your query and it too returned 202 rows. I think it's the same dataset as what Terry's query returned Additionally, I don't want to convert the 'NULL' value in d.dedcode to '401K'. I want to leave them alone so I can identify the subgroup who are not deferring into the...

Hi Terry, I do love Source, oddly enough! I've been working with it for 4 years and even though it makes me nuts on a daily basis somehow I still keep coming back. I ran your revised version of the query and it returned all 52 of the employees, but what it also has done is return all active...

I reran using your version of the query; however, it has returned multiple rows of data for the employees. I added d.dedcode to the results to try and figure out what it's doing. What I see is instances where d.dedcode = 401K and others where it's null. Based on what I know about this data...

Thanks for the sharp eyes. Boy do I feel like a bonehead! I'd read in one book that the joins had to be separated with commas, but didn't notice in another book that they were omitted. When I removed the offending comma the syntax of the query was fine. But now there's a new problem... I...

Hi, Here's the problem... I need to identify the deduction amount of people within a predetermined population who have a 401(k) deduction, but I want to return ALL the population in the results even if they do not have a deduction. The tables are... EBase - holds master record information -...

Ken, The report was created, by me, in v7 of Crystal just prior to my attempt to compile/dsitribute it. I have also tried your suggestion of doing the compile/distribute as 2 separate functions - again with no success. I keep thinking there's some minor thing I'm either missing or doing wrong...

I am using Crystal 7.0 Professional and am attempting to compile/distribute a report. I followed these steps: Reports -> Compile Reports. The Compile Report window opens and in the reports section Crystal automatically points to the directory where the report is stored and adds the .exe file...