Patient Data - Lab Reports and Therapies 


Original database row format - Difficult to read and interpret results
dtDateTimeintIDSubjectnvchrCategorynvchrSpecimenNonvchrProcedurenvchrCommentsdecAlbumindecCreatinineintGlucoseintLymphsintMCVdecRDWdecAlkalinePhosphatasedecWBCdecPhenotypicAge
3/30/2021 10:50:00 AM108Measurement089-216-5617-0CMP14+LP+4AC+CBC/D/Plt; Urinalysis, Routine; Vitamin B12 and Folate; Hemoglobin A1c; Thyroxine (T4) Free, Direct, S; TSH; Vitamin D, 25-Hydroxy; C-Full panel. Fasting 10 hr4.30000000000.930000000095379212.400000000048.00000000004.300000000059.9500000000
3/31/2021 12:00:00 AM108Therapy Full Body TransplantNeeded 2 aspirin and a band aid         
4/13/2021 11:04:00 AM108Measurement103-443-0968-0CMP14+LP+4AC+CBC/D/Plt; C-Reactive Protein, CardiacFasting 10.25 hr. CBC/metabolic panel plus CRP4.40000000000.910000000092419212.600000000051.00000000004.100000000059.0900000000
4/15/2021 12:00:00 AM108Therapy Original body restored.Body rejected head!         
7/9/2021 7:22:00 AM108Measurement026-216-7009-0CMP14+LP+4AC+CBC/D/Plt; C-Reactive Protein, Cardiac 4.30000000000.9900000000100409312.200000000047.00000000004.800000000059.7400000000

Easier to read and interpret - data is transposed (pivoted, rows changed to columns, columns to rows) - reads left to right and sorted by date.  Code created table 
DateAndTime
Category
ProcedurePerformed
Comments
PhenotypicAge
CRP
Albumin
Creatinine
Glucose
Lymphs
MCV
RDW
AlkalinePhosphatase
WBC

 




Other interesting displays

Second easier to read example, coded and placed in GridView
DateAndTime
Category
ProcedurePerformed
Comments
PhenotypicAge
CRP
Albumin
Creatinine
Glucose
Lymphs
MCV
RDW
AlkalinePhosphatase
WBC


-------------
Other examples below.  Note: Save the sample below with grid binding DataReader with code (no transpose)



DateAndTime
Category
ProcedurePerformed
Comments
PhenotypicAge
CRP
Albumin
Creatinine
Glucose
Lymphs
MCV
RDW
AlkalinePhosphatase
WBC