Post Author: ebry74
CA Forum: Formula
Hi,
I am using BO XI with SQL 2000.
I am identifying a list of patients on my main report, then using a subreport to pull address based on the medical record numbers on the main report. I have linked my sub report via the medical record number. My main report pulls all the medical record numbers that I would expect, but my sub report only pulls the address that coincides with the very last medical record number in the main report, when I need the address for each medical record number.
Here is what the subreport link looks like:
{dly_acct_fct_v.med_rec_no} = {?Pm-dly_acct_fct_v.med_rec_no}
I also tried to edit it with the following:
{dly_acct_fct_v.med_rec_no} in {?Pm-dly_acct_fct_v.med_rec_no}
and
{dly_acct_fct_v.med_rec_no} in split ({?Pm-dly_acct_fct_v.med_rec_no}, ",",-1,1)
I get the same results no matter what I try. Any suggestions on how I can get an address for every medical record number in my main report on my subreport?
Thanks,
- Bryan