Java Dynamicreports Mix Data Type in One Column
I need to create report with DynamicReports, in one column with mix values data type. Example
-HEADER- | TR.NUMBER | TR.DATE | OWNER | TOTAL | | COLUMN 5 | COLUMN 6 | COLUMN 7 | COLUMN 8 | | ITEM CODE | ITEM NAME | UNIT PRICE | QTY | TOTAL | -CONTAIN- | ABC1231 | 01-02-2020 | NAME 1 | 10000 | | 900101 | ITEM 1 | 100 | 5 | 500 | | 900102 | ITEM 2 | 200 | 1 | 200 | | 900103 | ITEM 3 | 300 | 1 | 300 | | ABC1232 | 02-02-2020 | NAME 2 | 20000 | | 900101 | ITEM 1 | 100 | 8 | 800 | | 900102 | ITEM 2 | 200 | 1 | 200 | | 900103 | ITEM 4 | 500 | 2 | 1000 | | ABC1233 | 02-02-2020 | NAME 3 | 50000 | | 900101 | ITEM 1 | 100 | 50 | 5000 | | ABC1234 | 02-02-2020 | NAME 4 | 20000 | | 900101 | ITEM 1 | 100 | 10 | 1000 | | 900105 | ITEM 5 | 1000 | 1 | 1000 | I need to export it to excel file and upload to another software that read this excel format/template file. So, I can not change the table format.
What I know, 1 column can only contain 1 data type, like String or Integer. In my situation, 1 column mix the value with String and Integer, like in column OWNER and UNIT Price. The OWNER column contain String and UNIT PRICE contain Integer value.
Does any one know, how to solve this situation?
Thank you
