Durango122
MIS
Hello
CR 9 MS Sql
I have a problem and draw a blank to resolve this issue
I have a Parameter
{?Compensation}
and is define as string no link to table or field
just this in it and prompts you to select
NO
YES
BOTH
I have a formula call
@Comp
if
{?Compensation} = "Yes"
then
{transaction_history.sales_compensation} = "Y"
else
if
{?Compensation} = "No"
then
{transaction_history.sales_compensation} = "N"
else
if
{?Compensation} = "BOTH"
then
({transaction_history.sales_compensation} = "Y" and
{transaction_history.sales_compensation} = "N")
i draw a blank not sure how to make them work must be getting to old lol lol
1. do i need to link the formula to parameter?
2. should i place these 2 on the report
3. should the {compensation_flag} be link to the formula or the parameter
the field in the table is
SALES_COMPENSATION and it's varchar(1)
Can someone help me please.
thank you
Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40
CR 9 MS Sql
I have a problem and draw a blank to resolve this issue
I have a Parameter
{?Compensation}
and is define as string no link to table or field
just this in it and prompts you to select
NO
YES
BOTH
I have a formula call
@Comp
if
{?Compensation} = "Yes"
then
{transaction_history.sales_compensation} = "Y"
else
if
{?Compensation} = "No"
then
{transaction_history.sales_compensation} = "N"
else
if
{?Compensation} = "BOTH"
then
({transaction_history.sales_compensation} = "Y" and
{transaction_history.sales_compensation} = "N")
i draw a blank not sure how to make them work must be getting to old lol lol
1. do i need to link the formula to parameter?
2. should i place these 2 on the report
3. should the {compensation_flag} be link to the formula or the parameter
the field in the table is
SALES_COMPENSATION and it's varchar(1)
Can someone help me please.
thank you
Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40