Once again I've spent a whole morning going in the wrong direction with a convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder ...
... return the SQL date but using your report builder or business intelligence development studio, you can specify in the report designer how to format the returned value to a more user-friendly date format ...
... Solution Explorer > select "Add New Report"
Select the "Shared Data Source" you just created > Next
Click on the "Query Builder" button
Right-click on any empty space in the first frame > Select "A ...
... try their solutions but just check you haven't done this silly mistake.
I'm only guessing the same error would happen in Report Builder 2.0 which I've stopped using as my day job wants ...
Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.