Skip to Content
avatar image
Former Member

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 .

Bhargava

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 20, 2008 at 09:21 AM

    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

    Add comment
    10|10000 characters needed characters exceeded