Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Blank Chart 1

Status
Not open for further replies.

corycrum

Technical User
Jan 10, 2007
36
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top