how to create dynamic quarter number in column header

(0) Share

Report

Posted on by TMGMFG

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.

I have the same question (0)