Skip to Content
Former Member
Oct 20, 2008 at 09:10 AM

Change in Report layout if no of Quarters=16


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 .