T-SQL DateTimestamps
- Joel Lipman
- Transact-SQL
- Hits: 7683
- 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? Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to...
This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which...
Applies to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two...
Why? Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want...
Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown...
So I find myself searching the web for a way of producing an outlook-style calendar within Business Intelligence...
system license creator need where database google time script note website joomla added following name first form windows create would report date parameter deluge order version files zoho user case work data list find display table using function used page source mysql code uploaded field error file client server value JoelLipman.Com