chriscardwell06
Registered User.
- Local time
- Today, 13:42
- Joined
- Aug 18, 2011
- Messages
- 38
I am creating a report from a database we have. Each item has a product code. I want to list each product code as one item on the report and then it display the average number of days it takes to design that product code. I have a field that has the product code as well as the days for each record. The problem I'm having is getting the report to display just one record with the average. I tried writing an expression inside a single text box but then I get a text box for every record and it just always populates zero. The continuous reports I can do but the one my boss wants here isn't very easy. It needs to list each product code and then a chart at the bottom to show the percentages of our work in the form of each code.