I've built numerous active reports now, and some leverage custom joins created in the report. I can't seem to find how to do this in a dashboard. Is it possible?
Quote from: pacificbeavs on 14 Oct 2019 01:22:45 PM
I've built numerous active reports now, and some leverage custom joins created in the report. I can't seem to find how to do this in a dashboard. Is it possible?
Hi,
You'd need to do the joins in a data module then base the dashboard on this.
Cheers!
MF.
Sounds good, thanks!
Quote from: MFGF on 14 Oct 2019 02:21:56 PM
Hi,
You'd need to do the joins in a data module then base the dashboard on this.
Cheers!
MF.
And how do you create custom joins in data module? Is it possible to create the equivalent to:
select * from A
left join B
on A.f1 = B.f1 and A.f2 > B.f2
Yes, if you have 11.1.4 or higher. Several different relationship operators were added then. Previously, there was only an implicit equi-join.
They are =, < , > , <> , <= , >= , and =N