I’m looking for an example of GI that provides a global summary of project profitability (by project) where each column would include balances by account group type (i.e. Income, Expenses), for any given period, and filtered by Project Template. Each row should contain balances by project/task with columns for Income, Expenses and net.
The challenges I’m encountering includes:
- Finding the appropriate table to provide an appropriate financial period selector for the query parameter.
- Establishing a parameter selector for Project Template that does not generate an “cannot convert <Project Template Name> to integer value”.
Any guidance (or even better, XML files) are appreciated.