cancel
Showing results for 
Search instead for 
Did you mean: 

Change in Report layout if no of Quarters=16

Former Member
0 Kudos

Hi Experts,

In a Query i hav a variable fiscal yera/quarter(range). When ever i enter the range the report must be generated for all the Quarters with in the range. But there is a situation in which if the diffrence between the FROM & TO (Range) is 16(4 Years) Instead of generating the report for each Quarter,The result must be displayed for each Year(between the range).

2001.1 | 2001.2 | 2001.3 |----so on if the difference between the range is <16.

2001 | 2002 | 2003 | 2004 if the difference between the range is = 16.

How can i achieve this .

Thanks in Advance .

Bhargava

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Bhargava,

AFAIK there is not any way to achieve this automatically.

You could however just add the year as a free char. The users would then have the possibility to swap the quarters with years.

Hope it helps.

BR

Stefan