General information
Category:
Reports & Report designer
Hi all to the the good people of Universalthread:
I have a problem that is driving me mad. I am trying to calcualate the values of total hours depending on the type of job in my cursor. Fox example, if job is "Labor" then calculate the total hours for Labor and so on. I want to place the value of total hours at the header level. What I did was to create a variable call nHours in the report variable and store creport.hours in the nHours and selected Sum option from calculate box. In the printwhen section I enter :
IIF(Between(creport.type,1,2),sum(nhours),0) && (1..2 is labor)
The result that I get is zero. Now I know this is not true. What can I do to accomplish the output that I want.
Thanks alot
MA
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only