Dataset Column Expression With Conditional Outputs
Posted on 2004-09-20
How do you set a column expression to assign a large number of string values that are determined by an existing column value?
I have numbers ranging from 0 to 30 say in my existing [New Score] column. I wan't my column expression on my [Level] column to show the following:
New Score Level
I have used an IIF statement before to handle just two classifications "High" and "Low" levels, but cannot get VB.NET to extend to the multiple-argument. The line below works fine for two [Level] values only.
ds.Tables(2).Columns("Level").Expression = "IIF([New Score] < 15, 'Low', 'High')"
How do I get more than a true/false conditional expression?