Hi, I am having a problem displa

[shannonlp]

Hi,

I am having a problem displaying data and I believe it is related to the way my links are set up.

I have 3 tables:

Nps_initv_proj
Nps_cap_initv_outlay
Nps_exp_initv_outlay

Initv_proj_no is what I am joining on amongst the three tables.

Here is my problem:

I have an example of where my report displays Initv_proj_no = 402.
Initv_proj_no = 402 exists in table Nps_exp_initv_outlay but not in Nps_cap_initv_outlay.
If I display the currency field from the nps_exp_initv_outlay table on my report everything is good. But then if also include the currency field from the nps_cap_initv_outlay table no data appears in either field.
For this record where Initv_proj_no = 402 there is only data in the nps_exp_initv_outlay table. I need to display the currency field from both tables because there are other records that will have data in either table.

I believe I need to set up my links so that my report will display data from one table even if there isn’t data in the other.

I'm on CR 12.

Any help would be greatly appreciated.

 

[shannonlp]

Forgot to include subject - sorry. This is regarding linking tables.

 

[IanWaterman]

Join Nps_initv_proj to each of the tables

Nps_cap_initv_outlay
Nps_exp_initv_outlay

Using a left outer join.

Do NOT add any filtering on the l/o joined tables

Ian

 

[shannonlp]

Hi -

Thanks for your response. It turned out that I needed to do a right outer join but its still the same idea. The only thing I'm still unclear on is if it should be Not Enforced, Enforced From, Enforced To, or Enforced Both. I've currently got it set to Enforced Both which seems to be working.