Data Report (Calculated field problem) 
Author Message
 Data Report (Calculated field problem)

I'm using VB 6.0, with the data Report, and I want to create a report like
this example:
Location             Total Weight       Net Weight      % of Discount
    1                            15.924              12.523
21 %
    2                            19.514              14.323
27 %
TOTAL                       35.438              28.846                19 %
The problem is that this listing is a Sum of Weights of every Location and
de field % of discount is a calculated field (---> =(1-(Net Weight/Total
Weight))*100 ). In a detailed report it's easy to put there this calculeted
field, but in a Sum like this example I don't know how to do it (except with
a average function, wich is not the same). Further more, How can I limit
this listing by dates, wich the program inputs to the user.
Can someone help me.
Thank's


Sat, 15 Sep 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Calculating Data with MS Data Reports

2. REPORTS: Using Global Variable to re-calculate bound field

3. REPORTS: Using Global Variable to re-calculate bound field

4. Creating calculated field on report

5. Calculated fields in a report

6. Calculated fields in a report

7. Calculated fields in a report

8. Calculating the product of row data on a single field

9. Losing Calculated Form Field Data after File Save

10. data control, forms, calculated fields?

11. Calculated Heading in Data Report

12. Calculated Fields problem

 

 
Powered by phpBB® Forum Software