Format suddenly changed from "Numeric" to "Currency"

Fabio Pagano · Post by **Fabio Pagano** » Sat Mar 14, 2009 8:59 am

In a report i designed months ago, i have formatted as "Numeric" some columns containing "decimal" values:

Now with version 2009.1.353.0 of 09 March 2009, in designer's preview i have seen these warnings:

Translating from Italian, it is "String was not in the correct input format".

If i go in the format property of those fields (that were formatted as "Numeric") i see that now they are formatted as "Currency" ("Valuta" in Italian):

The result is the same (because, as you see in the last screenshot, the Currency symbol - in the last combobox - is "") but i was wondering the reason of this behavior.

Using version 2009.1.344.0 of 23 february 2009 the message "String was not in the correct input format" doesn't appear, but the format property of the field (previously setted as "Numeric") is showed as "Currency" anyway (instead of the original "Numeric").

Thank you.

Post by **Jan** » Mon Mar 16, 2009 1:12 pm

Hello Fabio,

Please send your report (old version) to support@stimulsoft.com for examination.

Thank you.

Fabio Pagano · Post by **Fabio Pagano** » Tue Mar 17, 2009 2:36 pm

I've not yet sent the report, because i've done more testings. I have not been able to reproduce the problem again, so i think it has been my fault, sorry.

But the "String was not in the correct input format" problem remains (in designer preview):

This seems to happen only on numeric data.

I've tested with 2009.1.335.0 of 16 March 2009.

Let me know if you need the .mrt file and the datasource.

Thank you.

Post by **Jan** » Tue Mar 17, 2009 5:34 pm

Hello Fabio,

This is not critical errors for report rendering. Usually it occurs with columns which contains empty data (which report engine can't detect in some cases) and using some formating or you try apply numeric formating to numeric data which saved as string.

Thank you.

Fabio Pagano · Post by **Fabio Pagano** » Mon Mar 23, 2009 5:29 am

Jan wrote:This is not critical errors for report rendering. Usually it occurs with columns which contains empty data (which report engine can't detect in some cases) and using some formating or you try apply numeric formating to numeric data which saved as string.

It doesn't seem i'm in this situation, the following is tested with 23 March version.

This is the warning that appears ("String was not in correct input format"):

The field "Text9" (for debugging purposes i don't consider the Text11 warning) contains the value of the column "Movimento: Importo lordo".

It is defined as "Decimal" and formatted as "Numeric":

In the data (viewed through integrated grid in Stimulreport designer) i don't see any strange value:

As you already said, the reports works fine, but i'm still wondering why this message appears.

Thank you.

Post by **Edward** » Mon Mar 23, 2009 8:38 am

Hi Fabio,

Maybe you did some additional calculations or castings because there are exceptions while field is being calculated.

Thank you.

Fabio Pagano · Post by **Fabio Pagano** » Mon Mar 23, 2009 9:03 am

No, the field is printed as it comes from the datasource (see grid screenshot in post above), no calculation is made:

I have this problem in other reports and other numeric fields.

Thank you.