Problems with formatting

[QUALCORP]

Stimulsoft Reports.NET version 2013.3.1800
.NET Framework v4.0.30319

I have a data field in my query that is utilizing the following statement:

Code: Select all

{SumIf(QueryResults.Activity_Amount__Numeric_, QueryResults.Activity_EXPM > 0 )}

I applied the text format for that object as numeric (and currency) so that it should only shows 2 decimals, however, it still produces the result with 4 decimals (ex: 36296.9000).

How can I get this field to format as currency with only two decimals? Ex: $36,296.90

I have attached my .MRT file. The field referenced is directly beneath the object titled "Experience Mod Projection (EXPM)"

Thank you

[Alex K.]

Hello,

Please try to use the Format option.

Thank you.

[QUALCORP]

Hi Aleksey,

I already tried that and it seems to completely ignore whatever setting I input.

Thanks,
Ashley

[HighAley]

Hello, Ashley.

There could be something wrong with data or current culture.\
Could you try our latest build?
If you still have an issue, please, send us sample data for your report that will help us to reproduce the issue.

Thank you.

[QUALCORP]

It appears to not cooperate with the SUMIF statement. When it's a standard data field, it formats just fine, but when it's utilizing the SUMIF statement that's when it refused to accept formatting.

Thanks,

[Alex K.]

Hello,

We couldn't reproduce this bug.
Please try to check the last prerelease build.

Thank you.