If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dynamic Date display using prompt values in Header

Started by elisha, 21 Oct 2008 06:02:34 PM

Previous topic - Next topic

elisha

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.