Date Range as Parameter

Create two dataset. The first dataset should link to the date format list and set it as ssrs parameter. Next the 2nd dataset is the actual data to be displayed in the tablix. I am using a custom code to split the parameter.

Public Function SplitDate(byval param as string, byval dateindex as string) as date
Dim a
a = Split(param, "-")
if dateindex = "startdate" then
        return a(0)
else 
        return  a(1)
end if
End Function

Right click the tablix properties and go to filter tab and set the expression of the date field as below,

---

Regards, RSingh