Page 1 of 1

Condition syntax

Posted: Mon Mar 23, 2009 9:53 am
by Fabio Pagano
Using 23 March 2009 version.

In a field condition i've put the following formula:

Totals.Sum(RaggruppamentoImpianto,System.Convert.ToInt32(IIF(Movimenti.[Origine: Stato fatturazione]=="Da fatt.",Movimenti.[Origine: Importo totale],0)))==0

but in designer preview i receive the following error:

"Sign ) required"
") is an invalid term in the expression"
"; required"

each one repeated twice.

Need help.

Thank you.

Condition syntax

Posted: Mon Mar 23, 2009 10:16 am
by Edward
Hi Fabio,

Please send this report template to support[at]stimulsoft.com for analysis.

Thank you.

Condition syntax

Posted: Mon Mar 23, 2009 10:56 am
by Fabio Pagano
Look at the attachment "IIf_In_Condition.mrt".

The field where i put the condition:

"Totals.Sum(RaggruppamentoImpianto,System.Convert.ToInt32(IIF(Movimenti.[Origine: Stato fatturazione]=="Da fatt.",Movimenti.[Origine: Importo totale],0)))==0"

is called "Testo45" and is the one in square red here:

Image

Thank you.

Condition syntax

Posted: Wed Mar 25, 2009 9:36 am
by Edward
Hi Fabio,

Thank you very much for the test report. We will inform you when the patch is available.

Thank you.

Condition syntax

Posted: Wed May 27, 2009 1:16 pm
by Fabio Pagano
Any new on this issue? In 25 May 2009 version the problem is still there.

Examining the autogenerated code, i see at line 438 (one of the offending lines):

Code: Select all

public void GetTotal1(object sender, Stimulsoft.Report.Events.StiValueEventArgs e)
        {
            e.Value = System.Convert.ToInt32(IIF(Movimenti.Origine__Stato_fatturazione=="Da fatt.";
        }
It seems that the "IIF" has been truncated.

Thank you.

Condition syntax

Posted: Mon Jun 15, 2009 3:59 am
by Jan
Hello Fabio,

Patch for this problem will be available in build from 15 June.

Thank you.