Page 1 of 1

iif function(formula)

Posted: Fri Aug 10, 2012 10:00 am
by selvamurthi
Hi
i am new member in this post, i planing to buy stimulsoft reports.Fx of Php

i have few question about stimulsoft

1. how to use (iff Function)
E.g. iif(DataSource1.invoicedate="",DataSource1.orderdate,DataSource1.invoicedate)

2. how to call reportextbox.value. (usually i am using sql (ssrs))
E.g. Like(=reportitems!textbox46.value)

Thanks

selva

Re: iif function(formula)

Posted: Fri Aug 10, 2012 2:03 pm
by HighAley
Hello.
selvamurthi wrote:1. how to use (iff Function)
E.g. iif(DataSource1.invoicedate="",DataSource1.orderdate,DataSource1.invoicedate)
Please, try to use one of two next statements:

Code: Select all

 iif(DataSource1.invoicedate=="",  .......
 iif(DataSource1.invoicedate==null,  .......
selvamurthi wrote:2. how to call reportextbox.value. (usually i am using sql (ssrs))
E.g. Like(=reportitems!textbox46.value)
Unfortunately, the component values is not available in expressions.

Thank you.