ok.i have multivalued parameter, i use join and now i am using this as hidden expression

not field!value1 ,but it gives me error like hidden expression return invalid data type.

plz explain...

i have declared 5 value

so i m doing like this iif(param.value(0) = "value1" ,false,true)

for second column iif(param.value(1) = "Value2",false,true)

it work for first ,but for the second it gives me error...

value1

whats is the expression

i am writing like this =iif(Parameters!Periods.Value = "value1",FALSE,TRUE)

doesnt work,give me some error

its expression in text box of ssrs

thanks so much , you save me today

thanks solve it with distinct

the problem was in my stored proc, i called 2 stored proc that internally calling function, and i was joinin gthis two function by passing parameter,but my prob was...

its me

i got the solution

i dotn have that parameter in data set, Parameters internal to this proc that are derived from other parameters.

ok. this is

-- Parameters internal to this proc that are derived from other parameters.

but how to solve this error

ya there was some expression, i removed it,but now i am getting another error

the property 'DefaultValue' of report pasrameter 'ConfigurationAnnuliuzeReturns' doesnt have the expected type

i dont hv this parameter in...

hi

i am giving you sample.

the ssrs report previre is like this

sectionid security note

1 mn ...

i tried to do it.

its repeating in second page ,but not on the last page

and also there us 1 extra blank page after each page,how to fix this.please help me

i did this,its nto working.

my problem is inmy row group

there is like

static

static

static

details2

how to up details2 first and then static