Notifications
Clear all
Topic starter
Hello,
I'm trying to use Crystal Reports to modify the reforder.rpt file for Referral Orders. This is for physical therapy referral orders specifically. We are trying to add some items such as Therapeutic Exercises, Modalities, Frequency and Duration. Each one of these items is entered on a custom VFE form tied to an obs term.
I linked the obs table in database expert to the document table matching on SDID (Left Outer Join). Then I created a formula field for each obs term I want to add that look like the below with the correct HDID number for each:
if {OBS.HDID} = 254104 then {OBS.OBSVALUE}
When testing this in CPS, if I only fill in one field then it works great, but if I fill in all four fields then they all turn out blank on the referral order form.
Does anybody know why this would happen? Like the multiple obs terms from the same document is confusing the code?
Thanks in advance for your help!
Crystal Price
Posted : August 14, 2017 10:55 am
Two approaches:
1. use subreports to extract each obs term, link on SDID, filter on HDID or obterm Name via link on HDID to ObsHead
2. process variables in detail section, if statements for HDID or Name (easier), use shared variables, display variable in functions in report section, assume in footer.
Both approaches reasonable simple, subreports may be more intuitive. Delighted to help your problem, contact me directly.
Posted : August 15, 2017 3:12 am
Topic starter
thanks jfitzmd! I tried your approach using sub-reports and was able to get what I was looking for. I've never used sub-reports before, but can see how it will come in handy.
Posted : August 17, 2017 12:07 pm
