I have installed sql server 2008 reporting services and I already have query, but I want to add parameters to that query in report, and also have date in my query if user dont enter date , it will be default to ..
here my query,
select lastname, firstname, datestarted from tblCustomer where
datestarted > GetDate()- 45
and I want to add a parameter to the report, that datestarted, for user to get prompted to enter datestarted, if it is left empty, that time it will be GetDate() - 45 defaulted..