Crystal Reports 10 truncates memo field when "Select Distinct Records"

[MargaretL]

Caveat: I am an analyst, not a programmer, and new to Crystal Reports 10.

My report includes a memo field that contains patient comments from surveys -- some of which are very long. They were displaying completely, until I checked the "Select Distinct Records" box from the Database menu. Now they are truncated to 255 characters.

How can I fix this? I need to only show distinct records in the report...

Thank you!

 

[lbass]

You might want to try inserting a group on the patient field and then move the comments field into that group header or group footer without using select distinct records.

-LB