Hi friends, I have a report in which i need to default the report to run for last 5 business days (i.e excluding saturday and sunday). I am trying to do this in RDL rather than storeprocedure,but if it is not possible can somebody help me even if it can be done in SQL. Raj

Hi Raj, Are you talking about date report parameter, your query parameter OR talking about creating a report subscription to run the report on weekdays only? I am guessing you're talking about query parameter. Is that correct? If so, you can just say where DATENAME(WeekDay, <your date column>) NOT IN ('Saturday', 'Sunday') HTH, Uzzie