Eclipse Community Forums: BIRT » type is fixed, for output columns?

Home » Archived » BIRT » type is fixed, for output columns?

type is fixed, for output columns? [message #51913]

Mon, 27 June 2005 13:23

Eclipse User

Originally posted by: no.spam.com

When I view the output columns of an dataset, the 'type' doesn't change.
Is this normal? Should that be able to be manipulated, or is it read-only
and based on the input data source?

And if the answer is yes, anyone have advice as to what to do if your data
is coming across as strings, and you need to use in charts (thus need it
as a number format)? In my scenario I don't have control of the process
generating the data, and thus have to work with it after its created (with
the inaccurate data type).

Any info appreciated...

Re: type is fixed, for output columns? [message #51940 is a reply to message #51913]

Mon, 27 June 2005 13:36

Eclipse User

Originally posted by: no.spam.com

As a followup, it appears from the help files that the string data type
shouldn't cause problems, but I get the unable to render chart error --
"Unable to compute a percent/stacked axis containing non-numerical data"

Re: type is fixed, for output columns? [message #51966 is a reply to message #51940]

Mon, 27 June 2005 14:57

Eclipse User

The data type of an output column comes from the data set's ODA driver (for
JDBC data sets, this information comes from the JDBC driver). It cannot
currently be changed.
However BIRT is designed to be loosely typed. Implicit data conversion is
done whenever appropriate. For example, a String column will be converted
implicitly to numeric if the context of the column usage calls for such a
conversion. If this is not working for you please file a bugzilla report.
As a workaround, you can create a computed column on your data set. Define a
Javascript expression for the computed column to convert your String data to
Numeric, then use the computed column to build your chart.

Gary

"Mark S." <no@spam.com> wrote in message
news:13979c2281e981eb6c2501f5dd10ccd7$1@www.eclipse.org...
> As a followup, it appears from the help files that the string data type
> shouldn't cause problems, but I get the unable to render chart error --
> "Unable to compute a percent/stacked axis containing non-numerical data"
>

Re: type is fixed, for output columns? [message #51991 is a reply to message #51966]

Mon, 27 June 2005 15:09

Eclipse User

Originally posted by: no.spam.com

Gary Xue wrote:

> ...
> As a workaround, you can create a computed column on your data set. Define a
> Javascript expression for the computed column to convert your String data to
> Numeric, then use the computed column to build your chart.

Thanks Gary. What would this expression be like? I am familiar with
ToString() -- is there something I can do the opposite with and force to a
number format?

Previous Topic:	page breaking
Next Topic:	Running a report from report engine

Goto Forum:

-=] Back to Top [=-

Current Time: Sun May 11 11:07:01 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter