reporting services - ssrs parameter using lookup -
i'm trying retrive multiple values of same row of dataset. have first parameter uses dataset called "getcyclevie" there retrive row identifier of dataset. have retrive 2 other values of row use parameter in dataset, dtdebut
, dtfin
works in textbox
=lookup( trim(parameters!cyclevie.value) ,trim(fields!cyclevie.value) ,fields!dtdebut.value ,"getcyclevie" )
however when add default value of parameter or if add paramter in dataset following error une expression de la propriété value utilisée pour le paramètre de rapport de l'objet 'dtdebut' fait référence à un champ. les champs ne peuvent pas être utilisés dans les expressions de paramètre de rapport.
translates an expression of property value used report parameter object 'dtdebut' referencing field. field cannot used in parameter expressions of report
i don't need lookup, need retreive multiple values of same row of dataset.
i don't think lookup problem want use in parameter. you're going need create new dataset , base off first parameter.
your new dataset like:
select dtdebut yourtable cyclevie = @cyclevie
then use dataset result other parameter.
here's more info on cascading parameters - https://technet.microsoft.com/en-us/library/aa337498(v=sql.105).aspx
Comments
Post a Comment