How to create an OQL select for a report based on a selection in a datagrid?
0
Hi folks, Is it possible to create dataset for a report based on a selection in a datagrid? Currently I was thinking of doing one of the following two options: 1) OQL statement: FROM Forecast.Forecast AS ForecastObj WHERE ForecastObj/Product = $Product AND ForecastObj/Market = $Market GROUP BY ForecastObj.Period, ForecastObj.ForecastedProfit SELECT ForecastObj/Period AS Period, ForecastObj/ForecastedProfit AS Profit --> But how do i need to setup the variables $Product and $Market so that it is based on the current selection in the datagrid? 2) Writing a java action to which the object on which the selection needs to be based on is passed. Thank you guys for any hint. Best, Felix