ADD a Month calendar to SSRS report
ADD a Month calendar to SSRS report
(OP)
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
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
RE: ADD a Month calendar to SSRS report
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.
RE: ADD a Month calendar to SSRS report
I have no idea what is .aspx page? is it complicated?
RE: ADD a Month calendar to SSRS report
RE: ADD a Month calendar to SSRS report
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 :(