CODEWITHSUNDEEP
reporting-servicesparameterslookup
Flying Turtle
Flying Turtle

Reputation: 364

ssrs parameter using lookup

I'm trying to retrive multiple values of the same row of a dataset. I have a first parameter that uses the dataset called "getCycleVie" from there I retrive the row identifier of the dataset. I have to retrive the two other values of that row to use for a parameter in another dataset, the dtdebut and the dtfin This works in a textbox

=Lookup( Trim(Parameters!CycleVie.Value) ,Trim(Fields!cyclevie.Value) ,Fields!dtdebut.Value ,"getCycleVie" )

however when I add it as the default value of a parameter or if I add it as a paramter in a dataset I get the 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. which roughly translates to an expression of the property value used for the report parameter object 'dtdebut' is referencing a field. a field cannot be used in the parameter expressions of the report

I don't necessarily need my lookup, all I need is to retreive multiple values of the same row of a dataset.

Upvotes: 0

Views: 3995

Answers (1)

Hannover Fist
Hannover Fist

Reputation: 10860

I don't think the lookup is the problem but that you want to use it in a parameter. You're probably going to need to create a new dataset and base it off your first parameter.

Your new dataset would look something like:

SELECT dtdebut 
FROM YOURTABLE
WHERE cyclevie = @CycleVie

Then use the dataset result for your other parameter.

Here's more info on Cascading Parameters - https://technet.microsoft.com/en-us/library/aa337498(v=sql.105).aspx

Upvotes: 2

Related Questions