Page 1 of 1

Format suddenly changed from "Numeric" to "Currency"

Posted: Sat Mar 14, 2009 8:59 am
by Fabio Pagano
In a report i designed months ago, i have formatted as "Numeric" some columns containing "decimal" values:

Image

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

Image

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):

Image

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.

Format suddenly changed from "Numeric" to "Currency"

Posted: Mon Mar 16, 2009 1:12 pm
by Jan
Hello Fabio,

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

Thank you.

Format suddenly changed from "Numeric" to "Currency"

Posted: Tue Mar 17, 2009 2:36 pm
by Fabio Pagano
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):

Image

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.

Format suddenly changed from "Numeric" to "Currency"

Posted: Tue Mar 17, 2009 5:34 pm
by Jan
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.

Format suddenly changed from "Numeric" to "Currency"

Posted: Mon Mar 23, 2009 5:29 am
by Fabio Pagano
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"):

Image

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":

Image

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

Image

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

Thank you.

Format suddenly changed from "Numeric" to "Currency"

Posted: Mon Mar 23, 2009 8:38 am
by Edward
Hi Fabio,

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

Thank you.

Format suddenly changed from "Numeric" to "Currency"

Posted: Mon Mar 23, 2009 9:03 am
by Fabio Pagano
No, the field is printed as it comes from the datasource (see grid screenshot in post above), no calculation is made:

Image

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

Thank you.