Hi,
I am building a report to compare, for a project, actual vs budget/forecast. This report uses:
- GL Transaction Details (purpose: retrieve actual cost/revenue) - This is the main source
- Project Forecast Item (purpose: retrieve overall budget/forecast)
- Project Forecast Item Period (purpose: retrieve budget/forecast spread, when it exists)
My repeater is cost/revenue element (a code part value for GL transaction, cost/revenue element for Forecast Item). I have setup an extended repeater connection (as per below screenshot):
When I run the report, it retrieves all the values. However, the rows with the cost/revenue elements used in the other sources (Forecast Item, Forecast Item spread) appear empty (""). The same happen if I reverse the order of the information sources (Forecast Item as main source).
I've looked at the documentation but could not find a solution there. Would anyone be able to advise on how to fix this?
Regards,
Alexis