Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » type is fixed, for output columns?
type is fixed, for output columns? [message #51913] Mon, 27 June 2005 17:23 Go to next message
Eclipse UserFriend
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 17:36 Go to previous messageGo to next message
Eclipse UserFriend
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 18:57 Go to previous messageGo to next message
Gary Xue is currently offline Gary XueFriend
Messages: 193
Registered: July 2009
Senior Member
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 19:09 Go to previous message
Eclipse UserFriend
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:
  


Current Time: Sat Dec 21 16:46:00 GMT 2024

Powered by FUDForum. Page generated in 0.04514 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top