question

misskelly1020 avatar image
misskelly1020 asked

I have a client in Germany using an SSRS report and the date parameter is showing "OKT" instead we need it to be "OCT" for october...... is there a setting to make sure GETDATE() is already converted or will a convert function work???

library!ReportServer_0-45!1554!10/15/2018-10:23:17:: i INFO: RenderForNewSession('/Finance/MC Dashboard')

processing!ReportServer_0-45!10bc!10/15/2018-10:23:17:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'JournalEntries'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Query (5, 39) Cannot convert value 'Okt 14, 2018' of type Text to type Date.

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(CommandBehavior behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)

ssrsssasparametersdates
10 |1200 characters needed characters left characters exceeded

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

0 Answers

· Write an Answer

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.