Questions related to BIRT 2.2

DhavalDhaval Junior Member
edited December 31, 1969 in Designing Analytics Reports
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

  • VirgilVirgil Administrator EM admin
    edited December 31, 1969
    Hi Dhaval,



    1) How does BIRT support internationalization for dynamic data coming for the database?



    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.



    2) Can we use simply Java instead of JavaScript in the functions?



    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 http://www.birt-exchange.com/documentation/BIRT_220/birt-25-1.html





    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?



    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.



    var d = new Date()

    var mEpoch = parseInt(row["user_regdate"]);

    if(mEpoch<10000000000) mEpoch *= 1000;<br />
    d.setTime(mEpoch)

    d;

    Virgil Dodson
    OpenText Analytics Developer Community
    https://forums.opentext.com/forums/categories/analytics

  • DhavalDhaval Junior Member
    edited December 31, 1969
    Thanks Virgil for your help! Hope this will help some of our issues.
Sign In or Register to comment.