Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

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.
Thanks.
screenshot.gif
0
Star79
Asked:
Star79
  • 2
2 Solutions
 
pjevinCommented:
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.
0
 
Star79Author Commented:
but the last name is not unique.There are physicians who have same last name and it clubs theeir data
0
 
pjevinCommented:
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.
0
 
mlmccCommented:
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

mlmcc
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now