Formula to display item

[sondev]

I cannot figure out why this doesnt work!

I have to display the item {?StandardTravel} to show the data only if the BA_TT_CHARGE = "STD". Otherwise I do not need the data to be displayed. I have tried many variations of this in the select expert. None seem to work.

(
if {BILLING_ARRANGEMENTS.BA_TT_CHARGE} <> "STD" then
{?StandardTravel} = ""
else
{BILLING_ARRANGEMENTS.BA_TT_CHARGE} = {?StandardTravel}
)

 

[synapsevampire]

Where are you using this formula?

{?StandardTravel} isn't an item, it's a parameter, the whole posting needs to be reread and rewritten to make sense, why would you show a parameter if a database field is a certain value?

And please at least post your version of Crystal, to be thorough you should post:

Crystal version
database/connectivity used
example data
expected output

If you're trying to limit the rows in the report to what was entered into the parameter, try setting a default value for the parameter {?StandardTravel} to "All", and then use:

(
if {?StandardTravel} <> "All" then
{BILLING_ARRANGEMENTS.BA_TT_CHARGE} = {?StandardTravel}
else
if {?StandardTravel} = "All" then
true
)

-k