It was my understanding that parameters are for values you enter when executing a report, while variables are used to hold a constant or logic changed value which helps automation and does not require user input at runtime.
I have a report with restricted space and want to substitute a column of data containing long text strings with three character abbreviations. These text strings are known and constant (should not change). However if the value is null or unknown I need to display ‘UKN’.
I originally trying to use embedded Iif(, , ) functions to do this but could not get this to work.
In the past I have used variables in Crystal Reports to reformat data values (computer numeric values into user understandable text strings) and have the same need in TDA.
Are you saying that in TDA a parameter is what I should create for use in say a Select Case or IF statement?