Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
left outer join...
- Thread starter Cog8i
- Start date
misscognos
Programmer
two options:
1. fix this up in your model.
2. write your own sql.
There is no other way to do a LOJ in RS. It must be in the model as a 1.1 -> 0.n join in FM.
If you need to have a different join for some reason in the model then:
1. can create a new namespace with the query subjects imported from the db and add your join. In your report, use these.
2. Publish a different package altogher that reflects a left outer join.
1. fix this up in your model.
2. write your own sql.
There is no other way to do a LOJ in RS. It must be in the model as a 1.1 -> 0.n join in FM.
If you need to have a different join for some reason in the model then:
1. can create a new namespace with the query subjects imported from the db and add your join. In your report, use these.
2. Publish a different package altogher that reflects a left outer join.
- Status
Similar threads
- Locked
- Question