Date picker issue in SSRS reports hosted in WPF application

0
votes

We have hosted SSRS reports in a WPF application using ReportViewer.

Month selection in the date picker is not working properly. However the date selection through navigation buttons is working fine. The date picker is getting displayed as shown in the below image. On selecting any month returning the current date.

SSRS 2008 report date picker

It needs to work like in calendar control in WPF

WPF calendar control

1
wpfreporting-services
Is the issue that it doesn't look the same? – Joe
No, the issue here is that it does not select the month – user6747322
Apparently, it does work when i preview the report in SQL server BI studio – user6747322
Yes, it will; its using newer technology in BI Studio. But when you deploy to a 2008R2 (or 2012/14) report server, your report is rendered using some very old HTML. As I said in my answer you have two choices: handle it via expression, or upgrade. To be honest, since 2008R2 went out of mainstream support over two years, you need to be planning for the latter anyway – Paul Bambury

1 Answers

1
votes

Not sure what the problem is here. The DatePicker control returns a DateTime object, from which you can then determine the month of that date using a SSRS expression.

If you mean that the Reporting Services control in 2008 R2 isn't as pretty as WPF; its much older tech and there's nothing you can do about that apart from upgrade to SQL Server 2016.