COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: JGirl on 05 Sep 2005 06:47:04 PM

Title: Handling MYSQL textblobs in Framework Manager
Post by: JGirl on 05 Sep 2005 06:47:04 PM
Hi,

Has anyone had experience with ReportNet reporting from MYSQL?

I tried to create a basic framework on top of the bugzilla schema (the database is MYSQL, and im using the mysql odbc driver), and any SQL that contains a "textblob" type column is not executable.  Anyone have ideas for how to get around this?

When you report off a real database (eg, oracle) and you try to include a blob in the framework, it runs the queries and just includes [blob] in the test data.

The problem here is that I need to report off some of the columns that are textblobs.

J