From Mahmood:
1) I am using SUM function in the report designer to calculate the sum of my 'hour' column. For example, SUM(creport.hours). (Hours are numeric value) I am getting an error "SUM.prg does not exist" How can I calculate the sum of the values on the report?
-----> At the summary band, copy hour field and double click:
1. the report expression window will appear
2. click the calculation button
3. select the sum option
4. you can reset the sum expression at the reset combo box..
Computes the additive sum of the expression's values. This option keeps a running total of the expression values for a group, page, column, or report (depending on your selection in the Reset box).
2) I have a variable named 'ntype'. Ntype has numbers from 1 through 5. Example: 1 = Material 2=Labor 3= Direct etc. I want to place the definition of my ntype (material, labor, direct) in my report. How can I accomplish this???
-----> Instead of putting the field nType in the Field Control on your report:
Just use this one:
IIF(nType = 1,"Material",IIF(nType=2,"Labor",IIF(nType=3,"Direct","")))
Be sure that the expression not exceed in 254 characters....