thanks for the suggestion

getdate() did not work for me but using DateAdd("d",0,Today()) for today's date and DateAdd("d",-1,Today()) for yesterday's date worked

I had a question on automating the report generated by reporting services

At the moment the report can be generated using the reporting services with the start and the end date

When...