If you have access to the catalogue or can create your own one, this appears to be a good case for aliasing one of the tables so that the alternative join can be made between the first table and the alias of the second.
Otherwise, as per another of your threads, you can modify the SQL generated and used in the report.
"Time flies like an arrow, but fruit flies like a banana."