I am using CR XI Pro
I have table of sales data
I have table of call data
I have a table of employee data
each employee will have multiple calls and sales.
My sales data is coming from Salesforce.com and the other two from MS Access.
I would like to group the report by week, month, qtr year
BUT I want the call data in the same week as the sales data on the same line. Is this possible.
Fields I group on are "created by" date in call data and "close date" in sales data.
I have table of sales data
I have table of call data
I have a table of employee data
each employee will have multiple calls and sales.
My sales data is coming from Salesforce.com and the other two from MS Access.
I would like to group the report by week, month, qtr year
BUT I want the call data in the same week as the sales data on the same line. Is this possible.
Fields I group on are "created by" date in call data and "close date" in sales data.