locked
SSRS- Date Picker param RRS feed

  • Question

  • Hi,

    Can anyone tell me how to create the date picker param in SSRS reports,and explain how is that param linking to the database?

     

     

    Thanks,

    Vinoth

    Thursday, October 27, 2011 2:25 PM

Answers

  • For a parameter to be rendered as a date picker, you simply need to make the datatype of the column datetime.  This has no inherent relationship with a database, but you can create a dataset to get a specific date and reference that dataset in the parameter as a default value.

    Hope that helps,

    Mark

    • Marked as answer by Lola Wang Tuesday, November 1, 2011 7:11 AM
    Friday, October 28, 2011 1:33 AM

All replies

  • For a parameter to be rendered as a date picker, you simply need to make the datatype of the column datetime.  This has no inherent relationship with a database, but you can create a dataset to get a specific date and reference that dataset in the parameter as a default value.

    Hope that helps,

    Mark

    Friday, October 28, 2011 1:32 AM
  • For a parameter to be rendered as a date picker, you simply need to make the datatype of the column datetime.  This has no inherent relationship with a database, but you can create a dataset to get a specific date and reference that dataset in the parameter as a default value.

    Hope that helps,

    Mark

    • Marked as answer by Lola Wang Tuesday, November 1, 2011 7:11 AM
    Friday, October 28, 2011 1:33 AM