ADD a Month calendar to SSRS report 1

[Zara9]

question is: IF I want to add a Calendar in SSRS which I know how to do which pulls data from this year 2010. In that I use startDate and EndDate on bdate column.

For my report I want to add a calendar where it looks for older year date.
FOr example: If I click on August 3rd and EndDate Sept 10. It will not give me any results becuz members weren't born in 2010 year, they were born in 1992. If I dont make any sense, please do ask me. I have multiple of reports where I need to put a calender in SSRS report.
I want to pull members from Jan to current month and ignorning the year. So, if they were born in Jan I will pull them in calendar and end date would be the current month.

So basically I want a month calendar. Thanks for reading my post

 

[RiverGuy]

It would not make sense to use a calendar in this instance. A calendar provides information for day of week along with day of month. So it would truly make no sense to select Tuesday, August 17, 2010 when the user wanted Friday, August 17, 1990.

Your best bet would be to either:

1. Write an .aspx page, and host your report in a ReportViewer control. You can make your own month-selector control and pass in the parameter value to the report.

2. In your SSRS report, provide a drop-down list for the twelve months and either a drop-down list or textbox for the year.

 

[Zara9]

Thanks for replying RiverGuy.
I have no idea what is .aspx page? is it complicated?

 

[RiverGuy]

It's writing a .Net web page. It's complicated for non- .Net developers.

 

[Zara9]

Hi,
Im working on the same report. I know how to get dates between January to Todays.
but I want to get dates from Today to Decemeber or whatever month to whatever month.

(DATEPART(m, bdate) = @StartMonth AND DATEPART(d, bdate) <= 31 OR DATEPART(m, getdate()) = @EndMonth AND DATEPART(d, bdate) <= 31)
this will give me from whatever month to Todays month.

how do i use between function with datepart?
plz help, i have been stuck with this forever now, so many reports to edit