Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Join on Between

Hi All,

I've got an invoice report with data coming from 2 tables dbo.Head and dbo.Positions joined on Head.InvId=Positions.InvId. I now need to add another table dbo.Images that should be joined on Head.Date between Images.DateFrom and Images.DateTo. Problem is that definition of the report is passed through tables and joins made in Links creator, not a command so I can't make such a join in the Links creator. I tried to copy and paste the sql query to command but the report loses fields. Any idea how to cope with it?

Regards,

Przemek

Former Member
replied

One option is to add the table but remove any joins to it.  Take care of the join logic by adding a record selection condition (Report, Selection Formulas, Record...).

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question