Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
parameter number value to text in Select Expert
The values actually go up to 9999. I could use 10000, but was hoping to make asterisk work in Select Expert if possible.- rptg
- Post #7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
parameter number value to text in Select Expert
LB - That would work except zero is actually a value for that field so zero cannot be used.- rptg
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
parameter number value to text in Select Expert
Yes, I am trying to select all records if {?Read_Route} = '*', but this needs to be converted to text within Select Expert. The parameter prompt text reads “Enter Read_Route Number(s) or '*' for ALL:” due to the number of values for this field.- rptg
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
parameter number value to text in Select Expert
Parameter number value needs to be converted to text within Select Expert: (if {?Read_Route} = '*' then {CSS_UTIL_ENVRNMT.READ_ROUTE} = {CSS_UTIL_ENVRNMT.READ_ROUTE} else {CSS_UTIL_ENVRNMT.READ_ROUTE} = {?Read_Route}) Above returns error message that “A string is required here”- rptg
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Display number parameter as text value in Formula
The Formula below contains a number parameter field that needs to function as a text value: Stringvar s:=""; //a string to accumulate the parameter values Numbervar i; // to use a counter For i := 1 to count({?Read_Route}) step 1 do s:=s + ", "+({?Read_Route}) [i]; ProperCase(s) [3 to...- rptg
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
