Change reporting period in report painter report

[helen_cagney]

Hello Experts,

I'm trying to change the Fiscal Year of a report in Report Painter so that report can return Year to date values. Currently, Fiscal Year in 'From' column is 0RUPYEA and 'To' column is 0RUYEAR (Reporting Year). Period is From '1PERIV' to "1PERIB'. I tried other variables and Year to date values were not returned. Please advise.

Thanks,

Helen

[JonathanEemans · Accepted solution]

Hi,

'Period from' should always be 1 and not variable if you want year-to-date values.

Year-to-date values are always for one fiscal year. Thus fiscal year should not be a from-to value, but only a from value per column. You can have multiple columns for year-to-date values of different fiscal years, but for year-to-date values there should only be one fiscal year per column.

Best regards,
Jonathan Eemans