other results in framework manager than in cognos connection cross join

[curious]

I have one company.table with company name, lowest retailer number and highest retailer number
I have one retailer.table with retailer name, retailer number

To find out for which company a retailer works, his retailer number has to be between the lowest and highest number in the company table.
In framework manager i made a cross join.

.... where ((company.lowest retailer number <= retailer.retailer number) and (company.highest retailer number >= retailer.retailer number) )

In framework manager I receive the correct information. The retailer is related to the right in company.
When creating a report however, the retailer is related to every company in the company table.

In the properties I set cross joins to allowed.

What am I doing wrong ?

[blom0344]

This actually is no cross-join. It is officially called a 'non-equi' or 'theta' join. A cross join yields  n*m results for tables with n resp. m rows, cause no relationship is defined btween the tables. So, you should not need to allow cross-joins.
If lowest retailer number and highest retailer number
have no overlap between rows in the company table,then you should have no multiplying of rows in the resultset..

[curious]

Hello blom0344.

Thank you for your answer.
I found the cause of the wrong results. There was another table that caused the problem.