Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Using an aggregate from one dataset in matrix assigned to a different dataset
9 views
Skip to first unread message
ke...@kevinbrennan.info
Nov 2, 2012, 5:33:46 PM11/2/12
to
I cant seem to find the answer to whether or not a matrix is the correct control to use for this scenario.
Im trying to produce a report that will show the average number of widgets produced by a group of widget makers in a given period of time. For example, over a two week period, Group 1 which has 3 widget makers, produced 3 widgets; while Group 2 which has 2 widget makers, produced 10. In the first dataset, i am bringing back the widget production; in the second dataset, I am bring back the count of widget makers in each Group. In my scenario, while Group 1 made 3 widgets, only 2 of them participated (one made 2, and the other made 1, while the 3rd maker did nothing). In Group 2, one made 7 widgets and the other made 3.
Id like to be able to, in one report show the breakdown by group to include total number of widgets produced over time, and average number of widgets produced by the group (considering everyone who COULD have produced, not just those who did).
[I know that I can use a subreport to get most of what I need, but I've been led to believe that a matrix can do it all for me.]
Thanks in advance.
Im trying to produce a report that will show the average number of widgets produced by a group of widget makers in a given period of time. For example, over a two week period, Group 1 which has 3 widget makers, produced 3 widgets; while Group 2 which has 2 widget makers, produced 10. In the first dataset, i am bringing back the widget production; in the second dataset, I am bring back the count of widget makers in each Group. In my scenario, while Group 1 made 3 widgets, only 2 of them participated (one made 2, and the other made 1, while the 3rd maker did nothing). In Group 2, one made 7 widgets and the other made 3.
Id like to be able to, in one report show the breakdown by group to include total number of widgets produced over time, and average number of widgets produced by the group (considering everyone who COULD have produced, not just those who did).
[I know that I can use a subreport to get most of what I need, but I've been led to believe that a matrix can do it all for me.]
Thanks in advance.
0 new messages