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

[Closed] Drill through value passed

Started by kapil, 20 Oct 2005 02:22:28 AM

Previous topic - Next topic

kapil

I have two reports - parent and child
parent report has a text item as date, which when i chooses comes as :

Date : Aug 12 , 2005

When i drill through and goes to child report which also has date text item, it changes to:

Date : 2005-08-12

How shud i ensure that i get same format in child report as well?
help

sir_jeroen

Have you thought about setting the date format?

kapil

i have included date like this in my parent report:

'Promised Date ' +  IF(ParamDisplayValue("Parameter1")=ParamDisplayValue("Promise Date Key")) then (' On '+ ParamDisplayValue("Parameter1") ) else (' Between ' + ParamDisplayValue("Parameter1")+ ' And ' + ParamDisplayValue("Promise Date Key"))

and same in child
in parent when i select dates from promt , i get format as eg.  Aug 10 , 2000

but when i drill thru to child report
it doesnt accept the default format
and make it
2000-08-10

pls advice
date format in child report shud i work on?





sir_jeroen

What is the displayvalue of your parameter and what is the value?
Eg.  if you have 1 = Yes and 2 = No then Displayvalue for 1 = Yes and value = 1