How to format a string in Data Binding

I have a integer value from my database that is a serialized number like 20130000001 and I have a requirement to reformat the string like 2013-0000001. 
 
I tried to call the BirtStr function from the Data Binding dialog and it throws an java exception during rendering. 
 
This is what I have in the Data Binding Expression Builder: 
 
 BirtStr.left(dataSetRow["JobWrit::JobSummary::number"],4) 
 
I do not seem to know where I can call string functions at in BIRT. By the way I am running BIRT Framework 3.7.2 in Eclipse Indigo

Find more posts tagged with

Comments

kclark

You could use something like this 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
var test = "201200000001";
this.text = test.substr(0, 4) + "-" + test.substr(4);</pre>

xenotel

Thanks! 
 
I could get your example to work but when I tried: 
 
var test = row["JobWrit::JobSummary::number"]; 
this.text = test.substr(0, 4) + "-" + test.substr(4); 
 
I get the following errors: 
 
the following items have errors: 
 
ReportDesign (id = 1): 
+ There are errors evaluating script "var test = dataSetRow["JobWrit::JobSummary::number"]; 
this.text = test.substr(0, 4) + "-" + test.substr(4);": 
ReferenceError: "dataSetRow" is not defined. (<inline>#1) (Element ID:1) 
 
I assumed I could reference a Column Binding but it doesnt seem to work. 
 
I also tried to use VALUE-OF formatting like so: 
 
<VALUE-OF>row["JobWrit::JobSummary::number"]</VALUE-OF> 
 
and all I get printed is the literal of the above like: 
 
<VALUE-OF>row["JobWrit::JobSummary::number"]</VALUE-OF> 
 
 
I dont see to know how to get the javascript to evaluate correctly.

kclark

Can you post your rptdesign?

xenotel

<blockquote class='ipsBlockquote' data-author="'kclark'" data-cid="117817" data-time="1371771855" data-date="20 June 2013 - 04:44 PM">
Can you post your rptdesign? </blockquote>
 
 
I attached the designer file for you. I did strip out the user/password from the data even though it was encrypted. :ph34r: