Variables with multiple conditions
Posted: Tue Apr 01, 2014 12:10 pm
Hi Stimulsoft.
We've been implementing StiReports for the last month, and I've run into an issue that I have not found a technique for doing using Stimulsoft.
In Crystal, we could declare a variable ex. (@SomeName), and we could assign a value to that variable based on an infinite number of nested conditions. For example, if I have two database fields for a product name (ex. Products.Name and Products.VendorProductName) I could tell the Crystal variable to show "VendorProductName" if it is not null over "Name" like so:
In Stimulsoft, to achieve the same result, I have to use a ternary operator in an expression.
My users will not be able to do ternary statements.
My question is, is there a way to do more than one condition in a variable or other data structure within Stimulsoft where I can do something like:
Thanks!
We've been implementing StiReports for the last month, and I've run into an issue that I have not found a technique for doing using Stimulsoft.
In Crystal, we could declare a variable ex. (@SomeName), and we could assign a value to that variable based on an infinite number of nested conditions. For example, if I have two database fields for a product name (ex. Products.Name and Products.VendorProductName) I could tell the Crystal variable to show "VendorProductName" if it is not null over "Name" like so:
Code: Select all
if not isnull({Products.VendorProductName})
then Products.VendorProductName
else {Products.Name}Code: Select all
!string.IsNullOrEmpty(Products.VendorProductName) ? Products.VendorProductName : Products.NameMy question is, is there a way to do more than one condition in a variable or other data structure within Stimulsoft where I can do something like:
Code: Select all
if(string.IsNullOrEmpty(Field1))
{
if(string.IsNullOrEmpty(FIeld2)
Field3;
else
Field2;
}
else
Field1;