cancel
Showing results for 
Search instead for 
Did you mean: 

Record selection as tables joining

Former Member
0 Kudos

Hi All,

I've got 2 tables: Invoices and Images like below. Due to the nature of the report (discussed here) they must be joined within record selection section, not in sql command nor in links, and the joining (or selection in this case) should look like {Invoice.Date}>={Images.DateFrom} and {Invoice.Date}<={Images.DateTo}.


Images table includes records that should appear only on some of the invoices i.e. some invoices will have an image some will not. Joining/selection like the above excludes Invoice.Id=3 because its data does not fall into any images date range. Question is - how can I do the record selection so that all invoices are included even these that have no image?

Invoices

IdDate
12015-01-06
22015-01-16
32015-01-26

Images

IdDateFromDateTo
12015-01-022015-01-18
22015-01-302015-01-31

Regards,

przemek

Accepted Solutions (1)

Accepted Solutions (1)

former_member226669
Participant
0 Kudos

Hi Przemyaslaw,

You can add the Record Selection formula by going to Report -> Selection Formulas -> Record...

Add the below code and save it :

if {Invoice.Date}>={Images.DateFrom} and {Invoice.Date}<={Images.DateTo} then

true

else

false;

Thanks,

Nrupal

Former Member
0 Kudos

Hi Nrupal, unfortunatelly, it didn't work. I've managed to do that vie SQL field, though. Thank you, anyway.

Answers (0)