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
Have you thought about setting the date format?
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?
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