Dynamic Date display using prompt values in Header
I am using Cognos8.3 Report studio.
I need to display in Header of the report as below
Oct 2007 to Nov 2008
Note : Months and years both are Dynamic. Depends on prompt values it should change.
The above should be displayed using 2 prompts.
1st prompt : [OP_FYEAR] year prompt. (It’s mandatory prompt)
2nd prompt : [ZVPPER1] period prompt. (It’s optional prompt)
It’s date range prompt.
From values
To Values
#########################################
1st prompt Values in database :
Z9/2003 (Z92003)
Z9/2004 (Z92004)
Z9/2005 (Z92005)
Z9/2006 (Z92006)
Z9/2007 (Z92007)
Z9/2008 (Z92008)
Z9/2009 (Z92009)
Z9/2010 (Z92010)
Z9/2011 (Z92011)
2nd prompt values in database :
From Values To Values
Period01 (001) Period01 (001)
Period02 (002) Period02 (002)
Period03 (003) Period03 (003)
. .
. .
. .
. .
Period12 (012) Period12 (012)
Default value is Period01 (001) I,e., Oct Default value is Period01 (012) I,e., Sep (next year)
Our client financial year starts from October month end ends on September (next year).
If user wants to see the financial statement for the year 2008 then it should show like
Oct 2007 to Sep 2008
Example 1 :
Step1 :
From first prompt he will select
Z9/2008 (Z92008)
Spet2 :
From the second prompt he can select
From : Period01 (001)
To : Period12 (012)
Or by default it will be
From : Lowest value (Period01 (001))
To : Highest Value ([Period12 (012)])
Result should be displayed :
Oct 2007 to Sep 2008
Example 2 :
see the financial statement for 3 months in the year 2008 then it should show like
Step1 :
From first prompt he will select
Z9/2008 (Z92008)
Spet2 :
From the second prompt he can select
From : Period01 (001)
To : Period03 (003)
Result should be displayed :
Oct 2007 to Dec 2007
Example 3 :
If user wants to see the financial statement for 6 months in the year 2008 then it should show like
Step1 :
From first prompt he will select
Z9/2008 (Z92008)
Spet2 :
From the second prompt he can select
From : Period01 (001)
To : Period06 (006)
Result should be displayed :
Oct 2007 to Mar 2008
Please assist me which functions i need to use and how to display.
Thanks in Advance.