Custom report for boss lady?!?!?!?!

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.
 
do you have many fields in your record source for each time frame the products code has taken to design.
 

Users who are viewing this thread

Back
Top Bottom