Comma problem in strings

I am developing a report that requires me to convert a number into a string. No problem, however once converted into a string, BIRT places a comma as though it was formatting a number. BIRT also does not format integers as such. I am trying to find where I can stop BIRT from putting the commas into the string.

Any ideas would be much appreciated.

Example:
Integer: 584658 converted to string: 584,658

Find more posts tagged with

Comments

bhanley

In what context are you doing the conversion? Via a Value Of tag? Inside some JavaScript? Let me know where and I will give you the correct formatting mask and where to add it.

Lianite

It initially comes from a dataset as an integer, the parameter is where it gets messy.

I have a Cascading Parameter and the second value is Employee ID's which is populated from another dataset, which are returned as integers. Once the parameter is selected, the value of the parameter is converted in the fashion I described above. However, I am trying to do comparisons between the two, so the commas throw the problem.

My company does many conversions of these sorts and having the commas always inserted into numbers converted to strings will prove to be quite problematic.

bhanley

Parameters can be strongly typed. When you set up the parameter set the type via the drop-down (see the attached thumbnail). Perhaps this will solve your problem at the source?

Lianite

The funny thing is that I have set it to string. Attached is my parameter screen.