I am trying to create a report in report builder , the query works fine on @date . I have some fields to show the previous date data .
Can it handle in expression ?
Not clear from what you have posted how you are using @Date parameter, if you are using it. If you want to get the date for the day previous to @Date, you can use the DATEADD function that SSRS has.