How to have multiple constituent solicitors appear side by side in Crystal Reports

Laurie Woelfle

I am setting up a report where I need to show the names of two types of solicitors (Lead and Volunteer) assigned to the constituent in side by side fashion on a Crystal Report. Currently the names are pulling over from the export, but they all appear vertically in one column and for the life of me I can't remember how to get the names of the lead volunteers under one column heading and the Volunteer names under another.

Joshua Bekerman bCLO bCRE

Laurie Woelfle:
I am setting up a report where I need to show the names of two types of solicitors (Lead and Volunteer) assigned to the constituent in side by side fashion on a Crystal Report. Currently the names are pulling over from the export, but they all appear vertically in one column and for the life of me I can't remember how to get the names of the lead volunteers under one column heading and the Volunteer names under another.

Create two formula fields:

- If solicitor type = volunteer then solicitor name

- If solicitor type = lead then solicitor name

 

Laurie Woelfle

Josh Bekerman:

Create two formula fields:

- If solicitor type = volunteer then solicitor name

- If solicitor type = lead then solicitor name

 

Thanks Josh - you know when you stare blankly at a page and know that you really should know how to do this - yep one of those!