P
pib311 via AccessMonster.com
Hello everyone,
I am coming to a point where I need some assistance. I have a report I need
to build that has different metrics by function - FTE, Spend, Length of Time,
etc.
The issue is that they all have different field values, so FTE is by month,
Spend is by quarter, and I cannot include them in one query or data set for a
report. I am trying to figure out a way that I can use subreports but produce
the end report by Function. It would look something like this:
FTE
Hamburgers Month1 Month2 Month3 Month 4
Item 1 25 38 74 28
Item 2 249 222 110 293
Cost
Hamburgers Quarter1 Quarter2 Quarter3 Quarter4
Item 1 25 38 74 28
Item 2 249 222 110 293
-New Page-
Same thing with new food group
I don't think its possible, but thought I would check.
Thanks!
I am coming to a point where I need some assistance. I have a report I need
to build that has different metrics by function - FTE, Spend, Length of Time,
etc.
The issue is that they all have different field values, so FTE is by month,
Spend is by quarter, and I cannot include them in one query or data set for a
report. I am trying to figure out a way that I can use subreports but produce
the end report by Function. It would look something like this:
FTE
Hamburgers Month1 Month2 Month3 Month 4
Item 1 25 38 74 28
Item 2 249 222 110 293
Cost
Hamburgers Quarter1 Quarter2 Quarter3 Quarter4
Item 1 25 38 74 28
Item 2 249 222 110 293
-New Page-
Same thing with new food group
I don't think its possible, but thought I would check.
Thanks!