Wednesday, October 17, 2012

iPad Event URLs

I just want to post this, because I always need the event codes at different clients, then always end up having to search for it.

Info window popup from image:

Panel Selector:

For Panel Selector in Web see:
For express mode:

or DHTML modes:

Tuesday, August 14, 2012

What DSN is my iServer connecting to?

The Problem:
  • You have multiple Metadata DSNs setup on your server
  • Now you need to find out which one your iServer is connecting to

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"