Notifications
Clear all
Topic starter
I have a CR that totals the CHAD score and it seems to be working fine. Now, I want to add 2 columns - one that would indicate is some way (Y, N) whether or not the patient was on Warfarin/NOAC and a second column that would indicate whether or not the patient is on Plavix/Brillinta. I've tried this by adding the MEDICATE_CHAIN table and because that didn't work, by adding the MEDICATE and MEDINFO tables. But I've got something wrong - the report runs for 10-15 minutes and then returns an error - "Failure to retrieve data from the database." and then another one 'unable to to extend temp segement by 128...". I'm way off track. Can some one help?
Thanks
Posted : April 18, 2017 8:47 am
Contact me directly and I will show you how to solve this problem. Basically, the approach uses the initial digits of the GPI field to establish if the are on Warfarin/NOAC, Plavix/Brillinta.
Posted : April 18, 2017 9:44 am
Would recommend adding a SubReport to your existing detail line (assuming the patient listing is currently printed at the detail line level.)
The SubReport would link via PERSON.PID to MEDICATE and then to the MEDINFO tables.
And then in the SubReport a variable to see if the medication in on the med list for the patient.
Be happy to go into more detail, or attach your report here and it can be augmented.
Posted : April 19, 2017 1:29 am
For complicated reports like this, it is usually easier to write the SQL code you need and then create a custom view or use Crystal Reports database "Commands".
If you need examples of either let me know and I can supply you with some.
Posted : April 20, 2017 3:00 am
Topic starter
Thank you to all who replied. Using SubReports (I needed 2) worked.
Posted : April 26, 2017 7:31 am
