SSRS Reports Parameters question

• jasosher

  Newbie

  Points: 2

  More actions

  April 12, 2012 at 3:54 pm

  #392012

  I am very new to SQL and SSRS but I have two questions about how to do two small things.

  1. I want to know how to use the Calender GUI for a startdate and enddate parameters. And I do not know how to use this. I have already declared my variables in my stored procedure in which they are put in DateTime format.

  2. This second thing is simple, based on the parameters I choose for my report I want that parameter to show up in my report. For instance if I choose the date range 1/2/2011 to 1/9/2011, then I want to display how to get the report to show:

  The Billing Date is from: 1/2/2011 to 1/9/2011

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  April 12, 2012 at 11:33 pm

  #1473033

  1. http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/02158af9-fc6c-4fed-b4a4-7aa8fab47caf/

  2. Use an expression on the textbox:

  ="The Billing Date is from " + CStr(Parameters!StartDate.Value) + " to " + CStr(Parameters!EndDate.Value)

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP