Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 05, 2015 at 12:58 AM

    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...).

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2015 at 09:09 AM

    Hi Przemek,

    Could you elaborate on 'I tried to copy and paste the sql query to command but the report loses fields' please?

    You're best bet is to use a SQL Query via the 'Add Command' option for such Joins.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded