ok.

le tme give you example.

exec spname

@name = @item3

this is how i need to execute my sp.

now @item3 is a group , it contains pen and pencil

in my table i have...

no,

this is select statement in my sp,

i need to supply one parameter @name

this contains 2 item suppose pen and pencil,

and it gives me that 2 item ,

now in table w...

do i need to cast it?

how?

float

ya again, my req r change ,plz help

well if i remove exp ,it works

but i need exp

the expression is

... (exp(sum(LOG(1+filed/100)))-1)* 100

this cause the error

i done this way

=iif(Parameters!sortby.Value= "item1",Fields!item.Value,iif(Parameters!sortby.Value = "mv",Fields!MV.Value))

i did this in by right click->tablix properties-?expression

i have multivalued param like this

label value

item ...

but i have only 1 multivalued param,

which has following values

label1 value1

label2 value2

what expression should i put in sorting expression,

thanks a lot,its working

can you tell me where i need to use split?

i already posted my expression

can you post your expression, i am dealing with multivalued also

i did,there are so many parameter, how to see which one is causing problem

the same data set is running in different report,so its not in my sp.now in my report there are so many dataset,how to see which parameter?

but i dont know what is the conversation that i m doing wrong,its in parameter or what.

how to see that