November 8, 2016 at 9:21 pm
Hello,
I hope someone can help, I have googled my error but I have not found anything that actually matches my issue. I created a Share Datasource that retrieves info from just one SQL server table, a basic select statement, created a data source for my reporting that points to the shared data source, and created data sets from that. I have added the fields to a basic table, but when I go to Preview there is no data with an error that reads...
Warning1[rsCollationDetectionFailed] The data extension used for the data source ‘My_Data’ failed to detect the default collation properties for the connection. Details: System.InvalidCastException: Specified cast is not valid. at Microsoft.ReportingServices.DataExtensions.SqlGetCollationProperties.GetCollationProperties(IDbCommand command, CultureInfo& culture, Boolean& caseSensitive, Boolean& accentSensitive, Boolean& kanatypeSensitive, Boolean& widthSensitive) at Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapperBase.GetCollationProperties(String& cultureName, Boolean& caseSensitive, Boolean& accentSensitive, Boolean& kanatypeSensitive, Boolean& widthSensitive) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.MergeAutoCollationSettings(IDbConnection connection)c:\users\username\documents\visual studio 2010\projects\Dashboard\Dashboard\Dashboard.rdl00
...the collation is set to 'Default', and none of the other collation choices fit the bill, what I'm a doing wrong? How can I fix this?More that happy to give more info if this is not sufficient. I'm quite new to SSRS, so I have not built up good knowledge on the error types as yet, so I don't really know how to break this down.
Thank you.
Regards,
D.
November 12, 2016 at 1:59 am
What is set for the collation in the Dataset Properties Dialog Box, Options (Report Builder)?
😎
November 14, 2016 at 8:49 pm
Hello,
Thank you for getting back. The collation in the Dataset properties is set to default.
Regards,
D.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply