Condition syntax

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

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.

Post by **Edward** » Mon Mar 23, 2009 10:16 am

Hi Fabio,

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

Thank you.

Fabio Pagano · Post by **Fabio Pagano** » Mon Mar 23, 2009 10:56 am

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:

Thank you.

Post by **Edward** » Wed Mar 25, 2009 9:36 am

Hi Fabio,

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

Thank you.

Fabio Pagano · Post by **Fabio Pagano** » Wed May 27, 2009 1:16 pm

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.

Post by **Jan** » Mon Jun 15, 2009 3:59 am

Hello Fabio,

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

Thank you.