Using 'Select' to return only first occurrence of a field

[former_member1209466]

Dear Users,

I am a Crystal "newbie" and I've got a question that I'm hoping someone can help me with. I've generated a report in which the fields have got a 1 to 1 relationship with the primary key (see pic1.png).

However when I include a new field - "Activity" which has a many to 1 relationship with the primary key it returns multiple entries for the same patient as you would expect (see pic2.png).

What I want to do is have the "Activity" field

return only the first occurrence. I've tried using the "Group By" functionality with no success, my biggest problem is that I can't get the Formula Editor to recognise my syntax (see bottom of page for example). I use Crystal 2011.

Any help would be greatly appreciated. Thanks -

SELECT
     XXX.'YYY',
FROM
     'XXX' XXX
GROUP BY
     XXX.'YYY'

[abhilash_kumar]

Hi,

Have you tried using the "NHS No." field with a "Distinct Count" in the two graphs?

Abhilash