Tuesday, July 3, 2012

Collation Conflict Error

We got the following error at one of our clients:

Status: Execution failed
Error: SQL Generation CompleteQueryEngine encountered error: Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42000:468: on SQLHANDLE]
Cannot resolve the collation conflict between "SQL_Latin_General_CP1_CI_AS" and "Latin1_General_CI_AS"

This error occurred on one of our reports after we switched our DW database to a different server.
We are running on MSSQL 2008 R2.

Monday, July 2, 2012

Advanced Custom Grouping based on Prompt

How do you display prompted elements on a report, and at the same time display all those not selected as a single Element called "Other"