I am not fully clear about what you are doing but I remember encountering similar problem. instead of a subquery you can create a condition object in the designer itself as follows:
in the where clause window of the condition object say Cond_date just enter the following:
FORECAST.STAGE_DATE = ALL
FROM FORECAST fc_alias
WHERE fc_alias.ID = LEAD.ID AND
fc_alias.STAGE = ‘WON’
Parsing the object will fail because it will not find Lead.ID column because it is not in the from clause. Ignore the failed parse.
Go to the report query panel and drag the condition object Cond_date in the condition window of the query. Try it it should work but as I said I am not sure this is what you want. This will eliminate the sub query to be created by business objects.
bradleyrose (BOB member since 2019-08-29)