T-SQL DateTimestamps
- Joel Lipman
- Transact-SQL
- Hits: 7685
- Windows XP SP3
- MS SQL Server Management Studio 2008
- SQL Server 2008 R2
- Regional Setting: London BST (British Summer Time)
=FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate)
=FormatDateTime(Fields!BirthDate.Value, DateFormat.GeneralDate) =FormatDateTime(Fields!BirthDate.Value, DateFormat.LongDate) =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) =FormatDateTime(Fields!BirthDate.Value, DateFormat.LongTime) =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortTime)
An error occurred during local report processing. An error has occurred during report processing. The Group expression used in grouping 'table1_month' returned a data type that is not valid.
Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't 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 us to use Business Intelligence Development Studio for all our SQL Server Analysis Service (SSAS) and Reporting Service (SSRS) projects/solutions. The features and interface are very similar when developing reports though.
The error I'd get was
An error occurred during local report processing.
An error has occurred during report processing.
Cannot read the next data row for the dataset DataSet1.
Conversion failed when converting date and/or time from character string.
Thought I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I...
What? This took me a while to find so I've posted an article below detailing how to parse or extract values from a...
What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a...
This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which...
What? This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and...
What? This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following...
What? This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact...
page windows user creator would table form order work file field using used date client where uploaded deluge server mysql display google note error list zoho name need first joomla files script license case data report value create added source code system find following function website parameter time version database JoelLipman.Com