Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sum
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Sum
Miscellaneous
Thread ID:
00459753
Message ID:
00459753
Views:
62
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
Map
View

Click here to load this message in the networking platform