Link to home
Create AccountLog in
Avatar of Chopp
ChoppFlag for United States of America

asked on

Adding a Field to Report from Left Joined Table Causes Records to be Excluded

Hello Experts,

When I add a field from a table that is left joined in my data model, to the report, some records are excluded.  When I remove the field, the records are not excluded.  Can you explain why this happens?  

Thank you.
~chopp
Avatar of Peter Kiprop
Peter Kiprop
Flag of Kenya image

Hi Chopp,

You may need to go to Visual linking expert, choose the link and try selecting left or right outer joins under link options.

Hope this works.

Regards,
Pthepebble.
ASKER CERTIFIED SOLUTION
Avatar of James0628
James0628

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Chopp

ASKER

Thank you, James.  I ended up using a SQL view to manipulate my data.
Respectfully, Chopp
Avatar of James0628
James0628

Glad you were able to work it out.  Sometimes a manual query is the best way to go, especially if you're comfortable writing your own queries.

 James