Hi Everyone I have a crystal report. I have a grouping in a report. The grouping is called household and the typical value is something like this:
Mr & Mrs John and Jane Doe or something like that.
I want the sort to be as such though on a different field called lastname in alpha asc order.
Right now because I have my grouping household which I do need so I can group like records it puts them in all kinds of order.