Hi,
I would like to create a simple report with a bar chart to show sales by team, by employee. The report is based on a simple table (T_Sales_By_Team). T_Sales_By_Team has the following fields:
TeamName
EmployeeName
Sales
I have created a report that groups on the TeamName field. I have inserted a bar chart in the TeamName footer. If I set the Link Master/Child fields to TeamName, the chart is blank when in preview mode. If remove the Link Master/Child fields the chart populates with data, but it shows data for all employees for all teams on every chart. I want the chart to update with new employee names as I cycle from one TeamName to the next. I don't want to display all employees on all charts. What am I missing?
I would like to create a simple report with a bar chart to show sales by team, by employee. The report is based on a simple table (T_Sales_By_Team). T_Sales_By_Team has the following fields:
TeamName
EmployeeName
Sales
I have created a report that groups on the TeamName field. I have inserted a bar chart in the TeamName footer. If I set the Link Master/Child fields to TeamName, the chart is blank when in preview mode. If remove the Link Master/Child fields the chart populates with data, but it shows data for all employees for all teams on every chart. I want the chart to update with new employee names as I cycle from one TeamName to the next. I don't want to display all employees on all charts. What am I missing?