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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by volkyl
-
How to dynamically build database field name
Thanks IDO! You are more helpful than Crystal's support! That approach did indeed work. When looking at the documentation for the Choose function, it says that all of the arguments following the first must be of the same type. What type is a database field such as {price_tier1} or...- volkyl
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
How to dynamically build database field name
The objective is to calculate a total cost based upon the different prices in each price_tier (and incidentally, quantities in another group of columns: qty_tier1, qty_tier2, qty_tier3, etc.). The formula will eventually do a comparison between the current tier, table.price_tier(i), and the...- volkyl
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
How to dynamically build database field name
I have columns in my DB as such: price_tier1 price_tier2 price_tier3 etc... I have a for loop wherein I'd like to iteratively pull back the value in each column: for i := 1 to 10 do ( tierColumn = "table.price_tier" + Cstr(i); tier := {tierColumn} )...- volkyl
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
