Siebel BIP Reports
Hello,
I have this requirement in Siebel BIP reports.
There are three parameters which will be input by user while running report.
$StartDate Date Required
$EndDate Date Required
$SolId Text Not Required
I have below code in my rtf which is working.
<?for-each-group:contact[UBIAccOpenCanonical >= (psfn:totext($StartDate,"yyyy-MM-dd","MM/dd/yyyy")) and UBIAccOpenCanonical <= (psfn:totext($EndDate,"yyyy-MM-dd","MM/dd/yyyy")) and UBISolIdBIP=$SolId];./UBIBranchBIP?>
Issue is when $SolId is passed it gives records correctly.
But when it is not passed and sent blank then no record is returned. My $SolId is non required so in this case it should return me all the records from database without filtering.