Search

SSRS 2012 date parameter error - MM/DD/YYYY by Seaneyw

Active

1
0
Sign in
to vote
Type: Bug
ID: 778940
Opened: 2/11/2013 4:00:18 AM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
I have recently upgraded our environment to SQL 2012 SP1 with SharePoint 2010 integrated mode. The problem I have is that when we use date parameters in reports once clicking apply or any post back happens the date format in the parameters changes from the correct UK DD/MM/YYYY format to the US MM/DD/YYYY. The report runs correctly however this is confusing users.

Addiitonally default dates added to the parameters always display in the US format when we first open the report.

After browsing the MS social site is has been suggested that this issue was fixed in CU5 but then removed for SP1.
Details (expand)

Product Language

English

Version

SQL Server 2012 - Enterprise Edition

Category

Reporting Services

Operating System

Windows Server 2008 R2 Enterprise

Operating System Language

English

Steps to Reproduce

Deploy an SSRS report with date params to a SharePoint site with UK regional settings, chose a date and once apply button is clicked see the change in the date setting.

Actual Results

MM/DD/YYYY

Expected Results

CC/MM/YYYY

Platform

X64

Virtualization

Other (e.g. VM Ware, specify in Description)
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.