Is there a way that I can consolidate the following short formula? I'm running CR 7.0
if {?VendorName}='' then
if {?BridalItem}='N' then
{ITMDESCR.Description1} like '*'+{?Pattern}+'*'
else
{ITMDESCR.Description1} like '*'+{?Pattern}+'*' and
({ITEM.WebItemFlag}='Y' or {ITEM.WebItemFlag}='Y')
else
if {?BridalItem}='N' then
{ITMDESCR.Description1} like '*'+{?Pattern}+'*' and
{VENDOR.Name} like '*'+{?Pattern}+'*'
else
{ITMDESCR.Description1} like '*'+{?Pattern}+'*' and
{VENDOR.Name} like '*'+{?Pattern}+'*' and
({ITEM.WebIte
if {?VendorName}='' then
if {?BridalItem}='N' then
{ITMDESCR.Description1} like '*'+{?Pattern}+'*'
else
{ITMDESCR.Description1} like '*'+{?Pattern}+'*' and
({ITEM.WebItemFlag}='Y' or {ITEM.WebItemFlag}='Y')
else
if {?BridalItem}='N' then
{ITMDESCR.Description1} like '*'+{?Pattern}+'*' and
{VENDOR.Name} like '*'+{?Pattern}+'*'
else
{ITMDESCR.Description1} like '*'+{?Pattern}+'*' and
{VENDOR.Name} like '*'+{?Pattern}+'*' and
({ITEM.WebIte