×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ADD a Month calendar to SSRS report

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

RE: ADD a Month calendar to SSRS report

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.

RE: ADD a Month calendar to SSRS report

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

RE: ADD a Month calendar to SSRS report

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

RE: ADD a Month calendar to SSRS report

(OP)
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 :(

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close