 |
| |
| Addition of calculated totals that group / sort the values in a report footer.Posted: 22 Jan 2012 Tags: Addition of calculated totals that group sort the values in a report footer Addition calculated totals that group sort the values report footer  Source: www.jegsworks.com Question: I created a report which we use as a work order to produce products. I have included in the report footer calculated control which list the sum of the different elements necessary for the Assembly of products.A component varies depending on the size and color. I want that the total shown in the footer of this component together accordingly.I have 4 different colors and 6 different sizes of each color. I do not want to use the report grouping feature because I am already grouping/sorting the report on another more appropriate field. Can I do this? Any help is greatly appreciated. Answer: If you want that all shown size/colour combinations use expressions and the following lines:= Sum ([Quantity] * IIf ([Product] = "XYZ" and [size] = 3 and [color] = "Blue", 1, 0)) If you only want to display those size/color combinations represented in the report using a subreport that is based on a query that restricts the result for the product in question and by the size and color of the groups and summarizes the amount of components. Rate this article:
|
Home
Add Your Article
Categories
Search Something
Latest Buzz
Related Buzz
0 Comments