If a user needs to display blocks of 12 months as years by specifying the end month at run time there is a way of doing it by following the steps below:
1. Create a date prompt in Strategy Tutorial.
2. Put this prompt into a filter with the following definition:
ApplySimple("DateAdd('m',-11,#0)",{Select a Month}).
3. Create a Relationship filter as follows:
Set of Month where (Day (ID) between {Select a Month} and ApplySimple("DateAdd('m',-11,#0)",{Select a Month})) Relate by System Default
4. Create a Custom Group Element using the Relationship filter created in step 3:
5. Create a report with the custom group and attribute Month. Execute the report with a prompt selection of 2/12/2006. The results of the report are:
Notes:
The Relationship filter can be applied directly to the custom group. To do this, select Advanced when editing the Relationship filter and uncheck the box `Also apply this qualification independently of the relationship filter`.
