SSRS Report | Report Month Parameter shows data only for current year

Question

Hi There,

SQL & SSRS newbie.

I have an existing SSRS report with a ReportMonth parameter that only shows the current calendar month. (Jan 22) Ideally I want this report to look at the entire financial year (e.g. March 2021 - April 2022). The parameter runs off the following query. Any help is much appreciated:

SELECT DISTINCT
[PERIOD_SHORTNAME]

FROM [Database].[dbo].[PERIOD_STATUS]
where datepart(YEAR, GETDATE())= datepart(Year,STOPDATE)

Answer 1

Hi @Maurice Timoti

I think you can add two parameters ，first one is startdate and second one is enddate，from that you can have a time boundary ，then use it to filter the data，here is my steps，you can have a try.

1. my test table is like
   

2.create a blank report，set the parameter

3.define the dateset

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.