Thank you so much for your reply,

I only need high id's and dates if there anything available previous to urgent. in this case I need only 111, high and...

Thank...

Thank you I need to check with ltrim(rtrim(avg(datesdiff))) to get in one row. I will keep you posted .

Ya Decimal or integer is ok but what i want in the output is only one row with 1 in it , i.e AVG of all 3 rows. (0+2+3)/3 but...

Thank you Alan,these are working for me. Outer Apply is better for me as well. Thank you so much for your help!

Hi ,

I am unable to run the query , which might be the permissions issue.

but is there a way i can set audit process that can be built to...

It worked for me. Thank you

Sorry below is the correct column expression which we discussed earlier and not working. I copied different column in the above expression.

=Switch(Parameters!audits.Value,"No Audits selected",Array.IndexOf(Parameters!audits.Value, "Member_Not_available_at_Time_of_Service") > -1,iif(Array.IndexOf(Parameters!audits.Value, "Member_Not_available_at_Time_of_Service") >...

Hi Thank very much for your reply .

i changed my expression to =iif(Array.IndexOf(Parameters!audits.Value, "Member_Not_available_at_Time_of_Service]") > -1,false,true) then it is working as expected. i.e when i select Member_Without_Waiver_Code_as_Time_of_Service from dropdown...

here is the error i am coming. Sorry, i forgot to add error at above. Thanks!

when i tried above IIF statement i am getting the below error.

The Hidden expression...

Sure, Not a problem... I will convert to SQL 2008. Anyway thank you for your help.

Hi Drew,

Thanks for your reply but i am getting the below error.

"The Parallel Data Warehouse (PDW) features are not enabled."

Thanks,

kalyan.

Thanks Jason, it works for me.