I've seen other questions about duplicate lines but not this one so I want to throw it out there.
The database I'm using to pull the information allows certain fields to be pulled more than once but I can only narrow the information pulled by one category. For example there might be a field called mode of transportation and the categories may be car, truck, boat, etc. But under car might be makes like Honda, Toyota, etc. I can pull 2 cars but I can't say pull 1 Honda and 1 Toyota. I want my report to say in one column Honda and another say Toyota. I've got a formula that in one column I mask Toyota so it will only say Honda if there is one and then I alter the formula to mask Honda and only say Toyota, which is great. I've also checked the box to suppress certain fields if it's a duplicate. So it may not give the name twice but it still puts it on multiple lines. I've also tried grouping by the name and that doesn't work. I want to be able to see it all on one line.
Current: John Smith Honda
Toyota
What I'd like to see is: John Smith Honda Toyota
I'm using Crystal Reports 11.5, Windows 10, and Blackbaud Raiser's Edge (if that helps anyone).