question

TALENZ avatar image
TALENZ asked

Calendar Picker Question

I am wondering if anyone can tell me how I can get my parameter to render as a calendar as opposed to a list of dates based on my SQL statement. I have a dataset that has the last 90 days. If I create a parameter and leave the available values NULL and have a datatype of DATE/TIME, then I get my calendar, but as soon as I supply the values, it reverts to a drop-down list of date values. I hope this makes some sense.
ssrs-2008calendardate picker
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

If you're using a query then you wont get a date picker unfortunately. You can however change the date once clicked. I.E. =IFF([youdate]]
0 Likes 0 ·

1 Answer

·
dpalmer avatar image
dpalmer answered
To get a calendar picker you can't use the SQL statement. When you use SQL to load values it will use that as opposed to the Calendar picker. There ins't a way to load a calendar picker with values from SQL Server. When you use the calendar it won't give you the option of choosing a time with the date so you might have to get a little creative with the way a date is picked to get the correct values. I like to use begin and end date.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.