Questions related to BIRT 2.2

Dhaval
edited February 11, 2022 in Analytics #1
Hi All,
I am evaluating BIRT 2.2 for our project, and was stuck up with the following issues:

1) How does BIRT support internationalization for dynamic data coming for the database?
2) Can we use simply Java instead of JavaScript in the functions?
3) Is it possible to map a date in the database (the date is store in long form in the table) to a normal date time form in BIRT without using JavaScript or java functions?

Comments

  • Virgil Dodson
    Virgil Dodson E admin
    edited December 31, 1969 #2
    Hi Dhaval,<br />
    <br />
    1) How does BIRT support internationalization for dynamic data coming for the database?<br />
    <br />
    If the data is already correct from the database then BIRT will just display it. BIRT also supports localization through resource bundles. In this case, you assign a key value that gets it value from an external resource file. The resource files contain name/value pairs for each locale you want to support.<br />
    <br />
    2) Can we use simply Java instead of JavaScript in the functions?<br />
    <br />
    Yes, with the desired control selected, select the "Event Handlet" option in the Property Editor. Here is where you can specify the class to use. More information is available in the BIRT online help at <a class='bbc_url' href='http://www.birt-exchange.com/documentation/BIRT_220/birt-25-1.html'>http://www.birt-exchange.com/documentation/BIRT_220/birt-25-1.html</a><br />
    <br />
    <br />
    3) Is it possible to map a date in the database (the date is store in long form in the table) to a normal date time form in BIRT without using JavaScript or java functions?<br />
    <br />
    If this is a date field in the database, then it should come across as a Date format in BIRT. If this is stored as text in long date format, then you will need to do some work to change it. One way it to create a computed field in the Data Set and then do your work in the Expression builder like a similar computed column below. <br />
    <br />
    var d = new Date()<br />
    var mEpoch = parseInt(row["user_regdate"]); <br />
    if(mEpoch<10000000000) mEpoch *= 1000;<br />
    d.setTime(mEpoch)<br />
    d;
    Warning No formatter is installed for the format ipb
  • Dhaval
    edited December 31, 1969 #3
    Thanks Virgil for your help! Hope this will help some of our issues.