How to display only one field record horizontally in crystal report

[Former Member]

Hi all,
I'm very new to this platform but found it very great and hoping someone can help me with my query.

I'm not sure how to ask this question but will give it me best.
I'm writing a report which is displaying a field with multiple values vertically hence duplicating it - example below:

1. John Smith Never smoked
2. John Smith Patient Information and referral to Quitline
3. Neena Pratt Ex-smoker
4. Neena Pratt Patient informed and refused Quitline referral

I want this displayed as:
1. John Smith Never smoked Patient Information and referral to Quitline
2. Neena Pratt Ex-smoker Patient informed and refused Quitline referral

Many thanks

Kofstar

[mynynachau]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen/done, make sure you've applied the appropriate tags, and use a more descriptive subject line. The more details you provide, the more likely it is that members will be able to assist you. You should also make sure you're using all the appropriate tags, so the right experts can find your question.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment). By the way, I've removed your email address as it violates our SAP Community rules of engagement: https://community.sap.com/resources/rules-of-engagement

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS . By personalizing your profile with a photo of you, you encourage readers to respond.

Best regards

Mynyna

SAP Community moderator