Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADD a Month calendar to SSRS report 1

Status
Not open for further replies.
Zara9

Zara9

IS-IT--Management
Joined
Aug 16, 2010
Messages
10
Location
CA
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
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
Thanks for replying RiverGuy.
I have no idea what is .aspx page? is it complicated?
 
Upvote 0 Downvote
It's writing a .Net web page. It's complicated for non- .Net developers.
 
Upvote 0 Downvote
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 :(
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dawnanne
  • Locked
  • Question Question
Loop through rows in an SSRS table
Replies
0
Views
585
dawnanne
dawnanne
how2trainyourdragon
  • Locked
  • Question Question
SSRS export report as JSON
Replies
1
Views
1K
PeterDimitrov
PeterDimitrov
tarikqazza
  • Locked
  • Question Question
SSRS server connection to datasource fail randomly ( sql server 2016)
Replies
0
Views
1K
tarikqazza
tarikqazza
Quotheraven
  • Locked
  • Question Question
SSRS Expression for certification updates
Replies
0
Views
1K
Quotheraven
Quotheraven
Tom_2023
  • Locked
  • Question Question
SSRS wrapping text in Excel
Replies
0
Views
1K
Tom_2023
Tom_2023

Part and Inventory Search

Sponsor

Back
Top