Skip to Content
0
Former Member
Sep 12, 2007 at 03:20 PM

Trouble linking subreport

19 Views

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