Home / Questions / 136633
Accepted
HeckDan
Asked: 2020-02-07 09:54:39 +0800 CST 2020-02-07 09:54:39 +0800 CST

Concatenate data in BIRT

  • 772

Greetings, Concatenating data in BIRT is actually simple, the data field is placed: Ejm:

dataSetRow["IMPUESTO"]+" "+(dataSetRow["PVP"]*dataSetRow["IMPUESTO"])/100

where the use of the +" "+ does the concatenation in the BIRT, but if I want to split the content by some character how should I do ? because what you put above would result in:

Taking as an example that the tax is 12 , the amount without tax is 200 and the result of AMOUNT*TAX/100 is 24

1224.00 <<< something like WTF?

if I want something like 12 - 24% or 12 / 24% to remain in the same "Data"

if I put something inside the +" / "+ it doesn't take the concatenation and show me only the first one :( how can I make it work?

eclipse

1 Answers

  1. Best Answer

    It has happened to me that in the Data Type it is in a numerical format, so it is formatted and it does not take the concatenation correctly.

    Check that the Data Type of "DATA" is String type if it accepts any character..

    Right Click on the "DATA" - Edit Data Binding - Data Type: String and voila!

    Haha let me know if this is your case... it happened to me >.<

    • 1