donnarenia
Technical User
I have the following two selection record formulas
if {?Salesperson}= "Salesperson 1" then
{CLNTCUS.~Custom3} = {?Employee} and
{@DatesRemaining} < 13.00 and
{AR.InvoiceDate} = {?Invoice Date} and
{AR.Type} = "I" else
if {?Salesperson}="Salesperson 2" then
{CLNTCUS.~Custom21} = {?Employee} and
{@DatesRemaining} < 13.00 and
{AR.InvoiceDate} = {?Invoice Date} and
{AR.Type} = "I"
How can I combine them to get Salesperson 1 and Salesperson 2 information to show on one report.
if {?Salesperson}= "Salesperson 1" then
{CLNTCUS.~Custom3} = {?Employee} and
{@DatesRemaining} < 13.00 and
{AR.InvoiceDate} = {?Invoice Date} and
{AR.Type} = "I" else
if {?Salesperson}="Salesperson 2" then
{CLNTCUS.~Custom21} = {?Employee} and
{@DatesRemaining} < 13.00 and
{AR.InvoiceDate} = {?Invoice Date} and
{AR.Type} = "I"
How can I combine them to get Salesperson 1 and Salesperson 2 information to show on one report.