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

displaying date paramter in dynamic drill through

Started by tamirv, 10 Jun 2013 06:48:25 AM

Previous topic - Next topic

tamirv

hi,
i have report wioth dinamic drill through into another report.
in the source report i have date paramter - prmDate- and a crosstab with the column year.
let say, for example, that i filter the report to Quarter1 in year 2011
so i will see in the filter parameterDisplayValue('prmDate') = Q1 2011
and in the crosstab i will get one line of year 2011 (and the data filters for quarter 1 of 2011)
when i will do dynamic drill through to the destination report i want to display the parameter prmDate. of course i have the same parameter in the destination report.
the problem is that no matter what i do, the drill through is passing the context into the parmeter so i am getting Q1 2011, 2011.
(i want just Q1 2011!!) the problem is getting worser when i am filtering for 2 years for example 2011,2012
in this case when i drill through from the row of 2011 i am getting in the destination report : 2011,2012,2011 (the first two number is for the parameter ?prmDate? and the third number is for the context )
please help me!!
tamir