Crystal report Sorting

Hello All,
Please find attached the design view of my report.Currently the report has a grouping of Physicians-Phnpi.I want the report to be sorted by Physican last name.How can it be done.How can I override the phnpi sorting.
Who is Participating?
pjevinConnect With a Mentor Commented:
Still keep the grouping at the NPI, so you group by Facility ID, then Last Name, then NPI, since the NPI is the most unique you will still have it grouping correctly.
You need to create another grouping for the physician last name before the physican NPI, just suppress the header and footer that will result from it.
Star79Author Commented:
but the last name is not unique.There are physicians who have same last name and it clubs theeir data
mlmccConnect With a Mentor Commented:
Another way would be to create a formula to concatenate the last name, first name, and middle name/initial as the second group.  If that still isn't unique, you could concatenate the NPI to the end of the name

All Courses

From novice to tech pro — start learning today.