Jasper file converts a number field from Data Crow to a String?

0

I have a report using a information via an XML file from the Data Crow program. Everything works fine when producing titles, columns of data etc. No problem at all until I go to sum the entries in a report column. I find that the field variable is listed in Jaspersoft Studio as a string where as it was originally a number field. This means that I am not given the option to SUM the field, only to give a COUNT when I drag the field into the summary band. I iether need to keep number fields as a number when I create and use the data adaptor or to be able to convert a string field to a number field. 

john_44's picture
19
Joined: Jan 11 2016 - 11:10am
Last seen: 4 years 3 months ago

I do not have programming experience and so want to avoid having to edit the source code manually.

john_44 - 4 years 4 months ago

2 Answers:

0

This worked. Thank you. I need to add that it took me over an hour to work out how find the Data Set and Query dialog and make the change. I am running version 6.2.0 and the interface is different from the examples shown in the tutorials. I would post exactly what I did but I have already forgotten which of all the false starts where successful. I hope someone else can post the details.

john_44's picture
19
Joined: Jan 11 2016 - 11:10am
Last seen: 4 years 3 months ago
1

At the bottom half of the Dataset and Query dialog, just set the datatype to Integer.

hozawa's picture
62697
Joined: Apr 24 2010 - 4:31pm
Last seen: 11 months 4 weeks ago
Feedback