S
Sydney
Hello!
WHAT I WANT TO DO:
I'm trying to build a report that will summarize quarterly data for
each of my company's locations and display it along side aggregate
data.
PROBLEM ENCOUNTERED:
I built a table with five columns (item, all count, all %, location
count, location %), but I can only get it to display the location
count and % in both sets of columns.
MY LEVEL OF EXPERIENCE:
I've never used the reporting function before and I'm finding both my
Missing Manual and usual on-line resources (Lynda.com, microsoft.com)
to be pretty thin on anything beyond the most basic reporting
functions. Certainly nothing about how to put together a table with
data from two different queries. (Unless you can use the same query
but somehow set the parameters differently for two columns?)
ADDITIONAL INFORMATION ABOUT MY DATA:
My company has several different kinds of locations (e.g. warehouse,
retail, express retail) that each need to be aggregated separately.
I'd like my report to display something along these lines:
--------
Report Header: [Warehouse] Report - [Q1 2010]
Page Header: [Warehouse] [5]
Table 1) Items in Stock
Table Column Headers: Item, All Warehouses Count, All Warehouses %,
Warehouse 5 Count, Warehouse 5 %
Table 2) Employees by Role
Table Column Headers: Job Role, All Warehouses Count, All Warehouses
%, Warehouse 5 Count, Warehouse 5 %
Table 3) Employees by Year
Table Column Headers: Year, All Warehouses Count, All Warehouses %,
Warehouse 5 Count, Warehouse 5 %
--------
In my ideal world, when I open the report, it will ask me to choose
the year, quarter, location type and specific location. Then all I'll
have to do is pdf it and send it off to the location in question,
rather than my current rather labor-intensive process of manual
changing all the values in a report template in Publisher.
THANK YOU in advance for any help you can offer!!
WHAT I WANT TO DO:
I'm trying to build a report that will summarize quarterly data for
each of my company's locations and display it along side aggregate
data.
PROBLEM ENCOUNTERED:
I built a table with five columns (item, all count, all %, location
count, location %), but I can only get it to display the location
count and % in both sets of columns.
MY LEVEL OF EXPERIENCE:
I've never used the reporting function before and I'm finding both my
Missing Manual and usual on-line resources (Lynda.com, microsoft.com)
to be pretty thin on anything beyond the most basic reporting
functions. Certainly nothing about how to put together a table with
data from two different queries. (Unless you can use the same query
but somehow set the parameters differently for two columns?)
ADDITIONAL INFORMATION ABOUT MY DATA:
My company has several different kinds of locations (e.g. warehouse,
retail, express retail) that each need to be aggregated separately.
I'd like my report to display something along these lines:
--------
Report Header: [Warehouse] Report - [Q1 2010]
Page Header: [Warehouse] [5]
Table 1) Items in Stock
Table Column Headers: Item, All Warehouses Count, All Warehouses %,
Warehouse 5 Count, Warehouse 5 %
Table 2) Employees by Role
Table Column Headers: Job Role, All Warehouses Count, All Warehouses
%, Warehouse 5 Count, Warehouse 5 %
Table 3) Employees by Year
Table Column Headers: Year, All Warehouses Count, All Warehouses %,
Warehouse 5 Count, Warehouse 5 %
--------
In my ideal world, when I open the report, it will ask me to choose
the year, quarter, location type and specific location. Then all I'll
have to do is pdf it and send it off to the location in question,
rather than my current rather labor-intensive process of manual
changing all the values in a report template in Publisher.
THANK YOU in advance for any help you can offer!!