Hi all,
I'm working on a report where I show some KPI's of a plant from a certain country. The user is prompted to select a plant and a country when he is running the report. I have to rank the plant next to the other plants of the country, but I can only show the rank value for the filtered plant. I made a seperate query where I perform the rank for all the plants in the selected country, the ranking is also performed in this query. This query is leading to another query where I filter the plant (detail filter): [Plant] = ?par_Plant?. When I view the tabular data, the correct plant is filtered, and it only show the ranking for the chosen plant. However, when I put it in a list and run the report I get an empy list with 'No Data Available'.
Can anyone help me with this, or does anyone know another solution?
Thanks
How about using a join of two queries instead of a child query?
Thought of that :) did not work. Redid it completely, used a style variable to filter out the plant. Did the trick.
Thanks anyway :)