Knowledge base / Since 1999
Practical Transact-SQL tutorials, troubleshooting notes and implementation guides from real projects.
Advanced search22 entries / Transact-SQL
Clear filters
Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The other formats are: =FormatDateTime(Fields!BirthDate.Value, DateFormat.GeneralDate) =FormatDateTime(Fields!BirthDate.Value, DateFormat...
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 tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report processing. The Group expression used in grouping 'table1_month...
Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx
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 i...
Working principle
This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.
Protected notes
Log in for protected notes and any private client projects assigned to your account.