thank you, i do this but doesnt work correctly, i think this is for that my expressin is in currency mod and have comma between number

this is my expression

right(Format(iif(instr(join(Parameters!productfamily.Value,","),1)>0,CInt(Fields!MSC_hot_q.Value),0)+

iif(instr(join(Parameters!productfamily.Value,","),2)>0,CInt( Fields!MSC_cold_q.Value),0)+

iif(instr(join(Parameters!productfamily.Value,","),3)>0,CInt(...

someone saied me for this problem , create procedure and then call it, but i dont know how to create that

error is

the over construct or statement is not supported

i use ssrs 2005

now i use this code in SQL Server Business Intelligence in sql2008R2

i now try used this code and result was good

select Score, DENSE_RANK() OVER ( order by Score desc) AS Ranking

FROM ...

i dont have adventurework, why this errore accure

my question is diffrent, you think that you have diffrent student, with diffrent score. you wanna get them a level , if two of them have same score , they...

error:The OVER SQL construct or statement is not supported.

i wanna if two customer, have the same score, they be in the same level

for example

if we have four customer with below score

cucode ...

i tried this command, but for same score, rank value is diffrent

is not any response