I have two datasources in a report:
1. OPEN ORDER: select uid_personwantsorg from PersonWantsOrg where OrderState = 'OrderProduct'
2. POSSIBLE CONFIRMATORS: select r.UID_PersonHead from dbo.QER_FTPwoNextDecisionMaker( @OrderState.uid_personwantsorg ) r
How to force the second view (POSSIBLE CONFIRMATORS) to produce the detail for every OPEN ORDER (...like a detail pane).
@OrderState.uid_personwantsorg is not working in this form (tried it with setting OPEN ORDER as parent query)
I can not use relation as I call a function.