Hi,
I am creating a report in financial reporter to show one quarter data at a time basis the quarter end date selected at the time of running report, which I am able to do.
Problem: How to make quarter number change dynamically in column header?
e.g. Year end is March 31.
If I select date 30-June-2023: Report will give me Quarter -1 data with Quarter 1 written in header.
If I select date 30-Sep-2023: Report should give me Quarter -2 data with Quarter 2 written in header.
I want that when I run report for Q1 the header should show Quarter 1 and if i run report for Q2 column header show Quarter 2 and like wise.
Appreciate, if anyone has any suggestion around this.
PS: currently as a workaround we have created four separate reports for each quarter with quarter number hard coded in each report along with periods. I don't find it efficient.
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156