Error - Chart requires column 2 to be of type Integer

Hi, I'm trying to create a piechart LiveReport. I have simple Oracle SQL query like this:select journal, count(*) "N" from ...and it says:Reports of type 'Pie Chart' require column 2 to be of type 'Integer']But it is an Integer. What gives? Thanks!Auto-LiveReport it works, but I get similar messages with Pie Chart or Bar Chart- MarkLivelink ® Version 9.5.0.1.152, Oracle9i Release 9.2.0.6.0

Find more posts tagged with

Comments

Lindsay_Davies

Message from Lindsay Davies <ldavies@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Mark,

This should work.

I was able to do this sort of report in 9501 as a test.

Could be...

missing monthly patches?

overflow? But that should be trapped at the database first

What happens if you cast the count to integer do try to force the datatype?

cast( count(*) as integer) "N"

Regards

Lindsay

European Escalation Team

Open Text (UK)

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 04 June 2009 19:28
To: eLink Recipient
Subject: Error - Chart requires column 2 to be of type Integer

Error - Chart requires column 2 to be of type Integer

Posted by mrunyan (Runyan, Mark) on 2009/06/04 14:26

Hi, I'm trying to create a piechart LiveReport. I have simple Oracle SQL query like this:
select journal, count(*) "N" from ...
and it says:
Reports of type 'Pie Chart' require column 2 to be of type 'Integer']
But it is an Integer. What gives? Thanks!

Auto-LiveReport it works, but I get similar messages with Pie Chart or Bar Chart

- Mark

Livelink ® Version 9.5.0.1.152, Oracle9i Release 9.2.0.6.0