J
Jon Rowlan
I have a simple query which is a crosstab that had Area Salesman, customer
code and year.
Each column is month sales from month 1 to 12.
At the end of the report, I need to put a block in for each year for totals.
Report totals is a subreport summarising the data and representing it in a
similar fashion to the customer details.
Both reports are based upon exactly the same query, the summary is simply
grouped by Year.
If I do not link the Salesman, Customer and year fields between the 2
reports I get all data reported on even though my main report is filtered to
a specific customer and salesman etc. But if I link all three fields I get a
single row for 2005 and nothing else.
No other combination seems to work. I need the summary to reflect the filter
criteria too.
Can someone tell me where I am going wrong?
thanks,
jON
Salesman
customer Jan Feb May
2003
2005
customer Jan Feb May
2003
2005
Report Totals Jan Feb May
2003
2004
2005
code and year.
Each column is month sales from month 1 to 12.
At the end of the report, I need to put a block in for each year for totals.
Report totals is a subreport summarising the data and representing it in a
similar fashion to the customer details.
Both reports are based upon exactly the same query, the summary is simply
grouped by Year.
If I do not link the Salesman, Customer and year fields between the 2
reports I get all data reported on even though my main report is filtered to
a specific customer and salesman etc. But if I link all three fields I get a
single row for 2005 and nothing else.
No other combination seems to work. I need the summary to reflect the filter
criteria too.
Can someone tell me where I am going wrong?
thanks,
jON
Salesman
customer Jan Feb May
2003
2005
customer Jan Feb May
2003
2005
Report Totals Jan Feb May
2003
2004
2005