Converting multiple rows (CPT Code per Encounter)
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23058
Printed Date: 01 May 2025 at 1:05am
Topic: Converting multiple rows (CPT Code per Encounter)
Posted By: wsc27
Subject: Converting multiple rows (CPT Code per Encounter)
Date Posted: 27 Jan 2025 at 10:22am
I have been asked to try to covert unique records such as MRN that’s been grouped in crystal already, but the issue is that its listing the CPT code for the same encounter in multiple rows. Checking to see if there is a simple way to convert those multiple cpt code rows into its own respective column. See example below……
Currently as
Patient 1 (Grouped) Enc # 111111 CPT 714.5
Enc # 111111 CPT 700.5
Enc # 111111 CPT 800.0
Patient 2 (Grouped) Enc # 222222 CPT 900.4
Would like to convert to
Patient 1 (Grouped) Enc # 111111 CPT 714.5
CPT 700.5 CPT 800.0 ALL ON ONE ROW
Patient 2 (Grouped Enc # 222222 CPT 900.4 ALL ON ONE ROW
Thank you! Any advice would be greatly appreciated!
|
|