Public Profile
  • Allow copy/pasting on row modifier & CALC column to show details at transaction level

    My client is using FR to create Budget Planning summary report in D365. One of the limitation of FR is the ability to list all budget plan documents on a row definition. In order to work around this, we have to manually  create rows with document number filter on the row modifier. Since this is not the only filter that has to be applied (we also apply a book code modifier and budget plan priority), the process to create the report is very painful. Please consider allowing user to copy & paste row modifier from one cell to the next while retaining the filters.

    On another report, we created columns for budget year 1, budget year 2 and a calculated column for the biennium budget. FR doesn't seem to have the ability to show details for CALC column at the transaction level. Therefore, if we have a budget plan with 2 lines: budget year 1 for $1M and budget year 2 for $2 when user drills down to the transaction level, the CALC column will display $0 instead of $1M for the budget year 1 line and $2M for the budget year 2 line. However, the grand total for the CALC column displays $3M. This creates confusion to the users.