MS SQL - SSRS 2008 - LastFullMonth
Posted on 2010-09-02
I've converted a Crystal Report to SSRS 2008 and setup the date range parameters as @BeginDate and @EndDate.
Now I want to build another SSRS report from this and change the date range to automatically get the LastFullMonth when the report is ran.
(The overall goal is to make the report so it can be scheduled to run automatically monthly.)
Here's what I have currently for the date section:
(WORKDETAIL.PDATE >= @BeginDate) AND (WORKDETAIL.PDATE <= @EndDate)
To clarify: I only want to return the results for the last FULL month.
Therefore if the report is ran 09/25/2010 it should return all data for August 2010 only
Thanks in advance