Notifications
Clear all
General Discussion
6
Posts
4
Users
0
Reactions
99
Views
Topic starter
for some reason when some of our users print a lab requisition with an icd9 and icd10 dx code attached the order prints both codes while for others the only the icd9 code prints. we are making ourselves crazy trying to figure out why. help?
Posted : September 29, 2015 3:53 pm
We ran into this issue. We have several custom crystal reports that print for various service providers. The basic 'test form' reports that GE provides are updated during upgrade, but anything custom we had to manually update... here's what we did to each report to accomplish this:
Add MASTERDIAGNOSIS table (link ORDDX.ICD10MASTERDIAGNOSISID MASTERDIAGNOSIS.MASTERDIAGNOSISID using left outer join)
Update the “Diagnosis” formula within the report to be:
StringVar diag := {ORDDX.DXDESC} ;
StringVar icd9Code:={ORDDX.DXCODE};
StringVar icd10Code:={MASTERDIAGNOSIS.CODE};
if StrCmp (icd9Code, "ICD-" ) = 0 then
(
icd9Code := "";
);
if icd9Code "" and icd10Code "" then
(
diag:=diag + " (" + icd9Code + ")" + " (ICD10-" + icd10Code + ")";
)
else if icd9Code = "" and icd10Code "" then
(
diag:=diag + " (ICD10-" + icd10Code + ")";
)
else if icd10Code = "" and icd9Code "" then
(
diag:=diag+ " (" + icd9Code + ")";
);
diag;
Posted : September 30, 2015 2:58 am
Thank you!!!
Posted : September 30, 2015 9:03 am
I tried this but I can't find this in our database: StringVar icd10Code:={MASTERDIAGNOSIS.CODE};
What version of Crystal are you using? Thinking it may have something to do with that. We have version 11
Posted : October 1, 2015 6:49 am
In the current connections folder right click on the ML table and select options. In here you want to type in the Table name LIKE: MASTERDIAGNOSIS. You'll locate the table and be able to add it. I think we're on an outdated version of Crystal Reports :(.
-Mike
Posted : October 1, 2015 6:56 am
thank you!!!!
Posted : October 1, 2015 7:04 am
